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
