So-today I wanted to learn-to-export a Drupal database to a file quickly. Back on the day I would ' ve logged in through CPanel and navigated to PHPMyAdmin, then manually select an export of the DAT Abase and has to choose where to save the file.
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
How to import and export with MySQL dumpCategory: Database 2009-12-08 00:04 6825 People read comments (0) favorite reports MySQL database deleteinsertinternetdatabaseMySQL Utility commandsWikipedia, the free encyclopediaA) connect to
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
Basic use of dump backup and restore restore Dump is a powerful backup tool that allows you to create levels in addition to backing up the entire file system! How to understand, can be understood as MySQL differential backup, if your home/home is a
MySQL uses commands to import and export instances for. SQL file backup data operations
In order to pursue efficiency, various MySQL operations are basically completed through a graphical interface. A few mouse clicks, ALL over. However, in a
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
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
MySQL programming on linux (4): Data Import and Export and backup, mysql Import and Export[Copyright statement: respect originality. Reprinted and reprinted. Retained for Source: blog.csdn.net/shallnet. this document only serves for learning and
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.