How to use Winx system to export MySQL table data using CMD command

  

How Win7 System Uses CMD Command to Export MySQL Table Data

Operation Method:

1. Run the command prompt in the Start menu:

2. Then enter the command. :

Suppose you export the t_article_base table data from the tomtopportal database to the E:/xitongcheng.com.txt file. Execute the command as follows:

mysqldump -h localhost -u root -p tomtopportal t_article_base >e:xitongcheng.com.txt

3, the command line indicates the input mysql root user password (mysql installation Is the set password), the correct input of the password can be successfully exported.

Copyright © Windows knowledge All Rights Reserved