Re: MySQL database synchronizing from 2 locations

2007-08-05 Thread C K
Hello, As per your suggestions I tried to get some correct solution for the problem, but there is a big problem for replication and it is network connection. Though Internet is available to the Mfg. Site, it is not having good speed and continuous. So that replication may not be a good choice. As

Re: MySQL database synchronizing from 2 locations

2007-08-05 Thread Richard
Sorry maybe this is completly out of topic, but why do you need it to synchronise in two locations, can't you just get both servers to connect to the same database? And then if you need you can set a cron to backup your database hourly or daily to the other server using mysql dump and scp. I

Images

2007-08-05 Thread Hodren Naidoo
Hi How do I add an image to a database and how do I extract from the database? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Images

2007-08-05 Thread Martin Gainty
Hodren How are you storing the image in MySQL..I assume longblob? What format will you use to display the image {jpg|gif|png}? Here is a script which will load the images to your AS movie http://www.actionscript.org/forums/showthread.php3?t=76421 HTH/ Martin This email message and any files

Re: MySQL database synchronizing from 2 locations

2007-08-05 Thread Martin Gainty
Richard- If you have 2 or more servers which you want to dedicate to MySQL you may want to look into MySQL Clustering To focus on sync'ing I would read about the the 'syncronisation replication' vs 'asynchronous replication' that the Participating Nodes employ