[TUT] How to upload a big database to phpmyadmin

[Syduis]

BIG DUMP


Do you ever have that issue when you lose/destroy your database, but when you go to install a back up this comes up:

This is a very simple fix, and all you have to do if follow these few steps.

1)Programs
Xampp (Shouldn't have this issue if this was no installed already)

BigDump: http://www.syduis.com/Dump.rar

2) Once you have downloaded the rar, Back any files you have in your hotdocs and place on your desktop/side location.

3)Place the dump file in your hotdocs foler, making sure it is the only folder in the directory.

4) Open the Dump folder and rightclick the PHP file, Open in notepad.

5) When you are in notepad, Press CTR+F and search for:

YOURDATABASENAME and Change to the name of your Database in Phpmyadmin.
And
YOURPHPMYADMINPASSWORD and Change to the password you set up for phpmyadmin.

Next you want to take your SQL file that your uploading and rename it dump.sql

6)Once That is done, Copy the Dump.sql file and patse in the Dump Folder, under the BigDump.php:

7) Right click the BigDump.php and open in your internet browser. (FF,IE,GC)
Open all the files in order:

8) When you open it and click on the start import this screen will appear:

WAIT FOR IT TO LOAD, DO NOT EXIT OR IT WILL RUIN YOUR DATABASE!

When it has finished you will have a screen like this:

After that is finished, Go into your htdocs, delete the "Dump" folder and all its contense. re-add your old files and you are good to go.


I hope this tutorial helped you, if you need help please post below/ PM me



P.s What do you think of my new logo?

[Mithex]

Love the tutorial great job. Great name for file to, Big Dump, Im so childish xD

[Subway]

Great tutorial bro.

[JohnHearfield]

How do i change server instead of localhost?

[Hejula]

Yeah, how to upload a big database with phpMyAdmin: DONT! Unless you want to end up with a corrput database that is. Use SQLyog it is fast with big databases, and not a website so it wont time out :P

[SocialDistance]

...Or Just use navicat ;)