Re: copy db to external host

2006-02-12 Thread Angelo Christou
--- Peter Brawley <[EMAIL PROTECTED]> wrote: > Angelo, > > >Upload the data > > If phpMyAdmin is your only access to your webhost > db, you can paste the > contents of your local dump.sql into phpMyAdmin's > SQL window, and run it > (all at once, or piece by piece). > > PB Hello Peter. Tha

Re: copy db to external host

2006-02-12 Thread Angelo Christou
> >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.

copy db to external host

2006-02-12 Thread Angelo Christou
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 fr