15,041
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Exporting entire data
| Line 25: | Line 25: | ||
# ask to enter {{kbd | key = <nowiki>password</nowiki> }} and press {{kbd | key = <nowiki>Enter</nowiki> }} | # ask to enter {{kbd | key = <nowiki>password</nowiki> }} and press {{kbd | key = <nowiki>Enter</nowiki> }} | ||
optional: Append the Today's date to file name | |||
* On {{Linux}}: (for InnoDB tables){{kbd | key = <nowiki>mysqldump -h localhost -u username -p --force --single-transaction --default-character-set=utf8 DATA_BASE_NAME | pv | gzip -c > database.sql.$(date +"%y%m%d").gz</nowiki>}} | |||
'''method2''': Bulk export individual tables into the multiple compressed *.sql files | '''method2''': Bulk export individual tables into the multiple compressed *.sql files | ||