Pada Fri, 19 Jul 2002 14:51:00 -0400
"Luis Manuel Cova" <[EMAIL PROTECTED]> menulis :
> Hi..
>
> I'm working on a proyect to implement a SQL server with PHP to allow acces
> to a MySQL server on the web.
> The Master server (the server everybody work with) is a Windows 2000 CENTURA
> SQL server.
>
> I want to know how i can manage to export a database from that server to
> another server (The one who will allow access to the database on the WEB)
> With what funtion can i do this, and also install a script to make the slave
> server update from the master database (This can be done once a day, it
> doesnt have to be inmidiate)
I think you have to create own tools for this purpose ...
the idea is :
1. to log query activities on master into files with syntax which compatible with mysql
2. the slave read the master log file, and do the query line by line into mysql server
I hope my idea can help u :D
--
Manchmal stehe nachts auf und installier's mir einfach...
-- H0arry @ IRC
MySQL 3.23.51 : up 32 days, Queries : 354.247 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
