How can I import a MySQL dumpfile into my database? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

wulaishiwo · 03-09-2011, 04:07 AM

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.

Can anybody give light on this?

sandman · 03-14-2011, 06:59 PM

Here's a command to restore the database using the file if you have command line access.

mysql -u USER -p DBNAME < data.sql

Kelly_Infrenion · 04-07-2011, 05:21 AM

Quote:

Originally Posted by sandman

Here's a command to restore the database using the file if you have command line access.

mysql -u USER -p DBNAME < data.sql

Hello,

To use above command you must have a ssh access to the server, else you can request it to restore to your hosting provider.

Thanks!

chunnilal · 04-08-2011, 03:42 AM

there is another way, download any sql gui tool, connect it using ur credentials and ip, then restore ur db, selecting ur appropriate database.u need to upload ur sql file here

AdM.as · 04-17-2011, 06:34 PM

If you cannot access SSH and use the command posted above, you can also use phpMyAdmin import function. You will have to set the max uploadable file size though via the my.cnf file.