Re: Moving innodb from Linux to Windows

Boyd, --=_NextPart_000_0038_01C4C7F5.22045240 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit All: I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows (4.1.6). I have everything running, and I can query tables that are all lower case.

RE: Help with query performance anomaly (SOLVED)

It turns out that it appears to be a data discrepancy that caused the query optimiser to, well, not optimise. I thought the main table (r) with 3million records would be the problem, but it was table p with 3100 records on the live server and 3082 records on my dev pc that caused the problem.

Re: Maximum row size for MyISAM table type

Hi Joshua, the BLOB or TEXT is stored separately from the row. What is stored is a pointer to where the BLOB/TEXT is located. /Johan Joshua Beall wrote: Hi All, I am a bit confused by the MySQL documentation on this subject. From http://dev.mysql.com/doc/mysql/en/Storage_requirements.html The

not recognizing an index (possible_keys)

I've had something funny happen to me thismorning: I did an EXPLAIN - it couldn't find an index that was there. Then I did a DESCRIBE. Then I did an EXPLAIN again, and it *could* find the index. Is this expected behaviour? (4.0.22-standard) 1st EXPLAIN:

Re: Moving innodb from Linux to Windows

Hello. Windows filesystem is not case sensitive. See: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows (4.1.6). I have everything running, and I can query tables that are all lower case.

Re: mySQL 4.1.3-beta subqueries(correction on table names)

Hello, Lana. Both queries works fine in 4.1.7 version. There were a lot of bugs in earlier versions of MySQL with subqueries. I think you should upgrade to the latest release. Did you use $sql=.. in mysql client program? That won't work. Try just SELECT * from user_info WHERE (login_name,

phpMyAdmin don't show table size

Hello, after restoring from a mysqldump I use phpMyAdmin to view my database but the size field is unknown ... how could I get a size display ? -- Dilipan Sebastiampillai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Help to write a report

Hi all, I have the following select: select cons_nome as Consultorio, dent_nome as Dentista, pac_nome as Paciente, pac_convenio as Tipo, Pac_matricula as Matricula, concat(consulta_dia, /, consulta_mes, /, consulta_ano) as Data, concat(Consulta_hora, :, consulta_minuto) as Hora,

Milliseconds to date string

hi, I store in a column (varchar(20)) milliseconds. How can I format the value in a select statement to right timezone? Regards, Rafal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySQL 4.1.3-beta subqueries(correction on table names)

I don't know if your desire to use the subquery form is academic or performance driven. If I were having this much trouble getting a subquery to work, I would refactor my queries using JOIN statements. http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html (your query #1 below)This query

Help to write a report

Hi all again, I´m sending my question attached in a .txt file and maybe it will be a little bit easy to understand. Regards, Laercio Xisto Braga Cavalcanti Endless Technology Sistemas de Informação Rua Peixoto Gomide 321 Cerqueira César São Paulo SP CEP: 01409-001 Fone: +5511-3255-3430

Re: scalability of MySQL - future plans?

Jacek, - Original Message - From: Jacek Becla [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, November 12, 2004 2:30 AM Subject: scalability of MySQL - future plans? Hello, What are the plans regarding improving scalability of MySQL? We are currently trying to decide

ODBC connection

G'Day All, I am going nuts trying to setup ODBC to my MySQL database. Help Please. My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped it and am trying to configure it to connect to the database on a RedHat ES box. In the Add Data Source Name my DSN is closing Description

Re: phpMyAdmin don't show table size

Update phpMyAdmin. Santino At 12:33 + 12-11-2004, Dilipan Sebastiampillai wrote: Hello, after restoring from a mysqldump I use phpMyAdmin to view my database but the size field is unknown ... how could I get a size display ? -- Dilipan Sebastiampillai -- MySQL General Mailing List For list

Re: Moving innodb from Linux to Windows

Heikki Tuuri wrote: on Windows, InnoDB puts all database names and table names to lower case, because on Windows MySQL is case-insensitive. But Java running on Windows is not, which makes it painful to move apps back and forth. We may fix this in the future, so that on Windows InnoDB will also

Re: ODBC connection

The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That means it does not use the new (v4.1+) password hashing. http://dev.mysql.com/doc/mysql/en/Password_hashing.html http://dev.mysql.com/doc/mysql/en/Access_denied.html http://dev.mysql.com/doc/mysql/en/Old_client.html I would create

RE: ODBC connection

Thanks. I will give it a try. I also saw a reply from a J. Bullington but I cannot open it due to some underlying security stuff. Thanks though -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 11:05 AM

Re: ODBC connection

Hello. See: http://dev.mysql.com/doc/mysql/en/Access_denied_error.html G'Day All, I am going nuts trying to setup ODBC to my MySQL database. Help Please. My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped it and am trying to configure it to connect to the

Re: Milliseconds to date string

Hello. The first thing which comes to mind (I didn't dig really deep) looks like: select convert_tz(cast(from_unixtime(cast(t as binary)) as datetime),'+00:00', '-07:00') from tvar; mysql show create table tvar;

RE: ODBC connection

It is my Digital Signature. Sorry that it didn't come through. J.R. -Original Message- From: Ferguson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 11:19 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: ODBC connection Thanks. I will give it a try. I

Re: Milliseconds to date string

Hi, If I do this, I get You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(cast(from_unixtime(cast(s2u.value)) as datetime), '+00:00', '- select u.user_id, u.login_name,

Three Questions

I have three questions about mysql. 1. mysql CREATE TABLE board ( - boardid char(6) binary NOT NULL, - title varchar(128) binary NOT NULL, - ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 warning (0.00 sec) mysql desc board; +--+--+--+-+-+---+ |

Forcing repair with sort

I have a semi-large table (about 6GB, 27 million records) and an index called LNAME on three of the columns. I am trying to DROP the index to re-create, and it is taking over 2 hours (and still going). It has been the longest on 'Repair with keycache', which I have read is 1000x slower than

Searching for an equivalent to the Oracle POSITION parameter

Hi, I have a text file with fixed-width columns that I'd like to get loaded into a table. Against Oracle the script would be as follow: LOAD DATA INFILE 'myfile.data' append INTO TABLE MYTABLE ( FIELD1 POSITION(1:10), FIELD2 POSITION(11:20), FIELD3 POSITION(21:21), FIELD4 POSITION(22:40) ) Is

Re: Three Questions

litlpooh [EMAIL PROTECTED] wrote on 12/11/2004 07:46:02: I have three questions about mysql. 1. mysql CREATE TABLE board ( - boardid char(6) binary NOT NULL, - title varchar(128) binary NOT NULL, - ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 warning (0.00 sec) mysql desc

What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type. What's the easiest way in MYSQL to accomplish the same thing? I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean solution lept out at me. It is a GREAT book, but it did not help me in this case.

long update query does not replicate correctly

I'm executing on master a long and complicated query such: UPDATE (lots of tables, lots of LEFT JOIN) SET ... WHERE . The query updates i.e. 3816 rows. The query DOES replicate do master's and slave's binary log. But it DOES NOT execute on slave. 3816 rows are not updated on slave and slave

RE: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

From: sol beach [mailto:[EMAIL PROTECTED] In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type. What's the easiest way in MYSQL to accomplish the same thing? I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean solution lept out at me. It is a

MySQL Database Designer

Hi! I'm looking for a good graphical database designer, supporting the latest stable release of MySQL, MyISAM and InnoDB tables and foreign keys. So far there are a lot of products. But I need one, which runs on Windows and MacOS X. Do you have a good suggestion? Regards, Andreas -- MySQL

Re: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

Look at the DATE() fucntion you can find in the REF Manual of MySQL at URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Regards, Bernard On Friday 12 November 2004 12:14, sol beach wrote: In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data

Re: quote and null

At 18:08 -0600 11/10/04, Paul DuBois wrote: At 11:35 +1300 11/11/04, Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data

Re: Three Questions

1. All char's are automatically changed to varchar whenever there is any field that is not fixed length. This is not a bug or a problem, it's smart design. Fixed length records are great for performance since the database knows the offset of the next record. Once a record is not fixed length,

Re: 4.1.7 serious problems

Ugo Bellavance wrote: Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon MP. Are you using the

Re: Searching for an equivalent to the Oracle POSITION parameter

While reading http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html I found this passage If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty (''), a fixed-row (non-delimited) format is used. With fixed-row format, no delimiters are used between fields (but you can still have a

Re: long update query does not replicate correctly (cont.)

I'm executing on master a long and complicated query such: UPDATE (lots of tables, lots of LEFT JOIN) SET ... WHERE . Okey, I simplified the query to: - UPDATE tKsidata, tKsiabeksiazki SET tKsidata.STAN_REALNY=tKsiabeksiazki.STAN WHERE tKsidata.ksi='0815120877' and

Re: scalability of MySQL - future plans?

Adequate data warehouse performance requires more than just hardware. 2 crucial make-or-break software features are partitioning and parallel query. On very large tables - accessing a large slice of the data via index is completely unfeasible. Table scan is the only option. Partitioning allows

RE: ODBC connection

Thanks guys. I seem to have it working now. 'preciate it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 11:05 AM To: Ferguson, Michael Cc: [EMAIL PROTECTED] Subject: Re: ODBC connection

Re: MySQL Database Designer

Have you tried DBDesigner4 by fabForce? Andreas Ahlenstorf wrote: Hi! I'm looking for a good graphical database designer, supporting the latest stable release of MySQL, MyISAM and InnoDB tables and foreign keys. So far there are a lot of products. But I need one, which runs on Windows and MacOS

Re: MySQL Database Designer

Schalk Neethling wrote: Have you tried DBDesigner4 by fabForce? I'm working with it at the moment. As far as I see, it doesn't work on Mac and unfortunately DBDesigner manages to trash my foreign keys definitions from time to time. Regards, A. -- MySQL General Mailing List For list archives:

Report Designer

What do most people use for a report designer for linux? I need to design a report similar to a phone book directory, ie, multi-column with page breaks when the first letter of the field changes. Thanks, Ron. To really screw up Linux you have to work at it...To really screw up Windows,

Low-end SATA vs. SCSI

Hi List, I am putting in a separate disk for our MySQL (4.1.7) server. I have some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly atomic ones, insert/update one row), a few million rows per table, approx. 100-400 queries per second. What would you say is better (with respect

Re: Searching for an equivalent to the Oracle POSITION parameter

Shawn, Thanks a lot for this explanation. It works perfectly. Best, Adam [EMAIL PROTECTED] wrote: While reading http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html I found this passage If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty (''), a fixed-row (non-delimited) format

Re: Report Designer

Ron Thomas wrote: What do most people use for a report designer for linux? Perl. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1.7 serious problems

Sasha Pachev wrote: Ugo Bellavance wrote: Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon

Re: Low-end SATA vs. SCSI

For cost reasons I use SATA. Does the machine already have a SCSI card in it? If so I would use SCSI. If not I would give one of the newer 10k SATA drives a spin. Larry - Original Message - From: Fagyal Csongor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 12, 2004

Re: Low-end SATA vs. SCSI

If you are talking about the WD Raptor's -- stay away. Out of 6 we used, 3 failed. Do a few googles and you'll hear the same from other users. On the other hand, the do fly. Raid10 them them on a 3ware 9500 and you'll be amazed. On Fri, 12 Nov 2004 13:06:10 -0800, Larry Lowry [EMAIL PROTECTED]

Re: Low-end SATA vs. SCSI

Gary Richardson wrote: If you are talking about the WD Raptor's -- stay away. Out of 6 we used, 3 failed. Do a few googles and you'll hear the same from other users. On the other hand, the do fly. Raid10 them them on a 3ware 9500 and you'll be amazed. I agree on the 3Ware... Exceptionnal cards.

Re: Low-end SATA vs. SCSI

Sorry to hear that. Although I have been feeling that way lately about all WD drives. Seems like I have had to replace a lot of them lately. Even non SATA. Larry - Original Message - From: Gary Richardson [EMAIL PROTECTED] To: Larry Lowry [EMAIL PROTECTED] Cc: Fagyal Csongor [EMAIL

RE: Help with query performance anomaly

For production systems, I would never let the mysql optimizer guess a query plan when there are joins of big tables and you know exactly how it should behave. Once you think a query is finished, you should optimize it yourself. Use STRAIGHT_JOIN and USE INDEX as found here in the manual:

RE: Low-end SATA vs. SCSI

Which SATA drive works under LINUX O/S? Kirti -Original Message- From: Larry Lowry [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 4:06 PM To: Fagyal Csongor; [EMAIL PROTECTED] Subject: Re: Low-end SATA vs. SCSI For cost reasons I use SATA. Does the machine already have a

Re: 4.1.7 serious problems

I did compile it from source, with the flags used for the binaries, and now it does work. I'm totally confused now. Is it easy to upgrade from source? With the binary, I could have two separate directories and I would symlink the one I tested (most recent version) and could get back to the

Searching a table and replacing all instances of a string with another

Hi All, I would like to search through all fields in a table, and anytime a search string comes up, have it replace it with another string. By way of example, let's say I wanted to replace every occurence of 'Peter' with 'Paul' - can I do this purely with SQL? I know I could do it in PHP

Help!!! The error message SELECT in a stored procedure must have INTO

Hi everyone, This is my first project in MySql database. I use VB.Net and OleDb to connect to MySql(5.0.1 alpha-max). When I call the stored produce, I get the error message: ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-max]You have an error in your SQL syntax. Check

Re: long update query does not replicate correctly (cont.)

Przemyslaw Popielarski wrote: I'm executing on master a long and complicated query such: UPDATE (lots of tables, lots of LEFT JOIN) SET ... WHERE . Okey, I simplified the query to: - UPDATE tKsidata, tKsiabeksiazki SET tKsidata.STAN_REALNY=tKsiabeksiazki.STAN WHERE

Re: 4.1.7 serious problems

Sasha Pachev wrote: I did compile it from source, with the flags used for the binaries, and now it does work. I'm totally confused now. Is it easy to upgrade from source? With the binary, I could have two separate directories and I would symlink the one I tested (most recent version) and

Problem with an insert query

In my database I have the following tables: +-+ | Tables_in_AHRC | +-+ | Attendance | | Participants| | ProgressNotes | | Sessions| | Staff | | StaffAttendance | +-+ I am trying to insert data in the ProgressNotes Table

Re: Searching a table and replacing all instances of a string with another

On Fri, 12 Nov 2004 22:12:29 -0500, Joshua Beall [EMAIL PROTECTED] wrote: Hi All, I would like to search through all fields in a table, and anytime a search string comes up, have it replace it with another string. By way of example, let's say I wanted to replace every occurence of 'Peter'