How to import database using command line in MySQL

How to import database using command line in MySQL

Use the following command to import database using command line in MySQL :

mysql -u username -p password database_name < physical location of the file

Another very simple example :

mysql > Use database_name;

mysql> source C:\Users\mydatabase.sql(path of the file you want to import);

Add Comment

📖 Read More

• 1. How to select database using command line in Mysql
• 2. My Sql Questions And Answers
• 3. Get last conversation in mysql table in facebook style
• 4. Mysql find duplicate records in table
• 5. Sql create table with primary key

• 6. Mysql create table primary key autoincrement example
• 7. Get zip codes in radius Mysql query
• 8. SQL Prevent Duplicate INSERT - MySql
• 9. Get list of MySQL user accounts
• 10. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'