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
Also check out a script to backup all databases from my collegue Tom wiki.tmade.de - Backup MySQL
Restore
mysql < dump.sql
Also check out a script to restore databases from my collegue Tom wiki.tmade.de - Restore MySQL
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 |
| mysql -uroot -p -h 127.0.0.1 -P 3306 | Connect to mysql, enter password after execution |
Troubleshooting
Links
linux/general/mysql.1560768608.txt.gz · Last modified: 2019/06/17 12:50 by lunetikk
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
