MySQL

From Psygen Wiki

Revision as of 04:34, 17 February 2017 by Admin (talk | contribs) (→‎Backup and Restore)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

Retrieved from "https://wiki.psygen.org/index.php?title=MySQL&oldid=316"