- backup as plain:
$ mysqldump -u root -p <DB Name> > backup-name.sql
- backup as gzip:
$ mysqldump -u [uname] -p[pass] [dbname] --routines | gzip -9 > [backupfile.sql.gz]
- restore script
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
- restore compressed
$ gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]