Backing Up MySQL from a computer to another

alamba ulist at gs1.ubuntuforums.org
Tue May 2 07:30:59 UTC 2006


1. Backup the database:
mysqldump -u root --opt sugarcrm > backup-file.sql

2. Restore to a new mysql database:
mysql sugarcrm < backup-file.sql

You can always move the backup file to another system via scp, ftp,
samba, etc. See this link too
http://dev.mysql.com/doc/refman/5.0/en/backup.html

A


-- 
alamba




More information about the ubuntu-users mailing list