Mysql Data files

Hi, On PC, I see *.frm files for each table while I see 3 files on Unix/Linux (*.MYD,*,MYI,*.frm). Need to know what these files are. I created a table on PC Mysql with type set to InnoDB which also created *.frm file. Any ideas ? __ Do You Yahoo!

Is it the time to upgrade my server?

Dear all, Following is a statistical result for my MySQL usage. Connections per hour are 16832, however 3767 attempts are failed (22.4%) and 94 attempts are aborted. Queries per second are 91. The most important applications of the server are httpd, php and mysql. Is my MySQL overloaded? Should I

Import of Text data

I have a number of very large text files I need to import. The first line of each file contains the field names. Is there a way to automatically create the associated tables based on the filed names in the first line of the text file, then import the data using LOAD DATA INFILE? Thanks Jeff S

Synchronizing InnoDB tables

Hi, I want to use InnoDB tables in my project, because I can use transactions with them. I would write a hotel room's reservation system and sometimes I would need to get from particular SELECT query exact state - whether room is reserved or not. Because, when I'm using innodb I work only on co

mysql<->mysqld connection

Where could I find speciffication of how MySQL client and server communicate? It seems to me there are two ways of communicating - over UNIX socket and over TCP/IP connection. Lets say I want to write my own MySQL client, where could I find info about what UNIX socket is, and how do TCP packets

Re: mysql<->mysqld connection

Look at the source code of libmysql? - Original Message - From: "Nikola Skoric" <[EMAIL PROTECTED]> To: Sent: Sunday, May 01, 2005 10:25 AM Subject: mysql<->mysqld connection Where could I find speciffication of how MySQL client and server communicate? It seems to me there are two ways

RE: Need help w/ re-starting Replication

No, I don't see sny errors when running SHOW SLAVE STATUS. How should I found out if the slave dropped and created the tables again? Basically, if everything works fine, do I need to do anything in such a case (cleaning master log file, resetting the log position, etc?) Thanks, -Jalil > -

Resultset.getBinaryStream memory

Hi, I have to read a lot of BLOBs from the database. Does Resultset.getBinaryStream store the blob into memory? Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

C API: Storing is easy; How do you retrieve?

Hey guys, (Why is there no C API specific list?) I want to write a C application that can take some audio file, store it in MySQL, then at a later date/time (upon request) pull from db and write to temporary file to be streamed. I've got the storing portion of the code down. The problem I have i

Re: why NOT NULL in PRIMARY key??

> > create table a ( > >b int not null, > >c int null > >primary_key(b,c) > > ); > > > > With values: > > 1 null > > 1 null > > > > Logically these are unique records under the standard proviso that > > null != null. Yet how could I uniquely identify the first row to delete > > that ro

Can I use LIKE this way?

  { $dead_beat_ads = "Delete from fsearch_temp where fsearchKeyword='$str' and fsearchTime='$time' and fsearchIp='$fbip' and fsearchHost LIKE '%$dbad%' ";  $dead_beat_result = $dbi->query($dead_beat_ads);  }   What I am doing is eliminate "Run of site" advertisers from our netwo

Unique keys and dates

Hi there i am going to be attempting an insert on duplicate key update. I am collecting stats log data and inserting the records into the database however i am using a unique compound key on a special id and the date the stats were generated. I want the database to insert a new record when the

Re: Can I use LIKE this way?

I think you want the wildcard characters, % and _, to be within the variable, not within the variable name. For example, if you are looking for all advertisers whose name begins with 'A' followed by zero or more unknown characters, you would set your variable equal to this pattern [I don't k

RE: Can I use LIKE this way?

Yeah, the problem is we are trying to do something that is not done by any of the other search engines. I am working on a "Quick Clean" to clean out Search spammers on the fly. We have Upstream partners (Like Overture) who like to "Fill" us with their "Run of Site" ads when even they don't have p

mysqldump appears to generate invalid code.

I created a mysqldump with --quote-names option, but I get this error:C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test5.txtERROR 1005 at line 54: Can't create table '.\db2\shift.frm' (errno: 150)C:\xampp\xampp\mysql\bin>Line 54 is the CREATE TABLE... line of the following bit of SQL from the fi

Collation latin1_general_cs

Hi List, I was checking the list of collations for a character set "latin" that I have in my MySQL version 4.1.10-standard running on Mac OS X 10.4. The list that I have, bellow, does not include "latin1_general_cs". What will happen if I force to use it when I create a database, tables and field

Re: C API: Storing is easy; How do you retrieve?

The docs should have it. Basically these API is what you require (in order): mysql_init(); mysql_real_connect(); mysql_real_query(); mysql_store_result() or mysql_use_result(); mysql_fetch_row(); mysql_free_result; mysql_close (); HTH --- Matthew Boehm <[EMAIL PROTECTED]> wrote: > Hey guys, >

ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Hi All, I did this below, mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MyS

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authentication protocol r

RE: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Sounds like the MySQL 4.x Password hashing. Use this : sET PASSWORD FOR 'root'@'localhost' = old_PASSWORD('whatafraka');\ Sheck out the 4.x doc about Pasword hashing for more //jjs www.intechgra.com -Original Message- From: Simon Garner [mailto:[EMAIL PROTECTED] Sent: Sun 5/1/2005 10:37

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client does not support authe

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

On 2/05/2005 6:05 p.m., Mark Sargent wrote: Hi All, master/client are the same machine. I installed via tar.gz, ver 4.1 following this page http://dev.mysql.com/doc/mysql/en/installing-binary.html for installation on FC3. Why would it say that the client doesn't support it.? Cheers. P.S. I now

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mark Sargent wrote: Simon Garner wrote: On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka'); and then tried logging on, [EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka ERROR 1251: Client do