MySQL Backup and Restore

mysqldump -u root -p database_name > backup.sql # backup database

mysqldump -u root -p --all-databases > all_databases.sql # backup all

mysqldump -u root -p database_name table1 table2 > tables.sql # specific tables

mysql -u root -p database_name < backup.sql # restore from backup

mysqldump -u root -p database_name | gzip > backup.sql.gz # compressed backup
gunzip < backup.sql.gz | mysql -u root -p database_name # restore compressed

SELECT * FROM users
INTO OUTFILE '/tmp/users.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'; # export to CSV