15,041
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>}} | ||
'''method5''': Using phpmyadmin to export the database. {{exclaim}} But I found the number rows of table after imported was not the same with the number rows of table before imported once. | |||
=== Exporting selected data of database/table into MySql sql file === | === Exporting selected data of database/table into MySql sql file === | ||