Restore Your MySQL Database
Wednesday April 5, 2006
Restoring a MySQL database that has been removed is very easy if you have made a backup. You can also use this method to move an old database to a new server. It can be restored with a single line from the command prompt. Simply run: mysql - u user_name -p your_password database_name < file_name.sql
How do I restore a database that hasn’t been removed? Thanks.
Hi Justin -
Try this: mysqlimport -u user_name -p your_password database_name file_name.sql
Angela
Hi Angela, i have my backup file in different directory, How do i specify the path of that dir. can u plz help..
– Thanks in Advance.