Re: Advice for dataupload

"Jason Wong" <phplist@gremlins.com.hk> skrev i meddelandet news:php.db-18294@news.php.net... > 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!! > */