Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySql problem

[WingZero]

I've recently backed up a .sql file for a php script. I want to now restore the file's info on a new server. How do I do that? Is there a command line I can type in somewhere?

Thanks

[AcuNett]

mysql -u admin -ppassword databasename < file.sql

-u (username) -p(password) with no space between -p and the password.

[WingZero]

Thanks for the help, but do i type that as a query in phpadmin? Also, do I put the absolute path to where the file is at on my server?

[AcuNett]

Yes, for the *.sql file you type the full path to it.

You do it in shell. in phpMyAdmin there should be an option to "browse" to a text or sql file on your local system and it will auto upload.

If your phpMyAdmin does not have this, then you will need to copy and paste EVERYTHING in your *.sql file into the query/form box.

Easiest way imo is to do it via shell.