mysqldump

// backup с локального компьютера
# mysqldump --all-databases --user=dba --password=mypass -A > mysql_backup.dmp


// backup с удаленного компьютера
ssh [email protected] /usr/bin/mysqldump --all-databases --user=dba --password=mypass -A > mysql_backup.dmp

Создание бекапов, траблшутинг и т.д.
http://centoshelp.org/servers/database/installing-configuring-mysql-server/


dump

export

mysqldump -u [username] -p [database_name] > [dumpfilename.sql]

import

mysql -u [username] -p [database_name] < [dumpfilename.sql]

Со сжатием:

For Export:

mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz]

For Import:

gunzip < [compressed_filename.sql.gz]  | mysql -u [user] -p[password] [databasename]