Mysql Database Import and Export

Mysql Database Import and Export

Mysql Database Import and Export:

. SQL File Import mysql:

Assume that the database file to be imported is located at: d: \ test. SQL.

1. Enter the mysql command line window.

2. If the test. SQL file contains the create database ×××; Statement, the command is as follows: mysql> source d:/test. SQL;

If the test. SQL file does not contain the create database ×××; statement, there are two methods:

1: a database exists in mysql, such as test,

Then: mysql> use test;

Mysql> source d:/test. SQL;

2: Import test. SQL to a new database,

Then: 1: mysql> create database test;

Mysql> source d:/test. SQL;

Note: The file path must use a backslash "/"

You can use phpMyAdmin or phpMyAdmin to export mysql databases.