Hello, I am in the middle of migrating my database to another web host and I it's been over 5 hours and I am still having problems. The main problem is that the sql file is over 70mb and everything I try I get time outs. The only way I was able to move this database before was using sh mysql import. Unfortunately my current web host doesn't allow sh access. I want to run this command in php but is there a way to pass the password when it gets prompted for it? $last_line = system("mysql -p -h localhost dbname < dbname.sql" , $retval); PHP: Thanks.
There are 2 other ways: 1. Increase the time limit, by using a local .htaccess file, with the following content: php_value memory_limit "-1" php_value max_execution_time "-1" php_value max_input_time "-1" 2. Use MySQL manager. It can connect using HTTP tunneling (it works without SSH). You just upload a php script, which is delivered with the program, then you use the interface to communicate with the script. They have a free version here: http://www.sqlmanager.net/products/mysql/manager