Re: mysqldump file fails to recreate database

2003-01-16 Thread Lynn David Newton
>> It's the first KEY definition it doesn't like. If >> I comment out "KEY field(field)," it works, except >> of course then the field called 'field' is not set >> as an index. ... Daniel> I'm pretty sure 'field' is a reserved word. Daniel> ... My feeling is that MySQL shouldn't allo

RE: mysqldump file fails to recreate database

2003-01-15 Thread Jennifer Goodie
only limit progress but also alienate the majority of target users. This of course is just my personal (not-very-well-thought-out) opinion and I'm sure a lot of people disagree. -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 3:11 P

Re: mysqldump file fails to recreate database

2003-01-15 Thread Daniel Kasak
Lynn David Newton wrote: It's the first KEY definition it doesn't like. If I comment out "KEY field(field)," it works, except of course then the field called 'field' is not set as an index. The same exact problem occurs in two places in the mysqldump file. With them commented out the DB reloads.

mysqldump file fails to recreate database

2003-01-15 Thread Lynn David Newton
I've got a large test database and a recent backup made with mysqldump. I've been deleting records from it and would like to get back where I started. The easiest way is to drop database, create database, and then input from the mysqldump backup file. To automate it and make it quick I do it like