Unknown command '\'' during load
I'm trying to restore a database from a dump as part of my make-sure-this-will-restore-just-in-case process and I get the following error... ERROR at line 1189: Unknown command '\''. The only thing I've been able to find is this bug report... http://bugs.mysql.com/bug.php?id=9756 ...which claims that this (or something similar) was fixed in 5.0.6. I'm running 5.0.18 on OS X here and the dump is from a Debian box running 4.0.15. (I've also tried loading the dump on a box running 4.0.x with the same result) The table in question has just over 25 million rows, so it would be nice to be able to restore it if necessary :) I'm just trying to figure out if it's a data problem, version problem, or something else. -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unknown command '\'' during load
On 3/23/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: > What does line 1189 look like? > Good question. Hard to tell, since it's the insert statement for a rather large table (25 million rows) and I have --extended-insert set, so it's all on one *really* long line. Seems like there should be a return or two in there, but apparently it doesn't work that way. > > On 3/17/06, Jack Baty <[EMAIL PROTECTED]> wrote: > > I'm trying to restore a database from a dump as part of my > > make-sure-this-will-restore-just-in-case process and I get the > > following error... > > > > ERROR at line 1189: Unknown command '\''. > > > > The only thing I've been able to find is this bug report... > > > > http://bugs.mysql.com/bug.php?id=9756 > > > > ...which claims that this (or something similar) was fixed in 5.0.6. > > I'm running 5.0.18 on OS X here and the dump is from a Debian box > > running 4.0.15. (I've also tried loading the dump on a box running > > 4.0.x with the same result) > > > > The table in question has just over 25 million rows, so it would be > > nice to be able to restore it if necessary :) > > > > I'm just trying to figure out if it's a data problem, version problem, > > or something else. > > > > > > -- > > Jack Baty > > Fusionary Media - http://www.fusionary.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unknown command '\'' during load
On 3/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > When you generated this dump file, did you remember to use the > --max_allowed_packet parameter to make sure that mysqldump didn't create any > extended insert statements larger than your server wants to handle? It could > be crapping out because at line 1189 you exceeded max_allowed_packet. To be > safe always use a value of 16M or less when setting max_allowed_packet. > Check your server's variables for the value it's currently using > > SHOW VARIABLES LIKE 'max%'; > > I don't know for sure that this is going to be the problem but it's always > something to look at when you start dealing in larger dumpfiles. I hadn't considered that. I think I'll also be dealing with net_buffer_length, since it seems that is what actually affects the dump insert statement size limit. I'll give it a whirl, thanks. -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0 - What is really available?
I prefer SQLyog. www.webyog.com Ditto that. I used to use MySQL-Front, but switched when development stopped. I don't miss it really. The structure synchronization and db job agent features are maturing rapidly and work quite well. Saves a ton of time for me. Not sure about v5.0 support yet, but they release updates quite often, so it shouldn't be long. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Diagrams and Flowcharts on mySQL tables
Try Dezign for Databases. Works pretty well and is much cheaper than the big ones (ER/Studio and ERWin) http://www.datanamic.com/dezign/ -- Original Message -- From: Robert Goeres <[EMAIL PROTECTED]> Date: Sat, 30 Jun 2001 16:37:28 +0200 >I have a bunch of tables and would like to get an overview. Does a program >(with pref. Win32) exist with takes mySql tables and represents them >graphically where you could draw your link and print them out? > >Regards >Robert Goeres > >- >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 > > - 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: ACCESS DB, and MySQL which one better to handle database driv en webpage
Just to balance out the conversation, a couple years ago we had developed an e-commerce site which was to be prototyped in Access, then moved to SQL Server for production. The client decided that they didn't want to pay for the move to SQL Server, so we launched with Access as the backend. The database had tables containing from several hundred records, to over 100,000 records. The site grew in popularity and regularly recieved 10s of thousands of page views per day, each page having up to 10 or 15 database queries. Before moving to MS SQL Server a year later, we never had a single problem with Access. Not one. Now, that's not *huge* traffic, and I wouldn't recommend trying it today, but it certainly suprised me. -- Jack Baty Fusionary Media -- Original Message -- From: "Tyrone Mills" <[EMAIL PROTECTED]> Date: Fri, 22 Jun 2001 11:43:51 -0700 >Sounds like you could be a reference site for Microsoft!! Only 2 corruptions >using Access multi-user. That's incredibly good. I've supported systems with >only 3 concurrent users who suffered corruption on a nearly daily basis. > >- Original Message - >From: "John Meyer" <[EMAIL PROTECTED]> >To: "MySQL (E-mail)" <[EMAIL PROTECTED]> >Sent: Friday, June 22, 2001 10:16 AM >Subject: Re: ACCESS DB, and MySQL which one better to handle database driv >en webpage > > >> It only corrupted your database twice? >> >> On Friday 22 June 2001 09:50, Patrick Calkins wrote: >> >> > MySQL can handle infinately more concurent connections to it, and handle >a >> > much bigger load than MDB can even dream of doing. A few years back I >used >> > to write database apps in visual basic and MDB. It was running on the >> > network, with only about 5 people accessing it at one time. MDB had >> > corrupted the files at least twice. >> >> - >> 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 >> > > >- >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 > > - 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
