Crash importing old data to new server
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 version10 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: lrwxrwxrwx1 root root 13 Mar 19 12:57 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 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
Re: Crash importing old data to new server
Hi, Why don't you just dump the databases, tar.gzip them, and transfer that file? It's smaller then the .frm+ .myd, and you can rebuild everything without probs... MPNeves On Tuesday 30 July 2002 07:29 am, [EMAIL PROTECTED] wrote: 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. -- Merlin, the Mage themage.camelot.co.pt - 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