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!