Question - How does database import/export work in MySQL?
Answer -
It can be done in two ways. One is to use phpMyAdmin, and the second is to use the command line access of MySQL. The latter can be done by using the command named mysqldump. It goes something like this:
· mysqldump -u username -p databasename > dbsample.sql
To import a database into MySQL, only a sign change is required, with a command of MySQL. The command goes something like this:
· mysql -u username -p databasename < dbsample.sql