User Tools
linux:general:mysql
Table of Contents
This is an old revision of the document!
MySQL
Install
Configure
Backup and Restore
Backup
Backup a single Table in a database
mysqldump <db> <table> > dump.sql
Backup all tables in a single database
mysqldump <db> > dump.sql
Backup all tables in all databases
mysqldump --all-databases > dump.sql
Restore
mysql < dump.sql
Commands
| Command | Function |
|---|---|
| mysqldump | - |
| mysqlcheck --repair --databases <db> | Repair data types and character sets of a single db changed by updates |
| mysqlcheck --repair --all-databases | Repair data types and character sets of all dbs changed by updates |
Troubleshooting
Links
linux/general/mysql.1559823586.txt.gz · Last modified: 2019/06/06 14:19 by lunetikk
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
