≡ Menu

How can I restore a backup of a MySQL database?

Q. I made MySQL backup using mysqldump -u user -h localhost -ppassword forumdb | -gzip -9 > forumdb.sql.gz command. How do I restore MySQL database backup using a shell prompt under Linux / UNIX operating system?

A. mysqldump command is text-based client or tool for dumping or backing up mysql databases, tables and or data. You can use same command as follows:
$ gunzip forumdb.gz
Now, restore using mysqldump:
$ mysqldump -u user -h localhost -ppassword forumdb < forumdb.sql
Alternatively, use mysql command as follows:
$ mysql -u user -h localhost -ppassword forumdb < forumdb.sql

See also:

{ 1 comment… add one }

  • Kenan Bektas October 11, 2006, 3:08 am

    This FAQ kust rocks. Great tips.



Leave a Comment

   Tagged with: , , , , , , , , ,