Mysql Console Commands - Export and Import database from command line

1) Create a new Database.

create database mydb

2) List of all databases.

show databases

3)Create Backup of all Database.

mysqldump -h localhost -u username -p password –all-databases > dumpAllDatabase.sql

4) Create Backup of database (database name mydb) OR Export database into file.

mysqldump -h localhost -u username -p mydb > dump.sql

4) Create Backup of database structure only.

mysqldump -u username -p -no-data mydb > dump.sql

5) Import SQL file into  database

mysql -h localhost -u username -p password mydb < dump.sql

Note: When you add -p in command line, It will prompt for database password. In this case just type/paste the correct password.

Best Related Posts are Following:

1. MySQL Interview Questions and Answers for Experienced.
2. Difference between inner join and outer join in MySQL.
3. How to get a list of MySQL user accounts?.
4. What is MySQLI technology in php.
5. How to delete MySQL Binary logs Files in Wamp Server?.
6. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
7. Multiple column ordering in Zend Framework.
8. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
9. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
10. Difference Between MyISAM and innoDB - MySQL.
11. MySQL Functions - MySQL tutorial for beginners.
12. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
13. Mysql FullText Search Examples.
14. MySQL Constraint Example.
15. MySQL Cascade Example.
16. Mysql-Group-Concat.
17. MySQL Expressions.
18. MySQL Delete Table Example.
19. Replace Table - Update Field, Move Records to another table MySQL.
20. mysql insert syntax - Add records from another table - Copy Table from one table to another.
21. Mysql Update Syntax - Update Multiple Records.
22. What is Mysql.
23. Mysql Console Commands - Export and Import database from command line.
24. MySQL interview Questions and Answers For Experienced.