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.


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

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