MySql crashes: On an idle server, executeing "truncate table lists" with the given data files (only an MYD and frm, no MYI). I'm trying to save bandwidth transfering data from an old mysql install (mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686)) to this one. I wanted to transfer the data and frm but not the index, then rebuild on the new host.
>How-To-Repeat: get only ISD and frm table data files here: http://www.julianhaight.com/mysqlbug/ drop them in any mysql table directory and run: "truncate table lists" >Fix: Don't do such crazy things in the first place. >Submitter-Id: <submitter ID> >Originator: >Organization: spamcop >MySQL support: licence >Synopsis: Crash importing old data to new server >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.39 (Source distribution) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ this is wrong. I'm running 4.0.2-alpha-log: $ mysqladmin version -p [snip] Server version 4.0.2-alpha-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysql/mysql.sock Uptime: 6 min 53 sec >Environment: System: Linux sandyman 2.4.18 #8 SMP Thu Jul 18 18:24:01 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Mar 19 12:57 /lib/libc.so.6 -> libc-2.2.3.so -rwxr-xr-x 1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so -rw-r--r-- 1 root root 24721042 May 25 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with-libwrap --without-bench i386-slackware-linux --------------------------------------------------------------------- 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