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 Peter Brawley
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 - Angelo Christou wrote: Is there any scripts that people know of

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.

Re: copy db to external host

2006-02-12 Thread Peter Brawley
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 M

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