How to get mysql Database dump and restore database
Hello,
1.You can use following commands for taking mysql dump in .sql format
go to /var/lib/mysql
search for the database whose dump you want.
ls -l | grep database_name
mysqldump database_name > database.sql
2. If the mysql dumpis available and you want to restore that you need to use following command for that
cd /var/lib/mysql
check the database name where you want to restore the mysqldump
ls -l | grep database_name
mysql database_name < database.sql
Bookmark This Post:
Harry said,
January 19, 2007 @ 3:02 pm
When restoring your data back you should create an empty database, or at least a database which does not contain any tables of the same name as those within your dump database.