How to import

[JohnnySaur]

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.

[Dougy]

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.

mysql -uusername -p dbname < db.sql

For example:

mysql -uroot -p yourdatabase < data.sql

Of course, you aren't root, but you should know the user.