2,187
edits
Difference between revisions of "Maintenance (MySQL)"
Jump to navigation
Jump to search
→Export / Backup: Added Create a Copy of a Table
(Initial creation - content from MySQL page (now category)) |
(→Export / Backup: Added Create a Copy of a Table) |
||
| Line 35: | Line 35: | ||
mysqldump -u root -p dbname > dbname.sql # Basic dump | mysqldump -u root -p dbname > dbname.sql # Basic dump | ||
mysqldump -u root -p dbname | dbname.sql.gz # Create a compressed dump | mysqldump -u root -p dbname | dbname.sql.gz # Create a compressed dump | ||
# Backup one table only | |||
mysqldump -u root -p dbname tablename > db_table.sql | |||
# Exclude certain tables | # Exclude certain tables | ||
| Line 44: | Line 47: | ||
LINES TERMINATED BY '\n' FROM table; | LINES TERMINATED BY '\n' FROM table; | ||
</source> | </source> | ||
=== Create a Copy of a Table === | |||
# Export the table | |||
#* EG <code>mysqldump -u root -p database table > /var/tmp/db_table.sql </code> | |||
# Edit the dump to provide new table name | |||
#* EG <code> vi /var/tmp/db_table.sql</code> | |||
#* EG <code>:%s/table/table_new/g</code> | |||
# Import the new table in | |||
#* EG <code>mysql -u root -p < /var/tmp/db_table.sql </code> | |||
== Corruption == | == Corruption == | ||