PrintLogo

Backing up and restoring MySQL databases




To back up MySQL, log on as the root user and run:

mysqldump --opt -u user -p dbname > {path}/backup.sql

To restore the database run:

mysql -u user -p dbname < {path}/backup.sql



This article comes from NetAdminTools:
http://www.netadmintools.com/

The URL for this story is:
http://www.netadmintools.com/art39.html

Copyright 1997-2007 NetAdminTools.com. Read our Terms of Use.