Error 2013 Hy000 Mysql Dump
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies error 2013 hy000 lost connection to mysql server of this site About Us Learn more about Stack Overflow the company
Error 2013 Hy000 Lost Connection To Mysql Server During Query
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Error Hy000 Mysql Odbc 5.1 Driver Access Denied For User
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a
Error 2002 Hy000 Mysql
minute: Sign up Importing 1GO SQL File => ERROR 2013 (HY000) at line 23: Lost connection to MySQL server during query up vote 15 down vote favorite 1 Ive got to import 1go of sql data, i raised up the max_allowed_packet to 1100M to be sure. So i use : My query mysql -u root -p -D mainbase < GeoPC_WO.sql But 1 error 2002 hy000 mysql centos minute later it stops during the process and i get this error : **ERROR 2013 (HY000) at line 23: Lost connection to MySQL server during query **Lost connection to MySQL server during query**** mysql sql mysqldump mysql-management share|improve this question edited May 18 '12 at 23:47 Neil 34k73148 asked May 18 '12 at 3:10 Anthony 39231024 The sql file contains no error, its a world database geolocalisation table –Anthony May 18 '12 at 3:12 Are they inserts? –Adrian Cornish May 18 '12 at 3:25 Did you try this ? stackoverflow.com/questions/10563619/… –Joand Aug 23 '12 at 15:45 Good explanation and solution is provided here stackoverflow.com/questions/12425287/… –seven Jun 1 '13 at 0:35 add a comment| 5 Answers 5 active oldest votes up vote 9 down vote accepted Possible that you have some large insert statements that are bigger than you max size. Check your /etc/my.cnf file or wherever it is. Cannot remember what the default is - but setting it to something large like below may help. This is one option [mysqld] max_allowed_packet = 16M And maybe
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: ERROR 2013 (HY000) while importing large mysql dump file New Topic Advanced Search ERROR 2013 error 2006 hy000 mysql (HY000) while importing large mysql dump file Posted by: Adam S () error 1215 hy000 mysql Date: April 10, 2009 03:03PM I'm trying to import these sql dump files. There are a bunch of them, error 2013: lost connection to mysql server during query when dumping table all multiple gigs. Most are around 3-5gigs, one is 69gigs. Well it gives me this error after a very short while: ERROR 2013 (HY000) at line 103: Lost connection to http://stackoverflow.com/questions/10646216/importing-1go-sql-file-error-2013-hy000-at-line-23-lost-connection-to-mysq MySQL server during query The line number varies. Also, when it's processing, before it actually gives the error, if I try to login to phpMyAdmin to watch, it will sometimes let me login to the first page, but if I click anything it kicks me out. And the sites that are running on the server that use the mysql server http://forums.mysql.com/read.php?10,257281 (different db) throw this db mysql error through the php: Out of memory (Needed 536870880 bytes) And then as soon as the error is throw: Mysql reboots I think, the sites say they can't connect with provided settings. And if phpMyAdmin is sitting on the first page, it kicks me out. So something is wrong... what could it be? help!! :( Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 2013 (HY000) while importing large mysql dump file Adam S 04/10/2009 03:03PM Re: ERROR 2013 (HY000) while importing large mysql dump file Adam S 04/11/2009 04:21PM Re: ERROR 2013 (HY000) while importing large mysql dump file Jay Alverson 04/11/2009 04:59PM Re: ERROR 2013 (HY000) while importing large mysql dump file Adam S 04/11/2009 09:45PM Re: ERROR 2013 (HY000) while importing large mysql dump file Rick James 04/11/2009 10:41PM Re: ERROR 2013 (HY000) while importing large mysql dump file Adam S 04/14/2009 06:15PM Re: ERROR 2013 (HY000) while importing large mysql dump file Rick James 04/14/2009 07:06PM Sorry, you can't reply to this topic. It has been closed. powered by ph
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this http://dba.stackexchange.com/questions/97846/mysqldump-error-2013 site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: hy000 mysql Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top mysqldump Error 2013 up vote 6 down vote favorite 2 I have a database installed, that I would like to backup in mysql. The problem is mysqldump fails on exporting the 'maia_mail' table # mysqldump -u root -p maia > error 2013 hy000 maia.sql mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `maia_mail` at row: 15 It runs for less than 30 seconds and gets error out as above. The total size of the DB is 1.3GB with the maia_mail table being 1.0GB In my.cnf I have these set: [mysqld] max_allowed_packet = 1300M [mysqldump] max_allowed_packet = 1300M Please advise or give some guidance on how to dump the database? mysql mysqldump share|improve this question edited Apr 15 '15 at 1:08 KASQLDBA 4,34511436 asked Apr 14 '15 at 19:17 garfink 3113 Do you have enough space on the hard drive? Try watching the space while the dump is being done. –Jehad Keriaki Apr 14 '15 at 19:41 @jehad Keriaki - 170GB free space. It's also the same whether I dump to machine db is on or remote –garfink Apr 14 '15 at 19:49 What type of data this table has.. do you think it has special characters that affects saving into text file? –Jehad Keriaki Apr 14 '15 at 19:55 copies of email so varchar data mainly –garfink Apr 14 '15 at 20:01