July 04, 2008, 23:33:22 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Check your Page Rank, Backlinks, or Link Popularity in our tools section.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Check your Page Rank, Backlinks, or Link Popularity in our tools section.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

Big upload

 (Read 2381 times)
0 Members and 1 Guest are viewing this topic.
xulescu
Full Member
***

Points: 8
Offline Offline

Posts: 245


WWW
« on: October 23, 2006, 12:16:12 »
I have a big database ... and I just made a dump of it to duplicate it on other db server. But it's takeing alot if I want to upload on the new db server . Please help me with some tricks hot to uploadt this database ...

Thanks
Logged
Tracking Deleted Domains, Link Popularity and more ...


TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #1 on: October 24, 2006, 12:37:46 »
Hi,

1. First of all stop all your connections on your database.
2. Modify the key_buffer_size at 1G or more ... if you have RAM Smiley
3. use Load Data from mysql console because is much faster (is uploading first time the data and after that is putting the indexes)
4.  Try throwing an exclusive lock on the table before loading the data.
5. Add more memory on that server ... only for this operation !

I hope this is helpful Smiley

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
CyberPhreak
Jr. Member
**

Points: 0
Offline Offline

Posts: 46


Delphi lover


WWW
« Reply #2 on: December 19, 2006, 21:26:12 »
I suggest you have a look at what I wrote in this topic:
http://www.webmasterstalks.com/databases/big-dump-t798.0.html;msg5106#msg5106
Logged
LinuxGuy
Sr. Member
****

Points: 0
Offline Offline

Posts: 259


WWW
« Reply #3 on: January 14, 2007, 02:00:24 »
btw, how big is your database when compressed ?
Logged
Linux Help forums|Free image hosting
Indian telecom forum|Shayari
Bodybuilding help forums
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!