Urgent Help please (php maximum execution time)

[hamy]

Am trying to import a very large database and I get: "Maximum execution time exceeded" error.
I have already changed Maximum execution time in php.ini and restarted apache but I get the same error.
Please help!

[Steve Machol]

What did you increase it to and what's the exact error?

Also post a link to your phpinfo.php file.

[hamy]

Tanx for the fast reply. Here is my php information:
http://www.comiran.com/phpinfo.php
the file is over 1GB. I upgrade to mysql 3.2.54a and PHP2.3.0 and vb2.2.9 . And problems started :( . The database started shrinking first and then mysql crashed. I have just come back from a server restore :( .
I have a database backup file but when I try to import it using mysql :
mysql -uroot -p goftman_com < /home/virtual/site1/fst/var/www/html/goftman_com1.sql
I get:
ERROR 1064 at line 132086: You have an error in your SQL syntax near '<br />
<b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1
I have already chenged php.ini and changed Maximum execution time to 8000 and as you may see in phpinfo it has set to 8000 but I get this error via SSH.
I do not know what to do anymore. It is the second day that our site is down :( .

[Steve Machol]

First of all, how did you make this backup? I suspect the backup file is not complete.

[hamy]

Thanks a lot for your reply. I was using the auto dump script by Chris Schreiber that I found here. I have tried ipmorting other dump files and it does not work. When file size becomes more than 60-70 MB it does not let me to import it. I have already imported small databases (weblog and news) and it worked.
Any hope for me to import my data :( .

[Steve Machol]

I've never used that script so I'm not sure how it's supposed to work. Have you tried manually creating your backup? See Step One here:

http://www.vbulletin.com/manual/movingservers.html

[eva2000]

Originally posted by hamy
Thanks a lot for your reply. I was using the auto dump script by Chris Schreiber that I found here. I have tried ipmorting other dump files and it does not work. When file size becomes more than 60-70 MB it does not let me to import it. I have already imported small databases (weblog and news) and it worked.
Any hope for me to import my data :( . hmmm could be either you backed up your database with that error present in the dump file

do you still have the live running forum database you can redo a dump from ?

[hamy]

Thanx a lot. I got it working now :D . I upgraded mysql again and it let me to import it.
Thank you all.

[eva2000]

Originally posted by hamy
Thanx a lot. I got it working now :D . I upgraded mysql again and it let me to import it.
Thank you all. no probs .. glad to hear it's working now :)