mysql: backup databases

Posted Leave a commentPosted in MySQL

Backups all databases mysqldump -u [user] -p[password] --all-databases > [filename].sql   specific databases mysqldump -u [user] -p[password] [database_name] > [filename].sql   restore mysqldump -u [user] -p[password] [database_name] < [filename].sql   backup specific table from a database mysqldump -u [user] -p[password] […]