MySQL Dump/Restore, Dumping MySQL Database and Tables using MysqlDump command

Dumping MySQL Database using MysqlDump command

Dumping all available databases in MySQL

mysqldump --user=USERNAME --password=PASSWORD -A > FOLDER/DUMP_FILE.SQL

Dumping some of the databases in your MySQL Database

mysqldump --user=USERNAME --password=PASSWORD --databases DATABASE_1 DATABASE_2 > FOLDER/DUMP_FILE.SQL

Dumping some of the tables in a database

mysqldump --user=USERNAME --password=PASSWORD --databases DATABASE --tables TABLE > FOLDER/DUMP_FILE.SQL

If production, development, publishing versions of your MySQL system are different, then you may use the given command to provide concurrency.

--compatible=mysql323

Restoring MySQL Dump Files

You may run the command given below to restore previously dumped mysql archieve

mysql --verbose --user=USERNAME --password=PASSWORD DATABASE < FOLDER/DUMP_FILE.SQL

Example values

USERNAME: root
PASSWORD: 555555
DATABASE: db_askfoxes
TABLE: tbl_content
WINDOWS FOLDER: d://dumps/
LINUX FOLDER: /var/www/dump/


added 4 years ago

- What does chess ELO ratings mean?
- WAMP Mysqli: Your password has expired
- Search Engine optimization: Google's 200 Ranking Factors
- MySQL Dump/Restore, Dumping MySQL Database and Tables using MysqlDump command
- iPhone 4S vs iPhone 5 vs Samsung Galaxy S3 comparison results
- Source Code of Matrix Multiplication
- How to Install Oracle Java on Ubuntu Linux? Java Performance Problems
- How to create your own PHP caching system? A simple example
- What is CSS and why is it useful?
- Domain Life Cycle
- How to Use a Router as a Repeater?
- Comparison of Random Functions According to their Exploration Performance (STL, .NET, Java)
- How to install Memcached on Win 7 + WAMP Server, the simplest way of all
- How to draw double buffered in C# or Java using GDI+
- How to restart page numbering for each chapter in Word 2007 – 2010
- How to recover Ubuntu after installing Windows using Ubuntu live cd