WingZero
05-22-2002, 05:18 PM
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
Thanks
![]() | View Full Version : MySql problem WingZero 05-22-2002, 05:18 PM 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 05-22-2002, 05:30 PM mysql -u admin -ppassword databasename < file.sql -u (username) -p(password) with no space between -p and the password. WingZero 05-22-2002, 08:04 PM 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 05-22-2002, 08:51 PM 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. |