MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 SQL questions are limited on my ISP

Post new topicReply to topic
Author Message
warnmar10
knows MySQLDumper
knows MySQLDumper





Joined: 06 Feb 2005
Posts: 2


usa.gif

PostPosted: 2005-04-28, 20:29    SQL questions are limited on my ISP Reply with quoteBack to top

My ISP limits my SQL users to 50,000 questions per hour. This was a big problem on my phpbb forums. I got around this problem on my forums by modifying config.php this way:

$randomNum = rand(0,9);
if($randomNum == 0){$dbuser = 'forum_user0';
}
else if($randomNum == 1){$dbuser = 'forum_user1';
}

else if($randomNum == 2){$dbuser = 'forum_user2';
}

else if($randomNum == 3){$dbuser = 'forum_user3';
}

else if($randomNum == 4){$dbuser = 'forum_user4';
}

else if($randomNum == 5){$dbuser = 'forum_user5';
}

else if($randomNum == 6){$dbuser = 'forum_user6';
}

else if($randomNum == 7){$dbuser = 'forum_user7';
}

else if($randomNum == 8){$dbuser = 'forum_user8';
}

else if($randomNum == 9){$dbuser = 'forum_user9';
}


I did the same thing to my MySQLDumper/config.php but it doesn't seem to work that way. Dumper establishes a connection and uses it throughout the restore process.

Is there a way to divide MySQLDumper across multiple database user accounts?

Sorry I don't speak German, thanks for a great utility!

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2005-04-28, 22:04    Re: SQL questions are limited on my ISP Reply with quoteBack to top

« warnmar10";p="4699 » wrote:

Is there a way to divide MySQLDumper across multiple database user accounts?


Is it a ISP for free?
Payed Webspace does not have such silly limitations.
Sorry but we can't do anything against that.
Of course MSD needs to ask for all the data in your database and if that grows bigger than your limit, we can't help it.

MySQLDumper (up to now) is not designed to access multiple accounts on multiple databases. But we don't know what will be in future. Very Happy

Anyway: have fun with our Dumper. Very Happy

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.


Last edited by DSB on 2005-04-28, 22:08; edited 2 times in total

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
warnmar10
knows MySQLDumper
knows MySQLDumper





Joined: 06 Feb 2005
Posts: 2


usa.gif

PostPosted: 2005-04-29, 01:46    Re: SQL questions are limited on my ISP Reply with quoteBack to top

Thank you.
OfflineView user's profileSend private message    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Restoring databases on max_updates_pe... ive63 Errors and questions 6 2011-05-30, 22:22 View latest post
No new posts 2 questions K4L Errors and questions 6 2010-07-21, 11:05 View latest post
No new posts Questions benny92000 Errors and questions 1 2009-02-23, 01:54 View latest post
No new posts Don't you just hate questions like th... ghosty Errors and questions 1 2008-08-27, 01:09 View latest post
No new posts Some innitial questions regarding MyS... ewsg Gelöst/Erledigt 2 2008-06-28, 15:57 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO