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

This article mainly explains "mysql import and export database and function process", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn the "mysql import and export database and function process" it!

Commonly used export data commands:

1.mysql exports the entire database

Www.2cto.com

Mysqldump-hhostname-uusername-ppassword databasename > backupfile.sql

Mysqldump-hlocalhost-uroot hqgr > hqgr.sql (if the root user does not use the password, you do not have to write-p. Of course, you can make a path to the exported sql file, and store it in the bin directory of mysql if it is not specified)

2.mysql exports a table from the database

Mysqldump-hhostname-uusername-ppassword database tablename > exported file name

Mysqldump-hlocalhost-uroot hqgr t_ug_user > user.sql

3.mysql exports a database structure

Mysqldump-hhostname-uusername-ppassword-d-add-drop-table databasename > d:hqgrstructure.sql

-d No data-- add-drop-table adds a drop table before each create statement

4. If you need to export functions or stored procedures in mysql

Mysqldump-hhostname-uusername-ppassword-ntd-R databasename > backupflie.sql

Mysqldump-hlocalhost-uroot-ntd-R hqgr > hqgr.sql

Www.2cto.com

Where-ntd is the export stored procedure;-R is the export function.

Commands commonly used by mysql to import data:

1.mysql command

Mysql-hhostname-uusername-ppassword databasename

Source backupfile.sql

At this point, I believe that everyone on the "mysql import and export database and function process" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.