MySQL commercial licence

Folks, We have a commercial product that uses mysql 4.0.24. We bought a commercial licence for this version. We want to upgrade to 5.0.21. I spoke with the MySQL saleswoman this morning and she says they don't do upgrades and want another entire licence fee for v5.x. Does anyone else have ex

RE: MySQL commercial licence

Checking. I don't think the customer bought the "network" version. Apparently its MySQL Pro Licence V4. It's a bit rich not to offer upgrades at a discount IMO. Adam -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: 12 May 2006 11:52 T

Drop Index if Exists

Folks, Does this work in MYSQL 5? I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your syntax". Thanks - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Drop Index if Exists

Thanks What I am getting at is: does the "IF EXISTS" qualifier work in this context? I have an index that is present in some DB's but not in others. I want to run a generic script to upgrade them all. I don't want the script to stop if the index is not present. Thanks - Adam Visolve DB TEA

backwards compatibility when exporting M

rt '
' to 1, '\0' to 0. Does anyone know a way around this? TIA - Adam Lipscombe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqldump line endings

Folks By default mysqldump uses linefeed as the line ending. This results in the data looking odd in a Windows text editor, as they expect \r\n. I have experimented with the --tab and --line-terminated-by options, but this results in a separate txt file for each table. Is there any way to persu

Mysqldump INSERT statements (Was Mysqldump line endings)

>> (--result-file) option to save your output but use the > output redirector >> to map the output of mysqldump to a file you specify, you will get the >>CRLF line endings you seek. Many thanks. One more thing: by default mysqldump uses --extended-insert=TRUE. This results in all the VALUES

Problems with importing the british pound (£) an d euro (€) sign

Folks, I have a mysql 5.0 db with the following char sets: mysql> show variables like '%char%'; +--+--+ | Variable_name| Value| +--+--+ | character_set_client | lat

how to "drop index if exists"

Folks How can one conditionally drop an index in MySQL? Googling shows that the "drop index" does not support an "if exists" qualifier - apparently a bug has been raised but as far as I know its not fixed yet. Does anyone know of a work-around? TIA - Adam -- MySQL General Mailing List Fo

Re: how to "drop index if exists"

Fantastic, thanks very much! Adam Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote: Folks How can one conditionally drop an index in MySQL? Googling shows that the "drop index" does not support an "if exists" qualifier -

Re: how to "drop index if exists"

. ALTER IGNORE TABLE table_name DROP INDEX index_name; ALTER IGNORE TABLE table_name ADD INDEX UNIQUE index_name(column_1,column_2); Thanks - Ada Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote: Folks How can one conditionally drop an index in

How to set trabnsaction isoloation in my.ini file

I have MySql 4.1.12 installed on an XP box in C:\mysql. I have the settings below in my C;\MySql\my.ini file: I have the transaction-isolation set to READ-COMMITTED but the server seems to ignore this. When the server starts up the tx_isolation as reported by mysqladmin extended-status is REPEATA

RE: How to set trabnsaction isoloation in my.ini file

#x27;cos the mySQL installer created the file in the installation dir. Many thanks - Adam -Original Message- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 17:23 To: Adam Lipscombe Cc: mysql@lists.mysql.com Subject: Re: How to set trabnsaction isoloation in my.ini