2 messages in com.mysql.lists.mysqlRe: Problems with DATE fields and bac...| From | Sent On | Attachments |
|---|---|---|
| al | 08 Dec 1999 08:53 | |
| sin...@mysql.com | 09 Dec 1999 05:09 |
| Subject: | Re: Problems with DATE fields and backing up |
|---|---|
| From: | sin...@mysql.com (sin...@mysql.com) |
| Date: | 12/09/1999 05:09:44 AM |
| List: | com.mysql.lists.mysql |
al writes:
Hi,
I have a problem whereby if I do a mysqldump <database name> and dump the output into a file, when I try to restore the backup I lose the DATE fields on certain tables, and only certain tables. I have no idea why this is a happening though I have tried everything I can to rectify it, without hope. The only way I can preserve the dates is to tar up the entire database *.ISM, *.ISD files and un-tar them when restoring the backup.
Does anyone know what I'm doing wrong? Is there a way around this?
Many thanks in advance to anyone who can help.
Regards Al
-- ============================== Ali Hussein Computer Systems Administrator World Careers Network
Web: http://www.wcn.co.uk/ E-mail: mailto:al...@wcn.co.uk Tel: +44 208 946 9876 Fax: +44 208 946 9855 ==============================
This is weird. Send info on your OS version, C and thread libs version, version of MySQl, and how have you built it , including compiler version.
Do include mysqlbug report with it.
Sinisa
+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys...@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin...@cytanet.com.cy| | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+