Home Features Pricing Support Contact
Search:     Advanced search

How can I backup and restore database?

Article ID: 226
Last updated: 08 Feb, 2010

You can use mysqldump to create a simple backup of your database using the following syntax:

Backup: 

mysqldump -u [username] -p[password] -h[host] [databasename] > [backupfile.sql]

Restore:

 mysql -u [username] -p[password] -h[host] [databasename] < [backupfile.sql]

  • [username] - this is your database username
  • [password] - this is the password for your database
  • [databasename] - the name of your database
  • [host] - this is db hostname (optional)
  • [backupfile.sql] - the file to which the backup should be written/read.

Article ID: 226
Last updated: 08 Feb, 2010
Revision: 1
Views: 5116
Comments: 0
This article was:   Helpful | Not helpful
External links
Backing Up and Restoring Your MySQL Database

Prev   Next
Setting Up Folder Permissions in Internet Information Services...     How to change ft_min_word_len variable