On 27-Mar-2003 Ville Mattila wrote:
> Hello everyone,
>
> I was wondering how could I make a mirror copy of a table to another
> server
> in the easiest way? I browsed through the MySQL documentation but didn't
> find any clue of a "COPY TABLE" command or a similar method. I know that
> I
> can make a dump from a table and then run that dump file in another
> server -
> but maybe there are also better ways to do it?
>
If port 3306 is open on the firewall:
mysqldump mysqldump -e -q --add-drop-table db table | \
mysql -h otherhost -u user -ppasswd db
> I have two database servers, the one is running inside a local network
> and
> the other is running in the web. Because there are no web access to the
> local network database server, I need to do frequent copies
> (automatically)
> to the web to have some information in the website. This is why I'd need
> a
> "mirroring" feature.
>
> Any ideas?
>
> - Ville
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
