Shulou(Shulou.com)05/31 Report--

This article mainly explains the "how to export or import the remote server MYSQL database", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to export or import the remote server MYSQL database"!

First of all, let's learn how to export the MYSQL database of a remote server. There are several ways to do this:

MYSQL database export

The first one is derived from the PHPMYADMIN management tool provided by space merchants, which is relatively simple. We will not talk much about it here if we check the information.

The second method is exported using the mysqldump management tool that comes with MYSQL installation:

1) start menu in the lower left corner-> run-> CMD enter the DOS command line state

2) enter: CD D:\ Program Files\ MySQL\ MySQL Server 5.0\ bin >

D:\ Program Files\ MySQL\ MySQL Server 5.0\ bin > is your installation directory for MYSQL, and\ bin is the directory where all the mysqldump management tools are located

3) the export syntax is:

Mysqldump-h [hosname]-u [user _ name]-p [password]-- default-character-set= [char _ set_name] [db_name] > [save_path]

Example: then enter: mysqldump-h219.12.12.11-umysqluser-pmysqlpwd-- default-character-set=utf8 dbname-- skip-lock-tables > d:\ sqlname.sql

119.12.12.11: remote server IP,-umysqluser mysqluser is the database user name,-pmysqlpwd mysqlpwd is the user password, set=utf8 is the encoding format of the exported MYSQL, dbname is the database name to be exported, > d:\ sqlname.sql is the storage path imported to your local, china_net.sql you are free to name!

MYSQL Import

If the MYSQL database is smaller than 2MB, you can import it with dump management tools, but not if the size of 2MB is not good, because the PHPMYADMIN management tools provided by space vendors can only import data smaller than 2MB, which makes some webmasters using MYSQL databases depressed.

Now start to teach you how to use mysqldump management tools to import data larger than 2MB.

1) start menu in the lower left corner-> run-> CMD enter the DOS command line state

2) D:\ Program Files\ MySQL\ MySQL Server 5.0\ bin > is the MYSQL installation directory you installed, and\ bin is the directory where all the mysqldump management tools are located

3) then enter: mysql-h219.12.12.11-umysqluser-pmysqlpwd dbname < d:\ sqlname.sql

Note: d:\ sqlname.sql, if the user does not have the permission to create the database, the user cannot import d:\ sqlname., otherwise d:\ sqlname.sql can only be multiple tables or it will make an error.

Thank you for your reading, the above is the content of "how to export or import the remote server MYSQL database". After the study of this article, I believe you have a deeper understanding of how to export or import the remote server MYSQL database, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.