sorting doesn't work correctly with UTF-8 data

Hi, I have mysql-4.0.18 installed and entered data with UTF-8 characters. When I use a Select command, mysql doesn't sort the data correctly which starts with native Turkish letters. Is there a way to fix it? Thanks.. -- Erol YILDIZ HEV Schools Kemerkoy http://www.kemerkoy.k12.tr -- MySQL Gene

Re: big table corruption

Random hardware failures will NOT only impact a single file. The only thing that I know that will consistantly fail at the same spot is s/w. On Mon, 03 Jan 2005 16:32:31 -0800, Mark Maggelet <[EMAIL PROTECTED]> wrote: > Thanks Mike, > It's hardware raid, but I don't know the manufacturer. I could

Re: big table corruption

Thanks Mike, It's hardware raid, but I don't know the manufacturer. I could try to find out but if the problem is the hardware there isn't much I can do about it anyway without turning it into a big project. I'm not really expecting to solve this, I'm just hoping for some advice on what the pro

RE: What is the difference between 4.1 and MAXDB 7.5?

Hi Kevin, Lucky its not IBM, they have Cloudscape, DB2, Informix, Unidata, Universe, Redbrick and a few others that I can't remember. Did you say only 2? 8-) Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417

Re: What is the difference between 4.1 and MAXDB 7.5?

Logan, David (SST - Adelaide) wrote: Hi Juan, MAXDB is a totally different product, more akin to the "corporate" databases like Oracle, Informix, Sybase etc. A description from the mysql web site ( www.mysql.com ) MaxDB(tm) by MySQL For the most demanding enterprise applications, MySQL offers MaxDB

RE: first time accessing

Hi Gerald, Check your syntax, I can't see the hostname or database name in your connect statement. I have a statement similar to that below. Note the hostname and database. my %err_handle = ( PrintError => 1, RaiseError => 1 ); $dsn = "DBI:mysql:host=$ho

RE: first time accessing

Try something like this: use DBI; my $driver = "mysql"; my $server = "myhost"; my $database = "mydb"; my $url = "DBI:$driver:$database:$server"; my $user = "username"; my $pass = "password"; my $dbh = DBI->connect($url, $user, $pass) || die "Couldn't connect

first time accessing

I am making my first attempt to access MySQL with Perl #!/perl use warnings; use strict; use dbi; my $dbh=DBI->connect( 'dbi:MySQL, 'user', 'pass' ) or die "Cannot connect -> !$DBI::errstr"; and I get the following error: Can't connect to data source dbi:MySQL, no data driver

RE: What is the difference between 4.1 and MAXDB 7.5?

Hi Juan, MAXDB is a totally different product, more akin to the "corporate" databases like Oracle, Informix, Sybase etc. A description from the mysql web site ( www.mysql.com ) MaxDB(tm) by MySQL For the most demanding enterprise applications, MySQL offers MaxDB by MySQL. Formerly known as SAP D

What is the difference between 4.1 and MAXDB 7.5?

Could some one enlighten me about the differences between these 2 mysql products? Thanks Juan M. Quiroz Oregon Department of Agriculture Systems Analyst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Max connections being used every 10-12 day.

I really appreciate your help :) I did some cleanup of my indexes(there are a couple of them left to clean out but it takes so long time): mysql> show index from art; +++--

max_rows with largetext field

Hi there, I create a large table with the following command CREATE TABLE MyTable( ID int unsigned not null, Description longtext, index(ID), foreign key (ID) references MainTable (ID) on delete cascade ); alter table MyTable max_rows = 200; Then if I do

Re: MySQL 4.1.7 allows non-unique values in a unique index?!

Jocelyn Fournier wrote: Hi, This could also be a badly corrupted table, what does CHECK TABLE / REPAIR TABLE report ? Thats next on our list... going to take care of that tonight. Kevin -- Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #

Re: big table corruption

At 12:37 PM 1/3/2005, you wrote: Hi, I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index on it. The table gets corrupted every 1 week or so and I have to repair it. I've tried upgrading to newer versions of mysql 3 times but the problem persists. I think it may have somethin

Re: MySQL 4.1.7 allows non-unique values in a unique index?!

Hi, This could also be a badly corrupted table, what does CHECK TABLE / REPAIR TABLE report ? Regards, Jocelyn - Original Message - From: "Kevin A. Burton" <[EMAIL PROTECTED]> To: Sent: Monday, January 03, 2005 10:04 PM Subject: MySQL 4.1.7 allows non-unique values in a unique index?

Re: MySQL 4.1.7 allows non-unique values in a unique index?!

Kevin A. Burton wrote: WOW! This is a really bad bug... So now only that... but check this out: mysql> SELECT * FROM LITERAL WHERE VALUE = 'Law'; +--+---+ | ID | VALUE | +--+---+ | 14076840 | Law | +--+---+ 1 row in set (0.00 sec) Which only returns ONE r

MySQL 4.1.7 allows non-unique values in a unique index?!

WOW! This is a really bad bug... mysql> SHOW INDEX FROM LITERAL; +-++--+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | S

RE: Max connections being used every 10-12 day.

There are some unnecessary indexes though. These include id_2 and 1st. This is because id_3 is an index on (id,parent,date) and id_2 is and index on (id,parent). The way mysql uses indexes, id_3 will work for (id), (id,parent), and (id,parent,date). The same is true of the '1st' index. This is cove

RE: Max connections being used every 10-12 day.

[snip] I may be losing my mind, but I don't think I am according to your show index, you have multiple indexes on the same fields which is absolutely worthless and actually makes things slower. For example, id, which you have as primary should not have any other indexes on it, but with the explain

Re: big table corruption

Thanks Heikki, check table gives me this: mysql> check table resourcesback; ++---+--++ | Table | Op| Msg_type | Msg_text | ++---+--+

RE: Max connections being used every 10-12 day.

Frederik, I may be losing my mind, but I don't think I am according to your show index, you have multiple indexes on the same fields which is absolutely worthless and actually makes things slower. For example, id, which you have as primary should not have any other indexes on it, but with the expl

Re: Connecting MySQL to OpenOffice

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jay Scherrer wrote: > I am having areal time trying to get my Open Office to recognize my > MySQL server. I am using the j-connector : > "Generally Available (GA) 3.0.6" > I have this installed in my path $HOME/java. > I have notified the tools->Opti

Connecting MySQL to OpenOffice

I am having areal time trying to get my Open Office to recognize my MySQL server. I am using the j-connector : "Generally Available (GA) 3.0.6" I have this installed in my path $HOME/java. I have notified the tools->Options->Security->ClassPath. but I still keep getting an error: "A driver is not

Re: big table corruption

Mark, - Original Message - From: "Mark Maggelet" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, January 03, 2005 8:36 PM Subject: big table corruption Hi, I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index on it. The table gets corrupted every

Re: doing SELECTS and keeping the array intact with php

julian haffegee schrieb: Hi all, this has been bugging me for some time now. I want to do a mysql select then using php while ($a_row = mysql_fetch_array($result)) { do something to get a small portion of the data } hi julian, how about using this snip $result = mysql_query($sql)or die("fehler:"

Re: doing SELECTS and keeping the array intact with php

mysql_field_seek( resultset, 0 ); PB - julian haffegee wrote: Hi all, this has been bugging me for some time now. I want to do a mysql select then using php while ($a_row = mysql_fetch_array($result)) { do something to get a small portion of the data } and that works fine. Then later I need to

RE: doing SELECTS and keeping the array intact with php

http://us2.php.net/manual/en/function.mysql-data-seek.php This lets you set the internal row pointer of the mysql result. In your case you would want mysql_data_seek($result,0). --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: julian haffegee Se

Re: InnoDB: Error: tablespace size stored in header is 17024 pages, but

Ian, are you sure that you copied the complete ibdata1 file to the new place? It is strange how 7 MB can be missing from the file end. What does the old .err log contain? Any message about disk space running out? The error below probably has not corrupted your tablespace. Best to run CHECK TAB

Question about indexing a highly searched table

Hi all , I have a question about how to best approach indexing a table with many variations of fields searched by, but one common ORDER BY field. Take for example this table (with only relevant searched fields shown): CREAT TABLE Offers ( bid` mediumtext NOT NULL, `company_name` varchar(50

RE: doing SELECTS and keeping the array intact with php

[snip] this has been bugging me for some time now. I want to do a mysql select then using php while ($a_row = mysql_fetch_array($result)) { do something to get a small portion of the data } and that works fine. Then later I need to access $result as a complete array again. Is there a way I c

big table corruption

Hi, I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index on it. The table gets corrupted every 1 week or so and I have to repair it. I've tried upgrading to newer versions of mysql 3 times but the problem persists. I think it may have something to do with the raid 1 mirror b

Re: List for newbie

At 3:56 PM +0100 1/3/05, Paun wrote: I am very new in mysql, and don't want to disturb users who have much more expirience with mysql. Is there any mysql list for newbies?? No, this is the appropriate list...just make sure you: (1) first try to search the manual: http://dev.mysql.com/doc/

doing SELECTS and keeping the array intact with php

Hi all, this has been bugging me for some time now. I want to do a mysql select then using php while ($a_row = mysql_fetch_array($result)) { do something to get a small portion of the data } and that works fine. Then later I need to access $result as a complete array again. Is there a way I can k

RE: backup/restore

Hi, use the below command to take backup mysqldump --add-drop-table > i tested it on my local server also it is working fine for me. other wise just open the dump file by executing the below command on linux: head -100 o/p: -- MySQL dump 8.22 -- -- Host: localhostDatabase: NOCIN

RE: changing data dir

[snip] Do I have to reinstall mysql in order to change the default data dir from /var/lib/mysql? Can I do this: mv /var/lib/mysql /newdir/mysql cd /var/lib ln -s /newdir/mysql mysql [/snip] This should work. You could also change the datadir variable in your my.cnf file instead of creating the

RE: backup/restore

Drop the tables manually then try the restore. [snip] ERROR 1051 at line 11: Unknown table 'alarm' ERROR 1050 at line 12: Table 'alarm' already exists [/snip] It seems strange that you get these errors in this order. If you post maybe the first 15 lines of your dump file, I may be able to provide

AW: AW: [PHP] How to argue with ASP people...

Ahhh, you guys are sooo funny - you all know what I mean > -Ursprüngliche Nachricht- > Von: Jay Blanchard [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 3. Januar 2005 14:36 > An: Freddie Sorensen; [EMAIL PROTECTED] > Cc: mail.pmpa; mysql@lists.mysql.com > Betreff: RE: AW: [PHP] How to ar

Re: Max connections being used every 10-12 day.

mysql> describe art; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | parent

changing data dir

Do I have to reinstall mysql in order to change the default data dir from /var/lib/mysql? Can I do this: mv /var/lib/mysql /newdir/mysql cd /var/lib ln -s /newdir/mysql mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

RE: backup/restore

Hi, Thank you for your reply. Even though I used the --add-drop-table option, I am getting the error messages. Actually I am taking the backup for a group of tables as following D:\Code\OPS\6.9.1.12\NetMgmt\OPS_src\C_src\backupmnms\Debug>mysqldump -uMNMSDBA -p MNMSDBA --databases mnms --ad

RE: is there a utility like mysqlbinlog but instead processes the query log?

The program would also need to handle... ...queries that span multiple lines ...change databases when appropriate before queries yes I could program such a beast but I thought someone else might have already done it. daniel -Original Message- From: Andy Davidson [mailto:[EMAIL PROTECT

RE: installing mysql / error

This error is caused when the server isn't started. Make sure that you start the server first, then log in. When you skip the HOSTS.FRM tables (by doing mysqld --skip-grant-tables), you have to restart the server normally to effect your changes in the mysql root user. J.R. -Original Message

Re: installing mysql / error

I did the first 2 step you listed below, but when I typed in the mysql -u root, I got a new error message ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061) Thanks David. - Original Message - From: "Tom Crimmins" <[EMAIL PROTECTED]> To: "David Katz" <[EMAIL PROTECTE

RE: List for newbie

smime.p7m Description: S/MIME encrypted message

Re: BIG InnoDB problems!

Joshua, the problem you had was serious corruption in the ibdata files. It can be caused by an InnoDB bug, an OS bug, faulty hardware, and also by an error of the database administrator. Linux kernels 2.4.18 seemed to have corruption issues. There are no known corruption bugs of this type in Inn

List for newbie

I am very new in mysql, and don't want to disturb users who have much more expirience with mysql. Is there any mysql list for newbies?? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.6 - Release Date: 12/28/2004 -- MySQL Genera

Re: BIG InnoDB problems!

well, since we were having so many problems with the InnoDB tables, we created a non-InnoDB version of the database in question... Basically we want to do whatever it will take to get InnoDB tables working in our environment. Any assistance you can offer towards this goal will be greatly apprecia

Re: BIG InnoDB problems!

Joshua, about dumping tables from a corrupt database, see: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html This describes how to remove the whole InnoDB database: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html Be very careful. You do not want to lose your valuable data. Regard

Re: BIG InnoDB problems!

Hi Heikki, Please see below... On Mon, 3 Jan 2005 15:14:12 +0200, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Joshua, > > the stack trace below shows that you are trying to drop a database? Why? At that point, I'd heard from our developer of so many problems I figured what I would do is test thi

RE: User can't login to his DB.

Hi, after granting privileges did you executed flush privileges command. if not execute below command and then check mysql> flush privileges; thanks Anil -Original Message- From: sam [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 9:09 AM To: mysql@lists.mysql.com Subject: U

RE: backup/restore

Hi, with which options of mysqldump you have taken backup. if you use --add-drop-table option then it will add drop table statement in dump file. otherwise it wont add that statement and you will get that type of errors. if you didn't use that option then drop the schema and then try to restore i

RE: Multi table update

[snip] I read 6) as saying that until you complete all of the calculations on a row, you don't change the data for the row. I could even interpret this as saying that you don't update ANY row on the table until you have completed the calculations for ALL of the rows. I read 7) as saying that you

RE: AW: [PHP] How to argue with ASP people...

[snip] It is worth it for performance reasons ! [/snip] Really? What performance stats are you looking at here? [snip] And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend [/snip] Yes, he is adequately informed...and correct. -- MySQL General Ma

RE: Reccommend host w/recent MYQL version

[snip] Having a hard time finding a server/host who supports MYSQL 4.1.3 or above. Does anyone know and can recommend a host who offers this? [/snip] http://www.phpwebhosting.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Re: BIG InnoDB problems!

Joshua, the stack trace below shows that you are trying to drop a database? Why? If you can, you should use SELECT ... INTO OUTFILE to save of your tables what you can save, then rebuild the whole InnoDB tablespace, and import the tables back to MySQL. The .err file below starts from a situation

Stability of mysql-5.0.2-alpha-win

Hi, one more problem. The database-version above crashes, whenever I try to work with it. Work means, that I like to look at a table via php-myadmin. In this moment, the database crashes. I know that alpha is with bugs, 5.0.0 runs stable so far, but does not support views... Thanks for jus

Complex joining - multiple tables to one

Hi there! I have some problems with the complex MySQL join operations. In most cases, LEFT JOIN fulfills my needs but sometimes it doesn't work in the expected way. I'll give an example: orders -- - orderid - customerid customers - - id - customername orderitems -- - itemid -

Re: backup/restore

Ligaya Turmelle wrote: I'm a beginner - but can't you also use mysqlimport? Not in the case when you have made a backup using mysqldump while using the default options. mysqlimport is a front end for LOAD DATA INFILE (http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html) It is usefule when you hav

Re: backup/restore

[EMAIL PROTECTED] wrote: Hi, Thank you for your reply. If I have the create table info in my dump file, while doing the restore using mysql dbname < dump.dmp, I am getting errors like mysql -uMNMSDBA -pMNMSDBA -f mnms < c:\progra~1\mitel\opsman~1\temp\almhist.dmp ERROR 1050 at line 11: Tabl