You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 210 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - How to upload large database files to phpmyadmin???? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Slackervaara
Captain
Captain


Joined: Sep 13, 2003
Posts: 355


PostPosted: Fri Nov 16, 2007 12:45 pm Reply with quoteBack to top

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/
Find all posts by SlackervaaraView user's profileSend private message
doctornuke
Corporal
Corporal


Joined: Oct 15, 2003
Posts: 66


PostPosted: Fri Nov 16, 2007 8:08 pm Reply with quoteBack to top

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

_________________
home|thaios|healthhosting
b|game
Find all posts by doctornukeView user's profileSend private messageVisit poster's website
jeebus
Sergeant
Sergeant


Joined: Jun 17, 2003
Posts: 107


PostPosted: Sat Nov 17, 2007 10:00 am Reply with quoteBack to top

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.
Find all posts by jeebusView user's profileSend private messageVisit poster's website
Slackervaara
Captain
Captain


Joined: Sep 13, 2003
Posts: 355


PostPosted: Sat Nov 17, 2007 10:07 am Reply with quoteBack to top

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.
Find all posts by SlackervaaraView user's profileSend private message
jeebus
Sergeant
Sergeant


Joined: Jun 17, 2003
Posts: 107


PostPosted: Sat Nov 17, 2007 1:19 pm Reply with quoteBack to top

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.
Find all posts by jeebusView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.120 Seconds - 263 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::