RE: problems with INNODB tables

...@weizmann.ac.il 08-9343036 -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, April 23, 2012 9:42 PM To: Andrés Tello; Malka Cymbalista Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun Subject: RE: problems with INNODB tables Check your memory usage

Quit in MySQL logs

the log. Thanks for any help. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

Thanks to Martin and Paul for their answers. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 3:54 PM, in message <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 1:13 PM +0300 4/9/08, Malk

Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45

Thanks. So how does one use the password function in MySQL 5? -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 2:57 PM, in message <[EMAIL PROTECTED]>, "Martijn Tonies" <[EMAIL PROTECTED]> wrote: &

Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45

Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? -- Malka Cymbalista Webmaster, Wei

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

Thanks for the answer but that's not it. It was my typo. I am really updating and selecting from the same table. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 1:54 PM, in message <[EMAIL PROTECTED]>,

We have just moved to a new web server where we are running mysql version: 5.0.45

protein_passwd WHERE (user_name = "xx" AND passwd=password('xx')) we got the expected results. Now when we do this, on the new machine, we get no result i.e. Empty set. Any help will be appreciated. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED]

Re: mysql privileges

mmandflush privileges Everything worked perfectly after that. Thanks again to everyone who helped. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 3/19/2008 at 6:10 PM, in message <[EMAIL PROTECTED]>, Sebastian Mendel <[

Re: mysql privileges

query I can give any other command but when I try to give the grant command I keep getting the same error. Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 3/18/2008 at 3:20 PM, in message <[EMAIL PROTECTED]>, "Baron Schwart

mysql privileges

| | When I give the following command, I aslo get the same results on both machines: select * from user where user ="super"; The results are N for all the different privileges. Has anything changed in MySQL 5.0.45 that would cause this behavior? Thanks for any help.

mysqlhotcopy

s anyone have any suggestions as to what I can do to get this to work. thanks. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

log files and upgrading

. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

looping error message

We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql 3.23.49 on a Sun Solaris machine. Every now and then, one of the scripts we are runing gives the following error message: null: DBD::mysql::st fetch failed: fetch() without execute() at /usr/local/lib/perl5/site_perl/local/Cale

Mysql 4, Solaris 9 and Perl 5.8

We are getting new Solaris machines on which I plan to install MySQL. We will be installing Solaris 9 on these machines. Offhand, does anyone know if there are problems with compiling and installing MySQL 4 on Solaris 9. I am also planning on installing Perl 5.8 on these new machines. The la

Re: An existing table

Give the command: alter table tablename add column column_name create_definition (section 7.7 in the mysql manual) Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] >>> Yair Zohar <[EMAIL PROTECTED]> 07/07/02 01:46PM >>> Hello, Is there