I don't have --no-disable-keys in my version of myqldump (Ver 8.21 Distrib
3.23.48). (-K doesn't seem to do anything, I assume it's the default).
I actually wouldn't mind disabling keys for the load, but I don't
understand how the "/*!4 ..." stuff is suppose to get used.
Is this a half-im
Use option "-K or --no-disable-keys" with myqldump.
> Date: Mon, 15 Apr 2002 09:37:43 -0400
> To: [EMAIL PROTECTED]
> From: Bill Marrs <[EMAIL PROTECTED]>
> Subject: "gunk" in mysqldump output
>
> In some recent release of MySQL, lines like this:
&
In some recent release of MySQL, lines like this:
/*!4 ALTER TABLE States DISABLE KEYS */;
...were added to the output of "mysqldump --opt".
This causes my usually "load" statement:
"mysql < dumpfile"
...to fail with "ERROR 1046 at line 11: No Database Selected".
If I do "mydsql -f < dum
