Free Web Hosting Forum
(#1)
Old
kipaqra kipaqra is offline
Junior Member
kipaqra is on a distinguished road
 
Posts: 22
Join Date: Jul 2009
Default exceeded the 'max_updates' - 09-23-2009, 10:31 PM

Whilst generating a csv file from excel and uploading to my database, I now get the following message:

User '_admin' has exceeded the 'max_updates' resource (current value: 50000)

How do I upload a csv file that contains useful table data without exceeding the 'max_updates' resource limit?

Note, at the moment I am only trying to import upto 50 records.


Kind regards

stu.

Last edited by kipaqra; 09-23-2009 at 10:36 PM.
Reply With Quote
(#2)
Old
sizzlefire's Avatar
sizzlefire sizzlefire is offline
Administrator
sizzlefire is on a distinguished road
 
Posts: 4,531
Join Date: Apr 2008
Send a message via AIM to sizzlefire Send a message via MSN to sizzlefire Send a message via Yahoo to sizzlefire Send a message via Skype™ to sizzlefire
Default 09-23-2009, 10:38 PM

How large is the file you are importing?
Reply With Quote
(#3)
Old
kipaqra kipaqra is offline
Junior Member
kipaqra is on a distinguished road
 
Posts: 22
Join Date: Jul 2009
Default 09-24-2009, 07:23 PM

What I have done is use a csv import script with the semi-colon as the list seperator. Then I have created my data in excel, saved in csv format then uploaded the data.

The csv file is 8k.

When I run the script I get the max updates resource error. When I look in my database I see records 3 - approx 49000 contain a single Null in the next field after the auto_increment field.

If I clear the data by a delete query and then try to insert data again manualy, the increment count always starts at 50000.


Kind regards

stu.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
vBulletin Skin developed by: vBStyles.com