first, the use of Pg_dump:Import and export of databases is one of the most commonly used features, each of which provides tools for this, such as Oracle's Exp/imp,informix Dbexp/dbimp,mysql mysqldump, and PostgreSQL provides a corresponding tool
PostgreSQL tutorial (18): client commands (2), postgresql tutorial
VII. pg_dump:
Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking
first, the use of Pg_dump:Import and export of databases is one of the most commonly used features, each of which provides tools for this, such as Oracle's Exp/imp,informix Dbexp/dbimp,mysql mysqldump, and PostgreSQL provides a corresponding tool
http://www.cnblogs.com/chenmh/p/5300370.html IntroductionIn daily maintenance work often need to export the data, and mysqldump is to export the data process is a very frequent use of a tool, it comes with a lot of function parameters, the article
PostgreSQL quickly writes/reads large amounts of data http://www.cnblogs.com/podolski/p/7152144.htmlEnvironment and testingUse. NET driver Npgsql to connect to the post database. Configuration: Win10 x64, i5-4590, 16G DDR3, SSD 850EVO.PostgreSQL 9.6.
Usage of the mysqldump command1. Export all librariesSystem command LineMysqldump-uusername-ppassword--all-databases > All.sql2. Import all librariesMySQL command lineMysql>source All.sql;3. Export some librariesSystem command
Use of the mysqldump command
1. Export all libraries
System command Line
Mysqldump-uusername-ppassword--all-databases > All.sql
2. Import all libraries
MySQL command line
Mysql>source All.sql;
3. Export some libraries
System command Line
This article mainly introduces the mysqldump command for importing and exporting database methods and instance summary. if you need it, refer to the usage of mysqldump command.
1. export all databases
System command
Seven, Pg_dump:
Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by
1. Install phpPgAdminDecompress the downloaded package
Run the following command for tar.gz:
Copy codeThe Code is as follows: gunzip phpPgAdmin-* .tar.gzTar-xvf phpPgAdmin-*. tar
Run the following command for tar.bz2:
Copy codeThe Code is as follows:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.