How can I restore a backup of a MySQL database?

by on July 29, 2006 · 1 comment· LAST UPDATED May 3, 2008

in , ,

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:

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 1 comment… read it below or add one }

1 Kenan Bektas October 11, 2006 at 3:08 am

This FAQ kust rocks. Great tips.

Cheers,.

-Kenan

Reply

Leave a Comment

Tagged as: , , , , , , , , ,

Previous Faq:

Next Faq: