Terence, Wednesday, June 12, 2002, 1:22:09 PM, you wrote: T> merge/union...which i guess is the problem? is it not fully supported by T> mysqldump yet?
MERGE tables only since 4.0 support INSERTs. If you look into dump file you can see INSERTs for your MERGE table. http://www.mysql.com/doc/M/E/MERGE.html http://www.mysql.com/doc/C/R/CREATE_TABLE.html T> ----- Original Message ----- T> From: "Egor Egorov" <[EMAIL PROTECTED]> T> To: <[EMAIL PROTECTED]> T> Sent: Wednesday, June 12, 2002 5:33 PM T> Subject: Re: MySqlDump T> Terence, T> Wednesday, June 12, 2002, 10:20:03 AM, you wrote: T>> ERROR 1031 at line 5167: Table handler for 'total' doesn't have this T> option T>> I am trying to use mysqldump to backup my server to another. Can anyone T> tell T>> me what the above error means? Is it a column name or perhaps some data T>> that's conflicting? T> What is the type of table 'total'? T>> Rgds T>> Terence -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php