Click here to Skip to main content
14,332,555 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to restore Mysql database using sql command or using batch file
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Drop ur database

mysqladmin -u USERNAME -p drop DATABASE_NAME


Recreate the database

mysqladmin -u USERNAME -p create DATABASE_NAME


Import Backup

mysql -u USERNAME -p DATABASE_NAME <filename.mysql></filename.mysql>


I think this will work for you....Cheers !!!!! Happy Christmas ...
   
v2
Comments
RDBurmon 21-Dec-10 5:30am
   
But jewel where he address the path for back file ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100