Quota of SQL Statements

Regular Joined: Sep 26, 2007 Posts: 60

Well now that I have gotten over MySQL error # 2 I have another one...Step 1, 2, 3, 4, and 5 all go ok, but when I try and load the IP2Country data I get an error saying:

MySQL Error # 4 = User 'xxx' has exceeded the 'max_questions' resource (current value: 50000)

I saw a workaround where you create an array of users, but has anyone successfully implemented this?

Posted: Tue Nov 06, 2007 2:48 pm

Are you trying to install the tables at once, or using the individual steps?

Posted: Tue Nov 06, 2007 3:02 pm

I am able to do steps 1, 2, 3, 4, and 5. For step 6 I can get from 6a to 6d. After I try to load 6e I get the error message.

If I try and leave the page alone for a while and then come back I have to start at square 1.

registered · Posted: Sat Nov 10, 2007 2:20 pm

adaykin wrote:

If I try and leave the page alone for a while and then come back I have to start at square 1.

No, you should only have to pick up with the step that failed and subsequent ones...

Posted: Sat Nov 10, 2007 6:01 pm

I changed the dbuname to an array, and now the loads are a lot faster, and the setup worked.