DEADLOCK MYSQL 5.1.37

2009-09-14 Thread Krishna Chandra Prajapati
Hi guys, I am getting very frequent deadlock in mysql 5.1.37. I am not able to understand why this below deadlock is coming. *** (1) TRANSACTION: TRANSACTION 0 1036157191, ACTIVE 0 sec, process no 4101, OS thread id 1908412736 fetching rows mysql tables in use 1, locked 1 LOCK WAIT 3 lock

Re: Mysql prepare statement

2009-09-14 Thread Johan De Meersman
You can't make the database, table or field names dynamic with prepare, only values. Prepare allows you to cache the execution plan, which wouldn't be valid on a different table. On Mon, Sep 14, 2009 at 7:09 AM, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I have a query about

JPA, InnoDB, and locking in multi-threaded app

2009-09-14 Thread Grover Blue
Hi everyone, I have an application that spawns various threads for inserting into various table. Additionally, another thread is launched to delete old records. They all use JPA and entity managed transactions. I think I'm getting locking issues, but I'm not sure. So, I'd like to get your

HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Néstor
Maybe one of you experts know the answer. I have a Innodb database that I want to back up. Is there a free tool to do this? mysqlhotbackup is a paid tool, is that the only one available? If I do a mysqldump of the innodb databse, will I be avail to uploaded into a myisam database and will it

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Néstor
Sorry, I meant to say that the backup DB does not look the same as the original DB. Maybe it has to do with what Todd and Mychael mentioned. The percona tool does not work on Windows OS. I could not find a windows executable. Thanks, Nestor :-) On Mon, Sep 14, 2009 at 9:13 AM, Néstor

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Michael Dykman
If I may, If you have foreign keys on your InnoDB, you can still import your data to MyISAM but foreign keys will be lost. Otherwise, the data will load just fine. - michael dykman On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons tly...@ivenue.com wrote: On Mon, Sep 14, 2009 at 7:44 AM, Néstor

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Néstor
I did it again and using sqlyog did work. I also found out that the tool that comes with mysql admin 1.1 also has a backup tool that works. Thanks to all, Nestor :-) On Mon, Sep 14, 2009 at 9:16 AM, Néstor rot...@gmail.com wrote: Sorry, I meant to say that the backup DB does not look the

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Néstor
I tried this but when I upload the backup it just does not look the same. Thanks, Nestor :- On Mon, Sep 14, 2009 at 8:04 AM, prathiman...@vsnl.net wrote: Use sqlyog its a freeware Sent from my BlackBerry® on Reliance Mobile, India's No. 1 Network. Go for it! -Original Message-

Re: MySQL DB Server - 5.1

2009-09-14 Thread muhammad subair
On Mon, Sep 14, 2009 at 11:15 PM, Kaushal Shriyan kaushalshri...@gmail.comwrote: Hi, I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1 server, but i dont find it after apt-get update ? Please suggest/guide Thanks, Kaushal Hi, the options from discussion in Ubuntu

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Todd Lyons
On Mon, Sep 14, 2009 at 7:44 AM, Néstor rot...@gmail.com wrote: Maybe one of you experts know the answer. I have a Innodb database that I want to back up.   Is there a free tool to do this? mysqlhotbackup is a paid tool, is that the only one available? You can also use the free tool from

RE: database design

2009-09-14 Thread Jerry Schwartz
-Original Message- From: AndrewJames [mailto:andrewhu...@gmail.com] Sent: Saturday, September 12, 2009 1:20 AM To: Kyong Kim; Arthur Fuller Cc: Claudio Nanni; mysql Subject: Re: database design thank you all, i think You probably wouldn't need Article_Type table if you're going to store

MySQL DB Server - 5.1

2009-09-14 Thread Kaushal Shriyan
Hi, I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1 server, but i dont find it after apt-get update ? Please suggest/guide Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Todd Lyons
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman mdyk...@gmail.com wrote: If I may, If you have foreign keys on your InnoDB, you can still import your data to MyISAM but foreign keys will be lost.  Otherwise, the data will load just fine. Very good point. My comment was based on the possibly

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Michael Dykman
A mysqldump will work just fine. By default, that dump is going to explicitly specify the table type .. you will have to edit it if you want to import to MyISAM. - michael dykman On Mon, Sep 14, 2009 at 10:44 AM, Néstor rot...@gmail.com wrote: Maybe one of you experts know the answer. I

Right Date format mask

2009-09-14 Thread John Meyer
I'm pulling in a date with the following format 9/14/2009 2:12:48 PM And using this mask to convert it using the str_to_date() function: %e %m %Y %r but it keeps giving me an error. Do I have the right mask? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Right Date format mask

2009-09-14 Thread Dan Nelson
In the last episode (Sep 14), John Meyer said: I'm pulling in a date with the following format 9/14/2009 2:12:48 PM And using this mask to convert it using the str_to_date() function: %e %m %Y %r but it keeps giving me an error. Do I have the right mask? Nope. Assuming your input string

Re: Right Date format mask

2009-09-14 Thread John Meyer
Dan Nelson wrote: In the last episode (Sep 14), John Meyer said: I'm pulling in a date with the following format 9/14/2009 2:12:48 PM And using this mask to convert it using the str_to_date() function: %e %m %Y %r but it keeps giving me an error. Do I have the right mask? Nope.