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
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
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
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
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
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