Category: command prompt
How to import an SQL file using the command line in MySQL
- 0
When I was working with MySql command prompt, I was wondering how to import an available sql file into the available database. First you need to open the MySql Command prompt. And select the database. Here “smartcart” is the database. Now I select that database using “use” command as below: mysql> use smartcart; Database changed…
Read More
How to export a mysql database using Command Prompt
- 0
Some how my PhpmyAdmin stopped working And I had to take up a back up of one of my databases. So that time, I thought of using the Mysql Command prompt service. To take the back up, we can export the tables and contents of the database using mysqldump. Please note that mysqldump is not…
Read More