User Tools

Site Tools


mysql_mysqldump_table

Dumping a mysql table

# mysqlshow

#mysqlshow database
Dump
mysqldump db_name table_name > table_name.sql
Dump using PV
mysqldump db_name table_name | pv > database.table.$(date +"%Y-%m-%d").sql

Importing a table


mysql_mysqldump_table.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki