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

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

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

(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] 08-934-3036 -- MySQL General Mailing List

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], Edward Kay [EMAIL PROTECTED

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

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: Thanks for the email but that didn't help

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, Malka Cymbalista wrote: We have just

Re: mysql privileges

flush 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 [EMAIL PROTECTED] wrote: Brown

mysql privileges

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. Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934

Re: mysql privileges

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 Schwartz [EMAIL PROTECTED] wrote: Hi, On Tue, Mar 18, 2008 at 8:49 AM

mysqlhotcopy

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

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

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