how to upload .DUMP db file

[imrannazir]

Hello i have big problem , my all previous backup of database are in .DUMP format

can anyone please tell me how can restore it to my new host phpmyadmin

 

[cvrle77]

If the database you want to restore doesn't already exist, you need to create it first.

On the command-line, if you're in the same directory that contains the dumped file, use these commands (with appropriate substitutions):

root#> mysql -u root -p

mysql> create database YOUR_ORIGINAL_DBNAME;
mysql> use YOUR_ORIGINAL_DBNAME;
mysql> source db_backup.dump;

or:

mysql -p -u[user] [database] < db_backup.dump

 

[imrannazir]

my problem is not fixed yet

, if anyone fix it i will pay $10