5 messages in com.mysql.lists.mysqlmysqldump does not dump table options| From | Sent On | Attachments |
|---|---|---|
| Schwenke (de) | 13 Nov 2000 00:59 | |
| Thomas Spahni | 13 Nov 2000 08:13 | |
| indrek siitan | 13 Nov 2000 10:07 | |
| Dan Nelson | 13 Nov 2000 12:54 | |
| Michael Widenius | 17 Nov 2000 16:47 |
| Subject: | mysqldump does not dump table options |
|---|---|
| From: | Schwenke (de) (schw...@jobpilot.de) |
| Date: | 11/13/2000 12:59:33 AM |
| List: | com.mysql.lists.mysql |
Description:
Mysqldump does not dump options which are in use when creating a table. This especially a problem if one uses RAID tables or mixes different types of tables (ISAM, MYISAM, BDB).
How-To-Repeat: Create a RAID table, dump it, restore it from dump. Fix:
Lookup table options in mysqldump and write to stdout :-)
Submitter-Id: Originator: Axel Schwenke Organization: Jobs & Adverts Online AG MySQL support: extended email support Synopsis: mysqldump does not dump table options Severity: critical Priority: low Category: mysql Class: change-request Release: mysql-3.23.27-beta (Source distribution)
Environment:
System: Linux tux 2.2.15 #3 Tue Jun 13 09:59:03 MEST 2000 i686 unknown Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='egcc' CFLAGS='-mpentiumpro -fno-exceptions' CXX='egcc'
CXXFLAGS='-mpentiumpro -fno-exceptions' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 2475225 Apr 4 1999 /lib/libc.so.6
-rw-r--r-- 1 root root 10681734 Apr 4 1999 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 4 1999 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local --sysconfdir=/etc
--localstatedir=/JobsAdverts/SqlServer/var --with-charset=german1
--without-bench --without-docs --without-debug --with-mysql-user=mysql
--with-raid --with-mysqld-ldflags=-all-static --disable-shared
Perl: This is perl, version 5.005_02 built for i586-linux