13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Exporting entire data of database/table into MySql sql file
| Line 40: | Line 40: | ||
'''method4''': export the *.sql file | '''method4''': export the *.sql file | ||
# {{kbd | key = <nowiki>mysqldump -h localhost -u username -p --single-transaction --default-character-set=utf8 DATA-BASE-NAME > /path/to/database.sql </nowiki>}} | # {{kbd | key = <nowiki>mysqldump -h localhost -u username -p --single-transaction --default-character-set=utf8 DATA-BASE-NAME > /path/to/database.sql </nowiki>}} | ||
=== Exporting selected data of database/table into MySql sql file === | |||
[http://stackoverflow.com/questions/17397661/append-mysql-dump-to-a-table mysqldump - Append MYSQL dump to a table - Stack Overflow] {{access | date = 2016-06-29}} | |||
=== Importing data from MySql sql file === | === Importing data from MySql sql file === | ||