RE: creating database

2002-07-11 Thread Darley, Terry
Setup a user level my.cnf file and make sure the data dir isn't overriden by the other levels of my.cnf Just a theory, I haven't tested it ! -Original Message- From: Info [mailto:[EMAIL PROTECTED]] Sent: 11 July 2002 15:17 To: [EMAIL PROTECTED] Subject: Re: creating database sql,query

RE: Moving a DB from one Server to another

2002-07-08 Thread Darley, Terry
If the OS is the same on each server (including patches just to make sure) and the MySQL version is the same, then yes, you can simply copy the "data" directories from one server to another Make sure you FLUSH everything first and take MySQL off-line. -Original Message- From: Todd Cary [

RE: mysql.com site down

2002-07-02 Thread Darley, Terry
I'm in the UK and I can get to it okay !!! Perhaps something has changed on your PC/Network ??? -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 10:45 To: [EMAIL PROTECTED] Subject: RE: fulltext searching Hi If anybody from mysql is listening / watchi

RE: Unions

2002-06-27 Thread Darley, Terry
Yes, I agree sub-queries should be the highest priority with the next release judging from the e-mails going around at the moment. This was the first problem I found in my first day using MySQL. I don't understand with all the versions that have been released of MySQL since 1996 why they neglect