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 relevant to Bugs*#41756, #48306, #53674. * But I couldn't find out, how to resolve this! Kindly help! Below are some details. mysql = 5.1.43 Storage engine = innodb; transaction-isolation = READ-COMMITTED; binlog_format = mixed; ** ** Thanks,
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... __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting to remote server
Hello folks I just installed mysql4.x into the home/username directory of a remote machine. It is running good and I created a new user tester with all privileges. But how can i connect to the remote server running on a home directory using a front end tool like MySQLFront. It is listening to default port 3306. Any lights? regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to create a schema
Maybe If I get you in the right way, the answer for your second question is you can use SQLYog or similar tools and can use them as a front end. http://www.webyog.com/ regards KS - Original Message - From: "Ayyaparaju Ganapathiraju" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 10:30 AM Subject: How to create a schema Hi, I have two questions here, please. 1). Is there an equivalent to creating a schema in MySQL. I would like to create tables in multiple schemas within the same database. Some of the tables will have foregign keys across schemas. I'm aware that I can create multiple databases and switch between databases using "use database name". 2). How can I edit a statement within mysql. Suppose if I make a typo in a large select statement, can I go into an editor and fix it, then execute it from the buffer. Any suggestions. Raju Ganapathiraju _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is this possible with Linux
Hello folks Is it possible to install a MySQL server into the /home/*username* directory in a typical Linux Installation. If so 1. where to put those my.cnf files and set the global options for a particular user. 2. How to connect to that database from a remote machine, knowing the IP of the host machine and the *username* ( linux user ) Thanks for any help regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My dump does not work
When I faced the same problem, I was suggested to use MySQL Front. I have been also using phpMyAdmin.Both work fine. Hope this will help u regards - Original Message - From: "srinath sundarrajan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 4:11 PM Subject: My dump does not work Hello, I face a problem in transfering a mysql db from 1 machine to another. I used the mysqldump command to take the dump of a db from machine A running linux. I put the same on to a machine B running on linux. Then I used the mysqldump command to create the database. In all 15 tables should be there. Unfortunately only 3 tabels are there. The dump restoration stops midway through the third table without giving any error. I tried opening the original .sql file in wordpad. All the tabels records are there. Any idea what could be the problem. Is there any way to transfer table by table. Machine B is a new one. Thanks regards, Srinivasan. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Off Topic - PHP/Mysql Development
- Original Message - From: "Richard Morton" [EMAIL PROTECTED] To: "MySQL List" [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 1:49 AM Subject: Off Topic - PHP/Mysql Development company Hi, I am sorry this is a bit off topic. True. Not only off topic but very rude I am looking for recommendations of MySQL / PHP / HTML / Javascript development companies. Companies which you have previously worked and found to be very good at what they do and good value. They need to be English speaking. I am especially looking for companies in south of the UK. If you need some companies from the south of UK go and search for it. I have previously used a company in India and I am not averse to trying this again. You are not supposed to turn your face against all indian companies and just pass your personal comments in a userlist like this. Your experience may be bad with that company becoz you might have looked for some cheaper quality in the past I take the privilege to remind you that most of the CMM Level5 companies sit in India and not near you. If you really look for quality go to those big giants. If you abuse an entire country for your bitter experience then All the Britons will be abused for the reason, our country was looted for more than 150 years by your imperial past. Suggestions anybody... Hope you will not put these kind of shit again to such user lists. Thanks to all. You are welcome Richard SQL KayambooSuresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 from my WinNtBox. Any suggestions? regards KayambooSuresh - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 12:30 AM Subject: Re: copying innodb data I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? Download MySQLFront from: http://mysqlfront.sstienemann.de/ Install it on your windows machine and log in to the MySQL server on your windows machine. Then open another window and log in to your linux box in MySQLFront. Click on the Import/Export option and select Export tables. Select the Another Host/Db option. I hope this works, let me know if you have any other problems. Scott Pippin [EMAIL PROTECTED] (sql, query, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: copying innodb data Hello folks I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? 1. Download MysqlFront from http://mysqlfront.sstienemann.de/ 2. Install on Windows machine. Open a connection window to both your windows MySQL server and your Linux MySQL server. 3. Click on the import/export menu and select export tables. 4. click on the Another Host/db option and select you Linux MySQL Server, then copy the tables over. This worked a lot better for me than mysqldump. The larger tables seemed to transfer faster than with mysqldump. Let me know if you have any other questions. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 vice versa. You can use a bean component to do this job. In case if you dont get this, mail me and I will send you my bean that you can use in your program regards KayambooSuresh - Original Message - From: Darren Luckett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 9:58 PM Subject: Entering Japanese characters into mySQL hello, I'm new to this mailing list and am having trouble with mySQL and japanese characters. I have a web form in Netscape that the user enters japanese text (hiraghani). the data is posted to a dbinsert.jsp page. the problem is that somewhere along the line the character set transforms into half-width katakana (usually a language used for non-japanese origin words - i.e English or Computer). I am using JSP and Tomcat with Apache on Mac OSX. I've tried setting the charset to Shift-JIS, JIS, ujis, AutoDetect EUC but with no results. JIS is the most stable. Can anybody help Thanks Darren Luckett E: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting back lost data using .frm files in InnoDB
mysql,query Hello, I am posting it again. I have installed mysql4.0.8 replacing mysql4.0.3 I just copied all the database files in the *data* folder of mysql4.0.3 then copied the same to the *data* folder of mysql408. I suppose something happened and have got only the *.frm* files for one particular database. Remaining are working fine. Is there any way to get back my data using these *.frm* files where all the tables are *InnoDB* for that particular database ? regards KayambooSuresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
getting backup data from .frm files in InnoDB
Hello (sql,query) I recently moved from mysql4.0.3 to mysql4.0.8gamma I did a copy of my databases inside the *data* directory alone(i.e. *.frm* files) All the tables are InnoDb tables Now I copied all those files to my new MYSQL_HOME\DATA directory But when I try to open those tables it shows the following error - Cannot find table sample/trial from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? Look from section 15.1 of http://www.innodb.com/ibman.html how you can resolve the problem. - I went through the manual but dont get the exact meaning. Any help is appreciated. regards KayambooSuresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php