How to import and export mysql Data

Tutorial for helping customers: Mysql, as a very powerful database software, still has many shortcomings in graphic interface management. Therefore, for webmasters, it is an important course to better master Mysql commands. Today, let's take a look at the most basic data import and export. In the future, the help House will continue to sort out relevant articles. You are welcome to read and learn.

Import

Start, Run, mysql installation directory \ bin \ mysql-u username-p, and then press ENTER

D: \ xampp \ mysql \ bin \ mysql-u root-p

Use pan;

Set names utf8;

Source c:/pan. SQL;

Export (character set format can be specified)

Start running, go to the mysql installation directory \ bin

D: Press enter.

Cd xampp \ mysql \ bin press ENTER

Mysql dump-u root-p Database Name> c:/tt. SQL

Then you can go to drive C to view the file you generated.