From: Peter Brawley
Date: February 13 2006 2:13am
Subject: Re: copy db to external host
List-Archive: http://lists.mysql.com/mysql/194831
Message-Id: <43EFEB64.9020803@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Angelo

>Is there any scripts that people know of that can be
>called from cron that I can use to copy the latest
>database to the latest version?

If you have shell access, you can run mysqldump to write the DDL and 
data to a sql file. See the mysqldump manual page for its many options.

AFAIK MySQL does not provide upgrade scripts to any version, so if there 
is a version difference between your internal and web hosts, you may 
have to make adjustments to the script which mysqldump generates.

PB

-----

Angelo Christou wrote:
>
> Hello List. I have an internal MySQL db that I would
> like to copy (replicate?) to an external webhost. I do
> not have shell access to the remote host which is why
> I cannot perform proper replication. How should I go
> about doing this?
>
> Is there any scripts that people know of that can be
> called from cron that I can use to copy the latest
> database to the latest version?
>
> The server is running unix, so I can use shell on the
> internal server.
>
> I would like to apologize if this should be asked in
> the replication list. It's not really replication that
> I need help with, I wasn't sure where to post.
>
> Thanking you in advance.Ang
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>
>   


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.6/257 - Release Date: 2/10/2006