Re: mysqldump failing to load data
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
Re: mysqldump failing to load data
Hi, On Thu, Apr 2, 2009 at 1:18 PM, Virgilio Quilario virgilio.quila...@gmail.com wrote: 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 If you are running that command to import then you are sure to have a problem. Use: mysql dumpfile http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html Or in your case mysql mydb mydumpfile.sql Cheers, Ewen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldump failing to load data
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: localhostDatabase: 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org