Introduction to mysql import and export database as well as functions and stored procedures

  • 2020-05-27 07:20:12
  • OfStack

mysql commonly used export data commands:
1.mysql exports the entire database
mysqldump -hhostname -uusername -ppassword databasename > backupfile. sql
mysqldump -hlocalhost -uroot hqgr > hqgr.sql (if the user of root doesn't have a password, you can not write -p. Of course, you can make a path for the exported sql file. If it is not specified, it will be stored in the bin directory of mysql)

2.mysql exports 1 database table
mysqldump-hhostname-uusername-ppassword database tablename > Exported file name
mysqldump-hlocalhost-uroot hqgr t_ug_user > user.sql

3.mysql exports 1 database structure
mysqldump-hhostname-uusername-ppassword-d -- add-drop-table databasename > d:hqgrstructure.sql
-d has no data -- add-drop-table adds 1 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
Where -ntd is the exported stored procedure; -R is the derived function

mysql commonly used commands to import data:
1. mysql command
mysql -hhostname -uusername - ppassword databasename < backupfile.sql
2. source command
mysql > source backupfile.sql

Related articles: