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

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 5 years ago

- What is x-ray?
- The Wink home automation
- Skype works, shows I have internet, but browser wont go online
- If LED lights are so efficient then why do they get almost as hot as incandescents?
- How to correctly optimize your SSD for windows 10
- WAMP Mysqli: Your password has expired
- MySQL Dump/Restore, Dumping MySQL Database and Tables using MysqlDump command
- Source Code of Matrix Multiplication
- How to create your own PHP caching system? A simple example
- Domain Life Cycle
- Comparison of Random Functions According to their Exploration Performance (STL, .NET, Java)
- How to draw double buffered in C# or Java using GDI+
- How to recover Ubuntu after installing Windows using Ubuntu live cd
2
1