MySQL Import Database and database import

MySQL Tutorial Import Database tutorial and database import
/*
The current free backup tools supported by MySQL are:

Mysqldump, Mysqlhotcopy

, you can also use SQL syntax for backups:

Backup table

Or

SELECT INTO outfile

, or Backup

Binary log (Binlog)

Now for the small amount of data, you can directly use the PHP tutorial myadmin to complete the OK,
Let's talk about how phpMyAdmin imports data.

First, to carry out your phpMyAdmin, find the Import button, here will see a File upload box text file location (maximum limit: 2 MB) Click Upload your imported file OK.
Attachment: You will see (Maximum limit: 2 MB), let's see how to modify its size.
First, find php.ini Open, check to Post_max_size, upload_max_filesize settings you want to upload file size OK, back to Apache.

The second way to import large data is to use the command method.

MySQL Large data import

The first step: Mysql-h localhost-uroot

Log on to the database

Step two: show databases;

Print a database

Step three: Use Changchunmap;

Go to the appropriate database

SOURCE F:www.111cn.netdbname.sql

Import Database