[H-GEN] Mysql dump file SQL syntax

[Ewan Edwards]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

On Fri, 25 Oct 2002 07:34, Paul Clarke wrote:
> [ Humbug *General* list - semi-serious discussions about Humbug and     ]
> [ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

>
> Is there a sql command that will save a file that I can use to import
> the data onto the new database?

There is a utility that comes in the MySQL package called mysqldump.  I 
suspect this is exactly what you're looking for.  Look at the man page for  
mysqldump for an introduction.  Then check this url for more complete doco.

http://www.mysql.com/documentation/index.html

In there you will also find information about importing the dump file to 
another database.



-- 
Ewan Edwards BE MIEAust CPEng MCSE
Systems Administrator
MineStar Solutions
Ewan.Edwards at cat.com
Telephone: +61 (0) 7 3329 8124
Facsimile: +61 (0) 7 3329 8101
_______________________________________________________________

Growing old may be mandatory, but growing up is still optional.
_______________________________________________________________
This message is for the intended addressee only and may contain 
confidential information.  If you've received this message in 
error then I've probably screwed up.  So I'm obliged to ask you 
to please delete the message and notify me as soon as possible.

The contents of this message are probably my opinion only and 
are most likely not endorsed by anyone, including the people 
who payed me for the time spent writing it.


--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/