How to upload large database files to phpmyadmin????

Lieutenant Joined: Sep 13, 2003 Posts: 295

I don't know maybe it is best to ask in the forum of MySQLDumper.

I suggest that you uses gzip to create a gz-archieve of your backup file, because then you can proceed directly to restore the database.
http://www.gzip.org/

Corporal Joined: Oct 15, 2003 Posts: 58

Everything will be nice if you have shell access to server.

Sergeant Joined: Jun 17, 2003 Posts: 90

Well my eyes now feel like my eyelids are made of sandpaper.... but I did it.

I have sucessfully exported my old data base and imported it into on to my new server. Honestly I can't believe it. I've been dreading this for years... and there was good reason... this sucked. Very Happy

I exported with mysqldumper, however I had to break it up into three seperate backups.

I ended up using Bigdump to import as I already had it set up and working and it was getting late so I just used that. I tried the first few times with the full export as one file but it would fail over and over again. However when I did the three seperate files it worked perfectly.

The sites not up and running to the public as of yet but I have all users, posts, stories, and surveys as of yesterday.

Now i just need to work through a few other things like additional modules and a gallery. But honestly, after this part everything should be much simpilier.

Lieutenant Joined: Sep 13, 2003 Posts: 295

Congratulations! Glad to hear that it worked for you in the end. How did you divide the sql backup in three parts? I read at the MYSQLDumper web site that complete inserts in backup makes restores of larger databases more reliable.

Sergeant Joined: Jun 17, 2003 Posts: 90

Slackervaara wrote:

Congratulations! Glad to hear that it worked for you in the end. How did you divide the sql backup in three parts? I read at the MYSQLDumper web site that complete inserts in backup makes restores of larger databases more reliable.

Thanks, I'm soooo relieved.

All I did was click the choose tables button in mysqldumper then just click off about 30% of the tables at a time. Trying to keep the larger tables seperate from each other. Then I just exported the first, went back in, did the next, 30% then again... Took maybe 10 mins to export the 3. Each one is seperate but it was easy.

Then I just uploaded the 3 files to my server, and imported each one seperately using Bigdump.

As for your question about complete inserts... I can't really answer, as I don't really understand it. But I will say this. When I was exporting before through phpmyadmin and run into an error i.e max 50000 issue, I would have to drop all the tables before trying again.

With the mysqldumper files with complete inserts It enabled me to start the import over again no matter how many times it messed up (I was getting the max50000 while trying the one large file). I never had to drop the tables, basically it was like it knew that the data was the same and just rewrote it, or ignored it cause it was the same... not sure but it was definitely easier with the mysqldumper files.