What would happen in these two cases?

I hope this is not a so dumb question: Case 1: I have a table A under a running MySQL 4.1.3b server. If I replace A.MYD and A.MYI files without stop and start the server, will data gets corrupted? Case 2: I rename A to A1, and A2 to A, assume A, A2 have the same schema but different data/index.

Kernel died after db_admin

Hi, Got this error after creating database instance and param settings: (I'm using MaxDB on Solaris 9, e450 server) ./dbmcli on VTeam105>db_admin ERR -24994,ERR_RTE: runtime environment error 1,Check knldiag! Kernel died before reaching ADMIN state I checked knldiag.err and it mentioned in

Re: NOT NULL

- Original Message - From: "Justin French" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Sunday, August 08, 2004 11:13 PM Subject: NOT NULL > Can someone give me a quick/clear explanation about why you would > create a table with columns of NULL / NOT NULL? > > I clicked aro

Re: NOT NULL

On Sunday 08 August 2004 22:13, Justin French wrote: > Can someone give me a quick/clear explanation about why you would > create a table with columns of NULL / NOT NULL? > > I clicked around the MySQL manual last night I *think* I know what's > what, but it'd be great to read one clear paragraph t

NOT NULL

Can someone give me a quick/clear explanation about why you would create a table with columns of NULL / NOT NULL? I clicked around the MySQL manual last night I *think* I know what's what, but it'd be great to read one clear paragraph that summarises it all. --- Justin French http://indent.com

"proxy" a connection to remote host?

Hello, I'm new to this list so I hope this is the right type of question that can be asked. At work I have access to a particular database only from a particular host, say X. I would like to write a little script to view the data. The script would be running on host Y. Is it possible to somehow

Re: creating a new user with "mysql" on 4.0.20a

On Sun, 2004-08-08 at 07:22, Kerry Frater wrote: > I am just going through some taching docs and it says that I can create a > new user with all authority on a new DB using the command > > GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword'; > > yet when I try and run 'mysql' using > mysql

FW: creating a new user with "mysql" on 4.0.20a

Oops, used wrong email address -Original Message- Sent: 08 August 2004 12:23 To: [EMAIL PROTECTED] Subject: creating a new user with "mysql" on 4.0.20a I am just going through some taching docs and it says that I can create a new user with all authority on a new DB using the command GR

creating a new user with "mysql" on 4.0.20a

I am just going through some taching docs and it says that I can create a new user with all authority on a new DB using the command GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword'; yet when I try and run 'mysql' using mysql -uauser -pthepassword I get the error ERROR 1045: Access deni

Re: Query Cache

Thanks to all who replied. Regards Terry Riley - Original Message - > We have the query cache turned on, and it appears to be working well. > > However, there appears to be no indication in the manual as to the time > that a cached query remains in memory. In the absence of this > in