13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Exporting data into MySql sql file
| Line 25: | Line 25: | ||
'''method2''': Bulk export | '''method2''': Bulk export individual tables into the multiple compressed *.sql files | ||
<pre> | <pre> | ||
mysqldump -h localhost -u username -pPASSWORD --force --single-transaction --default-character-set=utf8 DB_NAME TABLE_1 | pv | gzip -c > table_1.sql.gz | mysqldump -h localhost -u username -pPASSWORD --force --single-transaction --default-character-set=utf8 DB_NAME TABLE_1 | pv | gzip -c > table_1.sql.gz | ||