Restoring a MySQL database
Perhaps somebody can point me in the right direction. I have a MySQL database that I inadvertently deleted all records from. There is a regular backup I have which I can access, but I have no idea where the MySQL database tables reside in the system.
I have the root password and complete access to the commands to restore the files from the backup. I'm just missing the location and have no idea where to look. I'd appreciate any suggestions or pointers.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 22, 2009 7:33 PM
UPDATED:
April 24, 2012 7:09 PM
Answer Wiki:
From a command prompt, you can backup your entire database using this line:
mysqldump -u user_name -p your_password database_name > File_name.sql
Example:
Let's assume that:
Username: bobbyjoe
Password: happy234
Database Name: BobsData
mysqldump -u bobbyjoe -p happy234 BobsData > BobBackup.sql
This will backup the database to a file called BobBackup.sql
To restore the database CANNOT already exist:
This will only work if the database does not already exist:
mysql - u user_name -p your_password database_name < file_name.sql
Or using our example from the previous page:
mysql - u bobbyjoe -p happy234 BobsData < BobBackup.sql
If your database already exists and you are just restoring it, try this line instead:
mysqlimport -u user_name -p your_password database_name file_name.sql
Or using our example again:
mysqlimport -u bobbyjoe -p happy234 BobsData BobBackup.sql
To see all answers submitted to the Answer Wiki: View Answer History.
You may come back mysql database records owing to following way
mysql fix
application restores mysql data in cases system errors, power failures and etc.