Yephy Wang

Category Archives: Experience

Linux import & export MySQL database commands

1st, export the database 1. Export complete data: table structure + data Under Linux, you can use the mysqldump command to export the database. The syntax is as follows: mysqldump -u username -p DatabaseName > DatabaseName.sql The following command can export the data and table structure of abc database: # /usr/local/mysql/bin/mysqldump -uroot -p abc > […]