left join in version 5.0.45

We have just moved to a new machine where we are running MySQL 5.0.45. On the old machine we were running MySQL 4.0.15a. The following query worked in 4.0.15a but gives an error mesage in 5.0.45. We're pretty sure the problem is with the left join. Did anything change? Here's the query:

backup questions

Hi guys, Is it safe to perform a backup of a database by copying its mysql files if the database is: 1) MyISAM and the database is not being used (mysql server turned off)? 2) InnoDB and and the database is not being used? 3) MyISAM and the database is being used? 4) InnoDB and and the

Re: backup questions

Hi, Option 2 will not work. InnoDB has background threads that continue to change data even when the database is quiet. This is a simplification. The details are too complicated to write in this thread, but there's an entire chapter on this topic in the book I'm writing right now, High

Re: left join in version 5.0.45

Hi, On Jan 28, 2008 5:31 AM, [EMAIL PROTECTED] wrote: We have just moved to a new machine where we are running MySQL 5.0.45. On the old machine we were running MySQL 4.0.15a. The following query worked in 4.0.15a but gives an error mesage in 5.0.45. We're pretty sure the problem is with the

Embedded versus 'normal' MySQL

Hello, I am using MySQL in a booking system I am working on. I decided to use an embedded server so downloaded 5.0.45 from source and compiled it with the embedded library enabled. It works fine except that disconnecting seems to take an exceptionally long time. Relevant lines from the log file

RE: backup questions

Hi Alex, I've used this method to start a replication slave without using MySQLdump to get the data from one machine to another. Option 1 works for sure, Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is changed while you are copying, you get a broken file on the other

Re: left join in version 5.0.45

Malki, which gives the error: ERROR 1054 (42S22): Unknown column 'depts.dept_code' in 'on clause' See the JOINs page of the manual. As of 5.0.12, MySQL improved ISO SQL compliance in query parsing; ambiguities due to comma join syntax became errors. It's highly recommended to switch from

MySQL, perl, last_insert_id() question

Hi, I know that someone is going to say, go ask the perl module guys and I will but they are likely to say, go ask the MySQL guys. I'll be asking in both groups. I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64) box that is running MySQL 5.0.45 (rpm install). I also have a

Re: MySQL, perl, last_insert_id() question

Do you have the latest version of DBI and DBD::mysql installed? First try: $ cpan cpan install DBI cpan install DBD::mysql You can also do: my $sth = $dbh-prepare(select last_insert_id()); $sth-execute(); my ($last_insert_id) = $sth-fetchrow_array(); Octavian - Original Message -

Encryption with collation

I have a column in a table that was turned into an cp1251_general_ci for a type of encryption. Question is, how do I unencrypt it? Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL database synchronization

Hi, If you have 256Kbps should not be a problem as long as it used most for mysql, if there are too may other user accessing net then it would be too slow. When you say, you want to access from both the sites, does it mean there would be read and write from both sites or just read from from one

Re: transfer huge mysql db

Ivan Levchenko wrote: Hi All, What would be the best way to transfer a 20 gig db from one host to another? mysqldump -A file.dump tar -jcf file.dump rsync or use replication to do it (might take a bit longer this way though). -- MySQL General Mailing List For list archives: