Import MySQL dumpfile, SQL datafile into my database


Q. How can I import a MySQL dumpfile into my database?
My old hosting provider gave me data.sql file. I do have access via ssh to server. I’m using CentOS Linux 5 server.
A. You can easily restore or import MySQL data with mysql command itself. First you need to login to your system using ssh or putty (from Windows based system). For example:
Type the following command at the shell prompt:
Now type following command to import sql data file:
$ mysql -u username -p -h localhost data-base-name < data.sql
If you have dedicated database server, replace localhost name with actual server name or IP address:
$ mysql -u username -p -h databasename < data.sqlOR use hostname such as
$ mysql -u username -p -h database-name < data.sql
If you do not know the database name or database name is included in sql dump you can try out something as follows:
$ mysql -u username -p -h < data.sql

How to restore MySQL database from sql dump file?

Deja un comentario

Tu dirección de correo electrónico no será publicada.