[H-GEN] Mysql dump file SQL syntax

[Paul Clarke]

Sorry, I forgot to say that I have also used that utility, however on the
remote server I do not have access to it so the only option I can see is to
use a command that I run from a web page.

Any ideas?

Paul.

-----Original Message-----
From: Majordomo [mailto:majordom at caliburn.humbug.org.au] On Behalf Of Ewan
Edwards
Sent: Friday, 25 October 2002 8:03 AM
To: general at lists.humbug.org.au
Subject: Re: [H-GEN] Mysql dump file SQL syntax


[ 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/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3072 bytes
Desc: not available
URL: <http://lists.humbug.org.au/pipermail/general/attachments/20021026/18ad43ec/attachment.bin>