"Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]...
> On Sunday 07 April 2002 17:08, Hayan Al Mamoun wrote:
> > Dear all,
> > I have two design-identical database, one on my intranet, the other on
the
> > internet, is there any procedure that Synchronizes the content of two
> > databases?
> > I'm using PHP applications and MySQL Database, WindowsNT4 IIS
>
> You've got several options and it all depends on how synchronised you
> need/want them to be. If you need up-to-the-minute sync then the mysql
> replication feature is the only way to go.
>
>
> Other methods are:
>
>
> Using mysqldump:
>
>
> 1) Dump from local mysql straight to remote mysql:
>
> "mysqldump --opt name_of_database | mysql --compress -h remote.mysql.host
> name_of_database"
>
>
>
> 2) Dump from local mysql and compress to file:
>
> "mysqldump --opt name_of_db | gzip > name_of_db.gz
>
> Then ftp to remote, decompress and import.
>
What happens to a blob field with lets say a image when dumping a mysql
table to a file?



>
> 3) Install phpMyAdmin on both machines.
>

How do i replicate 2 mysql db:s with phpmyadmin?

/Micke
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
>
> /*
> BARBARA STANWYCK makes me nervous!!
> */



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to