MySQL database backup

export_dump.sh

# See http://webcheatsheet.com/SQL/mysql_backup_restore.php

# Backup
mysqldump -u user -pMyPassword databasename > databasename.sql

# Restore
# http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

# Drop the existing table
# Create the table
# Execute SQL with < to restore the database

# mysql -u root -ptmppassword

mysql> create database sugarcrm;
Query OK, 1 row affected (0.02 sec)

# mysql -u root -ptmppassword sugarcrm < /tmp/sugarcrm.sql

# Can also use phpMyAdmin
# Use the "iport" tool and upload the sql document
# http://webcheatsheet.com/SQL/mysql_backup_restore.php