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 allow
Daniel
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
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.
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 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: mysqldump file fails to recreate database