Re: Sync 2 live MySQL Databases

2005-05-26 Thread Cecil Brand
at PO Box 339 Bloemfontein 9300 South Africa Tel :401 2940 Email :[EMAIL PROTECTED] >>> Simon Garner <[EMAIL PROTECTED]> 5/26/2005 8:56:14 AM >>> On 26/05/2005 6:40 p.m., Cecil Brand wrote: > Hi, > > I was wandering if anyone know of a stable and reliabile way

Sync 2 live MySQL Databases

2005-05-25 Thread Cecil Brand
Hi, I was wandering if anyone know of a stable and reliabile way to sync 2 live mysql databases, both ways. I know I can use a master and slave, and yes have setup a few without any problem, but as all of us know this is just a one way downstream sync. I need to sync both ways and basicly live, th

Problem with Limit function in MySQL 4.1.9

2005-02-24 Thread Cecil Brand
Hi, I have the following problem, I'm converting from version 3.23.53 to 4.1.9 The following query was used SELECT * FROM news WHERE languages_id = 'english' AND expiry_ts >= CURDATE() AND FCode = '999' AND DCode = 'Z999' ORDER by id DESC LIMIT 0, 3 it work perfectly on the version 3.23.53 (the

Rebuilding Indexs on tables

2003-07-29 Thread Cecil Brand
Hi, I was wandering is there an easy way to rebuild indexs on tables I have the .frm and .MYD files. I read in the mysql manuals about backup_tables and Restore_table that rebuild the index but is there any other way to rebuild them. I'm using Mysql 3.23.53a on linux 2.1 AS thx Cecil Mnr Ceci

Delete with Left Join???

2003-06-12 Thread Cecil Brand
Hi, I'm using: mysql Ver 11.18 Distrib 3.23.53a, for pc-linux-gnu (i686) I did the following query succesfully SELECT * FROM staff_user LEFT OUTER JOIN staff ON SCode1 = staff_SCode WHERE SCode1 IS NULL It returned all the row that was not in the right table. Know I want them deleted, bu

Re: store JPG in MySQL DB

2002-05-20 Thread Cecil Brand
Wel it depends on what you want to do. If it's webpages, the file system idea is ideal, but if its a binary run by many people on different machines you'll have to map the directory holding the images to every machine. That a big no no, due to security risks getting higher. The db idea is then