MySQL
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.