If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

Le Tue, 23 Dec 2008 15:33:34 +, KLEIN Stéphane a écrit : Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1

Re: How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

2007/6/13, Ricardas S [EMAIL PROTECTED]: ops again you probably needed just select greatest(col1,col2,col3) from t order by 1 Thanks, it's work very well. best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

Hi, I would like do something like : SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); I know this syntax is wrong but I would like get a solution to this stuff. Thanks for your help. Stephane -- MySQL General Mailing List For list archives:

Re: How can I do something like this SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); ?

2007/6/13, Ricardas S [EMAIL PROTECTED]: Ops, small mistake, shoud be MAX((col1*(MAX_VALUE_OF_COL2+1)+col2)*(MAX_VALUE_OF_COL3+1)+col3) Sorry, my question is ashamed. Example, I've this row : Col1 | Col2 | Col3 1 | 5 | 8 6 | 2 | 4 12| 13 | 6 After my query,

Are there any tools to get diff (alter commands) between tow tables ?

Hello, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Thanks for your information. Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Are there any tools to get diff (alter commands) between tow tables ?

2007/3/19, Martijn Tonies [EMAIL PROTECTED]: Hi, I wonder if there are any tools to do a diff between two tables struture to result alter command to convert table A structure to table B structure ? Yes, our tool Database Workbench includes a so-called Schema Compare tool which allows you to

Re: Can I set many IP address with bind-address ? If not, how can do same thing ?

2006/10/4, Dominik Klein [EMAIL PROTECTED]: You can only specify one IP address to bind to. If you omit this option, mysqld will bind to all addresses on the machine. If this is not what you want, you could block mysql-access with a packet filter for the IP addresses you do not want to bind

Can I set many IP address with bind-address ? If not, how can do same thing ?

Hi, Can I set many IP address with bind-address ? If not, how can do same thing ? In documentation, I read this : ''' -bind-address=IP The IP address to bind to. ''' They don't say if I can use comma to separate two or many IP. Thanks for your help, Stephane -- MySQL General Mailing List

How to READ/WRITE directly on MyISAM data files ?

code). thank you Stéphane. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to READ/WRITE directly on MyISAM data files ?

a row in my query. But this Field (RowID) can now be seen when I do a SELECT query. I did not find a way to hide this field. So my first question should be : Is there a way to hide a field ?? Best Regards, Stéphane. -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent

RE: How to READ/WRITE directly on MyISAM data files ?

writing these queries all the time). I want him to be able to write SELECT * FROM ATABLE. Thank you, Stéphane. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: 11 décembre, 2003 08:41 To: Stéphane Bischoff; Martijn Tonies; MySQL (E-mail) Subject: RE: How to READ

RE: How to READ/WRITE directly on MyISAM data files ?

RowId, Name, Company, Price, Warranty FROM product he would get the RowId in his query output. Best Regards, Stéphane. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: 11 décembre, 2003 08:49 To: Stéphane Bischoff; MySQL (E-mail) Subject: RE: How to READ/WRITE

RE: How to READ/WRITE directly on MyISAM data files ?

Just wanted to know if it was possible to hide fields for whatever reason. Judging by your response, the answer is no. Therefore, I will look at other alternatives. Thanks, -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: 11 décembre, 2003 09:09 To: Stéphane

RE: Licence question

Thank you for all your response, but my question is very simple : Example : We have company 1 that make's a product that communicate with MySQL server using TCP/IP. This product (company 1) does not use the MySQL client to connect to MySQL server. (Don't ask me how, I don't know) (By the way,

How do I know what my MySQL server IP is ??

Hi, w do I know what my MySQL server IP is ?? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Licence question

Hi, We are programming a Delphi application that interacts with the MySQL server from Windows. Normally we would need a client side licence ? But if we use a set of components (from a third party) that allow us to interact with the MySQL server without using the MySQL client. In this case, do

Unable to access primary key

I get an error Unable to access primary key each time I attempt to insert or update a record. But everything seems to be OK with my PK. CHECK TABLE doesn't see any problem. Any idea ? Regards. Stéphane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Unable to access primary key

I get an error Unable to access primary key each time I attempt to=20 insert or update a record. But everything seems to be OK with my PK.=20 CHECK TABLE doesn't see any problem. Any idea ? Regards. Stéphane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

issues with mysql

to create a user with privileges. Any idea ? Regards. --- Stéphane Pinel Information System Equinox Partners Paris iChat/AIM: s.pinel

Mysqld to listen from an other port than 3306

to do that ( MacOS X ). Thanks. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Mysqld to listen from an other port than 3306 (2)

to do that ( MacOS X ). Thanks. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Mysqld to listen from an other port than 3306 (2)

Le 7/10/02 7:33, « Iikka Meriläinen » [EMAIL PROTECTED] a écrit : On Mon, 7 Oct 2002, Stéphane Pinel wrote: What is the best strategy to make mysqld listen from another port than 3306 ? In fact we have 2 servers that handle mysql. The first is listening at port 3306 but we need

Re: install mysql on osx 10.2

please assist james You'd better get the Marc Liyanage package and follow his very clear and understandable instructions: http://www.entropy.ch/software/macosx/mysql/ Regards. -- Stéphane Pinel Equinox Partners France Information System

[NEWBIE] Master Account

I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. -- S.PINEL - Before posting, please check:

mysql log rotate

in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html : 1) shell cd mysql-data-directory 2) shell mv mysql.log mysql.old 3) shell mysqladmin flush-logs What's happening if there is a query between line 2 and 3, is it logged ? How could I rotate my files without a query not

RE: SQL Query Help

[mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:47 PM To: Danis Stéphane (NHQ-AC); [EMAIL PROTECTED] Subject: Re: SQL Query Help Stéphane, I have INVOICE table here is the layout: +-+---+--+-+-+-- --+ | Field

RE: SQL Query Help

report to build for cities, so I prefer using the variable data (ie. state/city) as rows and keep the fixed data (ie. month) as column. Stephane -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:01 AM To: Danis Stéphane (NHQ-AC); [EMAIL

SQL Query Help

I have INVOICE table here is the layout: +-+---+--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+-- --+ | ID

MySQL Book

Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane SQL, Query - Before posting, please check:

Best solution for a very busy MySQL server

for advices. Stéphane HENRY - 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

Cannot UPDATE mysql record in ASP

I get this error when trying to update a record using ASP recordsets. Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /Web_local/admin/xt_save.asp, line 39 What is

Installation of grant tables failed

/mysql_install_db --log here, I get message saying that mysqld got signal 11, and that installation of grant tables failed Fix: Submitter-Id: KLEGOU stéphane Originator:root Organization:Personnal user MySQL support: none Synopsis: 'mysqld got signal 11;' when I've tried to install

UPDATE :-(

database,sql,query Hi everybody, i have 2 tables 1) test - id_test - country_name - etc... 2) country - id_country - contry_name i want to join this 2 tables in case of deuce of the country_name and update test.id_test with the value of