[RESOLVED] db table entries - is there a limit?

dotty

Hi,

I have a table which has (varchar(255)) as a ID with primary key - because client wanted to use their own ID's - now data is 'disappearing' and I'm trying to diagnose. Can anyone tell me if there is a limit to the number of entries to a mysql db table?

Or could using varchar as a primary key a problem?

Or if anyone would know of any other reason why data should be lost other than being deleted by a person?

any help greatly appreciated

rincewind456

It's not likely that the table is full unless the conditions Here are met.

tomhath

There are only two ways I know of for data to disappear; either a bug in the application or someone deleting it intentionally.

It would be helpful to tighten security so people can't delete data without you knowing (but in the real world that's often not possible). I would assume it's a bug though; no matter how much confidence you have in the application, something can go wrong.

dotty

I figured out what it was! Because I stupidly agreed to allow them to input the ids as alpha/numerical, they where putting spaces between the letters and numbers (like: AB 111 | AB 112 | AB 113 - and so my delete file was reading the id up to the space and deleting all with that id! I've had to restructure the whole thing to change the id field back to int auto-increment and change all cross referenced tables and files! So, a lesson learned there in what NOT to do!
Thanks for all the help!