mysql_mysqldump_table
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| mysql_mysqldump_table [2015/12/14 11:48] – created luke7858 | mysql_mysqldump_table [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| #mysqlshow database | #mysqlshow database | ||
| </ | </ | ||
| + | Dump | ||
| <sxh bash> | <sxh bash> | ||
| mysqldump db_name table_name > table_name.sql | mysqldump db_name table_name > table_name.sql | ||
| + | </ | ||
| + | Dump using PV | ||
| + | <sxh bash> | ||
| + | mysqldump db_name table_name | pv > database.table.$(date +" | ||
| + | </ | ||
| + | \\ | ||
| + | === Importing a table === | ||
| + | <sxh bash> | ||
| + | |||
| </ | </ | ||
mysql_mysqldump_table.1450093700.txt.gz · Last modified: 2024/05/23 07:26 (external edit)