How can I import a MySQL dumpfile into the database ? You can easily restore or import MySQL data with the
mysql command itself. First you need to login to your server using ssh or putty (if you're using Windows) or directly from your terminal if you are using a UNIX based operating system.
mysql -hDB_HOST -uDB_USERNAME -pDB_PASS DB_NAME < database_file.sql
-hDB_HOST is optional and you may skip it.
If the database does not exists on the server, then you'll need to connect to the database server and create it. You'll do this with the fist part of the previous command:
mysql -uusername -p
And after success you should see mysql prompt:
Now run the following commands to create the database:
# create the database. Semicolon at the end is mandatory CREATE DATABASE database_name; # exit database server to return to bash command prompt: exit;
To export a database to a local file you'll have to use
mysqldump command which has a syntax similar to
mysqldump -hDB_HOST -uDB_USER -pDB_PASS DB_NAME > database_file_dump.sql
If the database is on the same server where you execute the command, then you can skip the