> Hi, > > MySQL v4.1.22 on Linux 2.6.18-6-686 > > I have a dump file generate with mysqldump created by a version 4.1.10 server. > > I want to import the dump file into a different server. When I run > > mysqldump --database mydb --debug < mydumpfile.sql > > I get the following: > > -- MySQL dump 10.9 > -- > -- Host: localhost Database: mydb > -- ------------------------------------------------------ > -- Server version 4.1.22-debug-log > > /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; > /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; > /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; > /*!40101 SET NAMES utf8 */; > /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; > /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, > FOREIGN_KEY_CHECKS=0 */; > /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; > /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; > > /*!40101 SET sql_mo...@old_sql_mode */; > /*!40014 SET foreign_key_chec...@old_foreign_key_checks */; > /*!40014 SET unique_chec...@old_unique_checks */; > /*!40101 SET character_set_clie...@old_character_set_client */; > /*!40101 SET character_set_resul...@old_character_set_results */; > /*!40101 SET collation_connecti...@old_collation_connection */; > /*!40111 SET sql_not...@old_sql_notes */; > > > The database remains empty. Is there some incompatibility between the > data I am trying to import and the installed server? > > There is the following from the trace log: > | <cli_read_query_result > | >mysql_select_db > | | enter: db: 'spl2' > | | >net_clear > | | | >vio_blocking > | | | | enter: set_blocking_mode: 0 old_mode: 1 > | | | | exit: 0 > | | | <vio_blocking > | | | >vio_read > | | | | enter: sd=4, buf=0xb7c97008, size=1047551 > | | | | vio_error: Got error 11 during read > | | | | exit: -1 > | | | <vio_read > | | | >vio_blocking > | | | | enter: set_blocking_mode: 1 old_mode: 0 > | | | | exit: 0 > | | | <vio_blocking > | | <net_clear > .... > > User time 0.01, System time 0.00 > Maximum resident set size 0, Integral resident set size 0 > Non-physical pagefaults 679, Physical pagefaults 0, Swaps 0 > Blocks in 0 out 0, Messages in 0 out 0, Signals 0 > Voluntary context switches 4, Involuntary context switches 3 > > > Does anyone have any ideas what the probem might be? > Thanx, > Dp.
hi, mysql error 11 indicates that the system cannot create new thread or resource is temporarily unavailable. two reasons: 1. server is out of memory 2. used up all file descriptors -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
