[thelist] Mysql backing up db
Anthony Baratta
Anthony at Baratta.com
Sat Oct 20 00:58:27 CDT 2001
At 10:48 PM 10/19/2001, you wrote:
>Thanks Anthony,
>
>Your right. That does work fine but it seems that I can only get some of
>the info inserted. Is there a limit to how many inserts can be done when
>using a .sql file?
Are you using a TinyInt for your auto-increment field? If so, you need to
change it to Int. TinyINt is only good for -127 to 127. That's *not* good
for Auto-increment.
I used to load 100K lines in a flat file at a time. You should have no
problem otherwise.
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list