My deepest apologies if this isn't the correct location but I can't determine this is a php or datbase issue so I figured I 'd start here. I have a phpbb board that I'm trying to move from one host to my published home server running MySQL 5 & PHP 5. This server has other websites published so all is working as it should be. This new forum sits on a site that I plan on transferring to GoDaddy. Before I can perform the transfer I need to move the board and make sure it's accessible until I the transfer is complete. So I take a backup of the board and see that uncompressed the file is 42MB and compressed it's around 11MB. I open the php.ini file on my web server and change the settings to allow for 80MB uploads. I also increased the max_ settings. After all of this I continue to get timeout errors when trying to import the 42MB file. HEre's the exact error: Script timeout passed, if you want to finish import, please resubmit same file and import will resume. I resubmit the file and it eventually finishes but when I view the board a lot of the data is missing. It's as if data was lost during the interruption. So what I'm trying to figure out is the best way to import this 42MB file. Right now I'm using phpMyAdmin 3.01 rc1 and it's the one generating the error. When trying to use bigdump I get the following: You can now upload your dump file up to 83886080 bytes (80 Mbytes) directly from your browser to the server. Alternatively you can upload your dump files of any size via FTP Here's the error: Error at the line 18001: '0'); Query: '0'); MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0')' at line 1 I haven't a clue on where to start troubleshooting this so I'm hoping to get a push in the right direction. Maybe someone knows of another tool that'll allow me to perform the restore with such a large file. What I don't get is that I've made the necessary changes on my server so technically this should work; unless I missed something. ANY responses appreciated...
A 42 Megabyte files will take quite a bit of time to upload - especially depending on your ISP Upload Speed. Have you set your max_execution_time and max_input_time to allow for sufficient upload time? You could try playing with these numbers until you find a time out level sufficient enough. OR the alternative is to use a MySQL program to connect to the database remotely. Just as you would use an FTP program to transfer files (instead of a control panel file manager), so too can you use a MySQL program to upload your database. I personally use MySQL-Front and have successfully backed up and restored databases several hundred megabytes in size with no problems. Not to mention, because the program connects with your database directly, there is no need for changing "timeout" values.
I've had this problem several times before. You kinda have two options. If you web host allows you to secure shell, then you can use ss to run mysql commands to import your sql file. If your isp is really cool, ask them if their are able to do it for you. You can visit their support forum and do a search for your problem.