Mysql generate table insert query using mysqldump

Mysql generate table insert query using command

Solution:
use mysqldump to generate table script
Example:
Echo off
Echo ***Please Wait DataBase Transfering***
(cd C:\ && ^
mysqldump --extended-insert=FALSE --complete-insert=TRUE --skip-add-drop-table -h 192.168.1.225 -u root -psiva@1234 --port=3306  accountsreportdb cloudsetting)> transferlog150331.txt  2>&1
Echo ***
Timeout 10

Post a Comment

1 Comments