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
