RE: Lost connection to MySQL server during query

[swati sandhya]

Hi,

How did you solve the problem, Lost connection to
MySQL server during query, please let me know this i
am facing the same problem.

thanks,
swati
--- Vernon Webb [EMAIL PROTECTED] wrote:
 Sorry all!
 
 I have resolved the issue. 
 
 -- Forwarded Message ---
 From: Vernon Webb [EMAIL PROTECTED]
 To: MySQL List [EMAIL PROTECTED]
 Sent: Sun, 13 Oct 2002 17:18:16 -0500
 Subject: Lost connection to MySQL server during
 query 
 
 After spending the entire day trying to figure out
 what the you-know-what 
 has happended to MySQL on my box, and after
 throughly messing things up and 
 fixing them again it has come down to a final error
 message when trying to 
 access some databases (some mind you, not all):
 
 Lost connection to MySQL server during query 
 
 Anyone have any idea what this is all about?
 
 Thanks
 
 -- 
 This message has been scanned for viruses and
 dangerous content by Webb Solutions' MailScanner,
 and is believed to be clean.
 
 

-
 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
 


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com

-
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: Create table if not exists from mysqldump?

[swati sandhya]

Hi,

Do u mean when u take a dump you need to add before
each table drop table if exists

then here is the command.

mysqldump -uusername -p -hhostname
--add-drop-table databasename tablename  test.sql

regards,
Praveen
--- John Kelly [EMAIL PROTECTED] wrote:
 Hi, I am trying to use mysqldump to dump the
 structure of a single database
 and want the output to make create table commands
 that include the IF NOT
 EXISTS switch so that when the file is imported into
 an existing database it
 does not write over tables with the same name. Does
 anyone know if this is
 possible with mysqldump and if so what option
 achieves this? Thanks.
 

-
 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
 


__
Do you Yahoo!?
New DSL Internet Access from SBC  Yahoo!
http://sbc.yahoo.com

-
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