Q:
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.
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.
ASKED:
Jan 22 2009 7:33 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+1
Click to Vote:
+1
Click to Vote:
- 1
0
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
