MySQL

From Psygen Wiki
Jump to navigation Jump to search

Note: never use kill to kill MySQL. Use service, or systemctl instead.

Backup and Restore

To backup (dump) a single database:
mysqldump database_name > database_name.sql

Backup all databases:
mysqldump --all-databases > all_databases.sql

Version

See: Software Versions to check the installed version.