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
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 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
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
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
Look at the source code of libmysql?
- Original Message -
From: Nikola Skoric [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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]
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
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 row?
First of all NULL is
{
$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 network LIKE EBAY.com I
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
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
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
paid
I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test5.txtERROR 1005 at
line 54: Can't create table '.\db2\shift.frm' (errno:
150)C:\xampp\xampp\mysql\bingt;Line 54 is the CREATE TABLE... line of the
following bit of SQL from
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
fields?
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,
Hi All,
I did this below,
mysqlSET 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
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET 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
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
20 matches
Mail list logo