mysql-backup - w3toppers.com

Export and Import all MySQL databases at one time

Export: mysqldump -u root -p –all-databases > alldb.sql Look up the documentation for mysqldump. You may want to use some of the options mentioned in comments: mysqldump -u root -p –opt –all-databases > alldb.sql mysqldump -u root -p –all-databases –skip-lock-tables > alldb.sql Import: mysql -u root -p < alldb.sql

Automated or regular backup of mysql data

CSV and SELECT INTO OUTFILE http://dev.mysql.com/doc/refman/5.7/en/select-into.html SELECT … INTO OUTFILE writes the selected rows to a file. Column and line terminators can be specified to produce a specific output format. Here is a complete example: SELECT * FROM my_table INTO OUTFILE ‘/tmp/my_table.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ FROM … Read more