Knowledge Base

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.

This article was:   Helpful | Not helpful Report an issue


Article ID: 226
Last updated: 08 Feb, 2010
Revision: 1
Views: 6024
Comments: 0
print  Print pdf  Export to PDF email  Subscribe share  Share pool  Add to pool comment  Add comment
External links

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