SQL Command – Dump & load MySQL database

SQL Command

Dump MySQL database
Type the following command in command-line console.

mysqldump -u userxxx -p --databases dbyyy > /abc/def/mysqldump_yyy.sql

Load MySQL database
Type the following command in command-line console.

mysql -u userxxx -p < /aaa/bbb/yyy.sql

oliver

Leave a Reply

Your email address will not be published. Required fields are marked *


*