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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]