Re: misconfigured mysql ?

vc wrote: the mysql still reports 5.0.22 as the attched pic . maybe phpmyadmin is not smart enough to detect the correcrt version ? I guess it's possible but I'd either dig into the code or ask the phpmyadmin guys to find out for sure. -- MySQL General Mailing List For list archives: http:

Re: misconfigured mysql ?

the mysql still reports 5.0.22 as the attched pic . maybe phpmyadmin is not smart enough to detect the correcrt version ? - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "vc" <[EMAIL PROTECTED]> Cc: Sent: Thursday, November 22, 2007 6:49 AM Subject: Re: misconfigured mysql

Re: misconfigured mysql ?

I installed mysql server 5.0.22 from source . Also I ran "rpm -qa | grep -i mysql" , but no output . as the above I 've already checked to make sure i did not install any mysql rpm package in my system . maybe i wiill reinstall these stuff later :-(( So that all looks good. Basically php

Determining Table Storage Engine Type on Crashed Table

Hey everybody, Hopefully some of you are already enjoying time off. I am not...yet :) Anyway, is there a way to determine what storage engine a table is using if it's crashed? When it's fine, I can just run: mysql> show table status like 'table_name'; +-++-+-

Re: Why is Delete slow on a Merge Table?

At 12:20 PM 11/21/2007, you wrote: mos wrote: Jerry, Does TRUNCATE work on a merge table? Apparently not. I tried: "truncate table mymergetable" and got: Error Code : 1 Can't create/write to file '.\dbname\mymergetable.MRG' (Errcode: 17) I even tried a Flush Tables before the truncate and tha

Re: Why is Delete slow on a Merge Table?

At 08:50 AM 11/21/2007, Rolando Edwards \(DBA\) wrote: Further reason DELETE FROM on a Merge Table is so inefficient is this: DELETE FROM tbl without a WHERE clause on a MyISAM Table is mapped internally to TRUNCATE TABLE, which would be instatntaneous DELETE FROM tbl WHERE 1=1 would clearly

RE: Why is Delete slow on a Merge Table?

Jerry, Does TRUNCATE work on a merge table? Apparently not. I tried: "truncate table mymergetable" and got: Error Code : 1 Can't create/write to file '.\dbname\mymergetable.MRG' (Errcode: 17) I even tried a Flush Tables before the truncate and that didn't help. So it looks like I'll have to

Re: Why is Delete slow on a Merge Table?

Further reason DELETE FROM on a Merge Table is so inefficient is this: DELETE FROM tbl without a WHERE clause on a MyISAM Table is mapped internally to TRUNCATE TABLE, which would be instatntaneous DELETE FROM tbl WHERE 1=1 would clearly make even a MyISAM table terribly ineffeicient as it mus

master/slave replication - errors!!

hi.. doing a simple test of master/slave replication, using mysql. i have two test systems: master - foo (192.168.10.13) slave - cat (192.168.20.20) on both machines, i created a testmasterdb. on the master, i populated the tbl within the db with some test data. there are no tbls in the sla

Re: German collation for UTF8 missing

Hello, If I recall that correctly, utf8_swedish_ci is the collation to use for european/western european languages. Those Swedish people think they can stand for whole Europe... ;) Not tested my reply, though. and doesn't work either. This is the sorting result with utf8_swedish_ci: ++-

Re: German collation for UTF8 missing

Hello, default-character-set=latin1_d e that's not UTF8. Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mycnf components for myisam storage engine

Hi All, I am configuring mysql on a system for keeping only data of myisam storage engine type. So what component of my.cnf should i increase to get a good performance. Is it key_buffer or some more components are there. If yes then Please, let me know Thanks -- Krishna Chandra Prajapati MySQL

Re: misconfigured mysql ?

really? MySql server 5.0.22 released on 2006 , PhpMyAdmin 2.11.2.1 relesed this month . I don't think things will go this ironic ... - Original Message - From: "Sebastian Mendel" <[EMAIL PROTECTED]> To: "vc" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, November 21, 2007 8:46 PM Subject: Re:

Re: misconfigured mysql ?

- Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "vc" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, November 21, 2007 10:58 AM Subject: Re: misconfigured mysql ? > vc wrote: > > Thanks Ananda , > > > > I tried , i tried to uninstall the maybe-preinstalled mysql, but rpm tells me t

Re: misconfigured mysql ?

vc schrieb: > i install mysql 5.0.22 with php 5.2 on my redhat 9 installation. > after i first lunch phpmyadmin , it says > > "Your PHP MySQL library version 5.0.22 differs from your MySQL server version > 3.23.32." phpMyAdmin cannot detect the correct version of your MySQL server - so it assu