MySQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Note: never use <code>kill</code> to kill MySQL. Use <code>service</code>, or <code>systemctl</code> instead. | Note: never use <code>kill</code> to kill MySQL. Use <code>service</code>, or <code>systemctl</code> instead. | ||
== Backup and Restore == | |||
To backup (dump) a single database:<br /> | |||
<code>mysqldump <i>database_name</i> > <i>database_name.sql</i></code> | |||
== Version == | == Version == | ||
See: [[Software Versions]] to check the installed version. | See: [[Software Versions]] to check the installed version. | ||
Revision as of 19:58, 21 January 2017
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
Version
See: Software Versions to check the installed version.