InnoDB: Error: unlock row could not find a 4 mode lock on the record

Hi All, InnoDB repeatedly prints this message in the error log: # InnoDB: Error: unlock row could not find a 4 mode lock on the record Im not sure if the error message is critical or not, but its definitely not nice to have in the error log. After some exploration, I found this error is

Transactional problem

Hi all, Can anyone help me with the problem explained here please: http://www.reddit.com/r/mysql/comments/o256m/a_transactional_problem/ Thanks in advance.

Re: subselect

You may have to wait until version 4.1 if I am not mistaken. - Original Message - From: geeta varu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 21, 2003 4:09 PM Subject: subselect does mysql version 3.23 support subqueries ...if no does latest version 4.0 support...

Connecting to remote server

Hello folks (B I just installed mysql4.x into the home/username directory of a remote (Bmachine. It is running good and I created a new user tester with all (Bprivileges. (BBut how can i connect to the remote server running on a home directory using (Ba front end tool like MySQLFront. It is

Re: How to create a schema

Maybe If I get you in the right way, the answer for your second question is (B (Byou can use SQLYog or similar tools and can use them as a front end. (Bhttp://www.webyog.com/ (B (B (Bregards (BKS (B (B- Original Message - (BFrom: "Ayyaparaju Ganapathiraju" [EMAIL PROTECTED]

Is this possible with Linux

Hello folks (BIs it possible to install a MySQL server into the /home/*username* (Bdirectory in a typical Linux Installation. If so (B1. where to put those my.cnf files and set the global options for a (Bparticular user. (B2. How to connect to that database from a remote machine, knowing

Re: My dump does not work

When I faced the same problem, I was suggested to use MySQL Front. I have (Bbeen also using phpMyAdmin.Both work fine. (B (BHope this will help u (B (Bregards (B- Original Message - (BFrom: "srinath sundarrajan" [EMAIL PROTECTED] (BTo: [EMAIL PROTECTED] (BSent: Friday, February

Re: Off Topic - PHP/Mysql Development

- Original Message - (BFrom: "Richard Morton" [EMAIL PROTECTED] (BTo: "MySQL List" [EMAIL PROTECTED] (BSent: Tuesday, February 04, 2003 1:49 AM (BSubject: Off Topic - PHP/Mysql Development company (B (B (B Hi, (B (B I am sorry this is a bit off topic. (BTrue. Not only off topic

Re: copying innodb data

Hello Pippin I installed MySQLFront and can connect to my remote LinuxBox DB server. But I cant connect to my local machine with MySQLFront. My LinuxBOX server is listening to port 3316. My WinNTBOX server is listening to port 3306 But using PhpMyAdmin I can connect to both the servers

Re: copying innodb data

Hello Scott Pippin A small mistake on myside. Everything worked fine. Thanks for the suggestions. regards KayambooSuresh - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 5:54 AM Subject: Re:

Re: Entering Japanese characters into mySQL

In my case also I failed to set the charset to Shift-JIS though I put some stuff in my *my.cnf.* So I am now controlling the entire thing using my application. my charset is still latin1. I just get the input string from the user, convert it to a binary and store it in mysql. To display back I use

Getting back lost data using .frm files in InnoDB

mysql,query (BHello, I am posting it again. (B (BI have installed mysql4.0.8 replacing mysql4.0.3 (BI just copied all the database files in the *data* folder of mysql4.0.3 (Bthen copied the same to the *data* folder of mysql408. (B I suppose something happened and have got only the

getting backup data from .frm files in InnoDB

Hello (sql,query) (B I recently moved from mysql4.0.3 to mysql4.0.8gamma (BI did a copy of my databases inside the *data* directory alone(i.e. *.frm* (Bfiles) (B All the tables are InnoDb tables (B (BNow I copied all those files to my new MYSQL_HOME\DATA directory (B (BBut when I try to