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 41: | Line 41: | ||
# {{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 | '''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 original table once. | ||
=== Exporting selected data of database/table into MySql sql file === | === Exporting selected data of database/table into MySql sql file === | ||