MyBB Community Forums

Every time when I try to restore my database using phpMyAdmin, it times out.

What can I do to stop this?

krazygamers Wrote:Every time when I try to restore my database using phpMyAdmin, it times out.

What can I do to stop this?

Is your Partial import checked? Anyway phpMyAdmin is a waste of time when it comes to restoring a single large db file. Try to divide the file you wish to import or use a different tool for restoring your db.

Regards

maatty Wrote:use a different tool for restoring your db.

What do you suggest?

Try this program to split up your sql file.

What do you do after splitting it?

EDIT: The tool says something in another language

Ok I found something called Big dump and here are the steps to it

1. Open bigdump.php in a text editor and adjust the database configuration
2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE" (use phpMyAdmin)
3. Create the working directory (e.g. dump) on your web server
4. If you want to upload the dump files directly from the web browser give the scripts writing permissions on the working directory (e.g. make chmod 777 on a Linux based system). You can upload the dump files from the browser up to the size limit set by the current PHP configuration of the web server. Alternatively you can upload any files via FTP.
5. Upload bigdump.php and the dump files (*.sql or *.gz) via FTP to the working directory (take care of TEXT mode upload for bigdump.php and dump.sql but BINARY mode for dump.gz if uploading from MS Windows).
6. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php. Now you can select the file to be imported from the listing of your working directory.
7. BigDump will start every next import session automatically if you enable the JavaScript in your browser.
8. Relax and wait for the script to finish. Do not close the browser window!
9. IMPORTANT: Remove bigdump.php and your dump files from your server


I got lost at step number two (yes, im a newb). Can someone help me with this?

krazygamers Wrote:Ok I found something called Big dump...

Oh, Noooo...Not the Big Dump...You should use the one I've just recommended in this thread: http://community.mybboard.net/showthread.php?tid=19774

Regards

How do you CHMOD a file to 777?

krazygamers Wrote:How do you CHMOD a file to 777?

If you login to your server via an FTP software, you can chmod a file by right-mouse clicking on the file and change its properties to 777. Some servers have this as the default value. You can also do the same via your File Manger when you login through your Cpanel, by changing the file attributes.

Regards

krazygamers Wrote:What do you do after splitting it?

EDIT: The tool says something in another language

You then use phpmyadmin to upload each sql it created one at a time. It's a dirty solution but it works. The reason you get timeouts is because of file size. Instead of 1 large sql file this will break a large sql file into smaller sql files.