On Monday, June 07, 2004 19:09, Michael Stassen wrote;
This doesn't quite make sense. You seem to say that several rows
will match
but then you say only one will. It must be one or the other.
Perhaps I've
misunderstood you.
Firstly, Micheal thank you for your assistance; I'll elaborate.
Hi
I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master where I have
attached a slave to for replication. The problem now is that on the master there is a
LOT of mysql-bin.XXX files, and they each take 1GB diskplace.
Are these files needed still, or can i delete the old ones?
Hi,
I need some help please! I have 60GB of proxy logs to parse and load into
a mysql database. I've written a parsing script but I'm stuck now on how
to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id size
and
URL_TABLE
url_id url
On Wed, 9 Jun 2004 21:58:39 -0500, Donny Simonton [EMAIL PROTECTED]
wrote:
Russ,
We use #2 currently, and we are actually about to switch back to the
inserting them one at a time. The reason is very simple. In our case we
have a insert statement that will insert a maximum of 600 entries at a
Hi,
I would like to know what does the 'AB' in MySQL AB stand for?
Is it something like limited or incorporated?
If yes, is this something related to the origin of MySQL?
I am a subscriber from Hong Kong.
Thanks.
mc.
--
MySQL General Mailing List
For list archives:
Hi,
yes it is something like limited or incorporated,
it stands for Aktiebolag, which is a swedish word meaning
literally Sharecompany. It is related to the fact, I suppose,
that MySQL is Swedish/Finnish in origin.
/Johan
mc wrote:
Hi,
I would like to know what does the 'AB' in MySQL AB
Hello MC,
The following is extracted from URL:
http://dev.mysql.com/doc/mysql/en/What_is_MySQL_AB.html
which answers your questions.
By the way, the ``AB'' part of the company name is the acronym for the Swedish
``aktiebolag,'' or ``stock company.'' It translates to ``MySQL, Inc.'' In
fact,
oh sorry i have never noticed this section :)
great thanks to Bernard and Johan!!
- Original Message -
From: Bernard Clement [EMAIL PROTECTED]
To: mc [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 17:26
Subject: Re: (might be off list) MySQL AB
Hello MC,
The
select month(booking_date) bookings_month, count(bookings) as bookings
GROUP BY month(booking_date)
Peter
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: 10 June 2004 11:12
To: [EMAIL PROTECTED]
Subject: A query that groups information by month
Hi,
I have a TBL of users and I have created a search screen where you can
type in
first or last name and it will retrieve the appropriate records. Here is
the statement:
Select * from STUDENTS WHERE FName LIKE '% .$_REQUEST['searchit']. %'
OR LName LIKE '% . $_REQUEST['searchit']. %' OR
Hello I am using PHP, mysql. How would I query mysql to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to The last date the stats table was modified). Thanks for your help,
If your table contains a timestamp field, it will update each time the row
is altered. Otherwise I don't think it's possible.
You Wrote -
Hello I am using PHP, MySQL. How would I query MySQL to display the last
time a table was last modified/changed/or updated. For example I have a user
I see the type timestamp. Should I leave value, attributes...blank. Do I
just query this field and format as need via DATE()?
Thanks for the heads up.
Take care.
-Original Message-
From: Paul McNeil [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 7:20 AM
To: MySQL General
Daniel Venturini [EMAIL PROTECTED] wrote:
Hello I am using PHP, mysql. How would I query mysql to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to The last date the
Greg Macek [EMAIL PROTECTED] wrote:
I was wondering what happens when you change table types. Does MySQL
automatically get rid of the old table files?
Yes, MyISAM files are deleted. As for converting InnoDB - MyISAM, then
of course, InnoDB tablespace is not deleted, but freed.
--
For
Peter [EMAIL PROTECTED] wrote:
Does anybody have experience with FreeBSD 5.x
Mysql ?
FreeBSD 4.x and mysql seems to be awful combination due to threading , =
but I have no tried FreeBSD 5.x with mysql under heavy load
MySQL under FreeBSD 5.x works way much better than under FreeBSD
Dan Brown [EMAIL PROTECTED] wrote:
Will the number of databases being handled by MySQL affect it's speed
regardless of the actual load being put on MySQL or should I look farther
into OS issues which could be causing system hangups and slowdowns?
Yes, investigate the OS.
The age
of the
Chambon [EMAIL PROTECTED] wrote:
Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ?
Yes. _size is deprecated.
Perhaps it is just a question of syntax, I mean, in the my.cnf
you write key_buffer=100M
or you write set-variable = key_buffer_size=100M
Michael Arndt [EMAIL PROTECTED] wrote:
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
[EMAIL PROTECTED] egor]$ perror 144
Error code 144: Unknown error 144
144 = Table is crashed and last repair failed
So, running
Don Dachner [EMAIL PROTECTED] wrote:
How do I turn on the General log file in version 3.23.52? Can I put an entry in the
my.cnf file and reboot?
Yes, put the log entry in my.cnf and restart MySQL.
If you are running Red Hat Linux, restart MySQL by running
service mysql restart
In
Mark Goldfarb [EMAIL PROTECTED] wrote:
Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
server. I am using Veritas BackupExec. I currently manually copy the
files before a backup or manually unload the MySQL server. I would like
to automate the backup. What is the best
Mind you --
If your table contains a timestamp field, it will update each time the row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
If all you're looking to do is check the last time the entire table
was updated, why don't you just look at the last time the .frm file
(if using MyISAM tables, of course) was modified?
Thursday, June 10, 2004, 7:19:32 AM, you wrote:
PM If your table contains a timestamp field, it will
---I see the type timestamp. Should I leave value, attributes...blank. Do
I
just query this field and format as need via DATE()?
---
Yes. This field is a date actually. It will update each time the record is
modified or when a record is created. You can query it as a normal datetime
field.
yes mr egor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 10 Jun 2004 at 7:02, Daniel Venturini wrote:
Hello I am using PHP, mysql. How would I query mysql to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to The last date
SQL
MySQL under FreeBSD 5.x works way much better than under FreeBSD 4.x but still
not at production level.
In my experience it works fine on a single CPU box and with relatively small tables.
If the tables grow really big (tens of Gigs) and/or in SMP mode (including HT), then
FreeBSD's
Martijn Tonies [EMAIL PROTECTED] wrote on 10/06/2004 12:33:38:
Mind you --
If your table contains a timestamp field, it will update each time the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every row, you can
Mind you --
If your table contains a timestamp field, it will update each time the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every row, you can MAX() it to get the latest row update,
which is the latest
I saw the script. I am actually fine running a shutdown on the server
prior to each backup. Veritas BackupExec supports running commands
prior and after each backup. The problem I am having is if I run the
mysqladmin --shutdown command, it generates a message saying NLM has
been shutdown, press
Martijn Tonies [EMAIL PROTECTED] wrote on 10/06/2004 13:02:25:
Mind you --
If your table contains a timestamp field, it will update each time
the
row
is altered. Otherwise I don't think it's possible.
That's on a per ROW basis, not TABLE basis.
But if it is on every
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly for me.
Check http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html for details.
--
Dobromir Velev
[EMAIL PROTECTED]
On Thu, 10 Jun 2004 15:55:31 +0300
Dobromir Velev [EMAIL PROTECTED] wrote:
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly
for me.
Would you be willing to share
Mos forgot to populate the url_id column in your user table. I would use
his same process but re-arrange it like this:
1) create table BIG_TABLE
2) load data infile
3) create table URL_TABLE (
url_id bigint not null auto_increment,
url varchar(25) not null primary key,
Thanks - but did not work...here is the information you
requested. In looking at this please remember that, for
example, there are lots of smith records in the data, but
only one with the first name allenand there are lots of
sarah records in the data but only one with the last name
Mark Goldfarb [EMAIL PROTECTED] wrote:
I saw the script. I am actually fine running a shutdown on the server
prior to each backup. Veritas BackupExec supports running commands
prior and after each backup. The problem I am having is if I run the
mysqladmin --shutdown command, it generates a
On Thursday 10 June 2004 15:09, Egor Egorov might have typed:
Mark Goldfarb [EMAIL PROTECTED] wrote:
I saw the script. I am actually fine running a shutdown on the server
prior to each backup. Veritas BackupExec supports running commands
prior and after each backup. The problem I am
Is there the possibility of making the apostrophe char ( ' ) a stopword in
mysql?
Full text search queries in italian or other European language are greatly
affected by that; for example searching amore will not return dell'amore
as a match
Any workaround suggested?
Andrea Gangini [EMAIL
Hello,
We had a situation over night where users were getting the error message:
[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI:
[error : 145]
I found that .MYI file had become corrupted and I repaired the table and
things are working as they should now.
However
NLM= Novell Loadable Module
Egor Egorov [EMAIL PROTECTED] 6/10/04 4:09:13 PM
Mark Goldfarb [EMAIL PROTECTED] wrote:
I saw the script. I am actually fine running a shutdown on the
server
prior to each backup. Veritas BackupExec supports running commands
prior and after each backup. The
Eric Lommatsch wrote:
Hello,
We had a situation over night where users were getting the error message:
[My SQL][ODBC 3.51 Driver][mysqld-4.0.13-nt] Can't open file: flex. MYI:
[error : 145]
I found that .MYI file had become corrupted and I repaired the table and
things are working as they should
Hello, everyone
I am new on MySQL.
I created several tables by command:
%mysql jeandatabase -u root -h localhost -p
jean1.sql
and jean1.sql is as follows:
use jeandatabase;
drop table if exists jean1;
create table jean1(
id int not null,
field1 char(9),
primary key(id)
);
But, when
Jean,
Here is the format for the SHOW TABLE STATUS command from
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html:
SHOW TABLE STATUS [FROM db_name] [LIKE wild]
You are using FROM TABLENAME not your database's name. Try this:
SHOW TABLE STATUS FROM jeandatabase
and see if it works
Jean Zhong wrote:
mysql show table status from jean1;
It gave me the following error:
ERROR 12: Can't read dir of './jean1/' (Errcode: 2)
In SHOW TABLE STATUS, the thing after the FROM is a database name.
See here:
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
You want
SHOW TABLE
Jean,
The from jean1 is looking for a database named jean1, it is
not the table name. See
http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html
If you are already connected to the database, just use:
Show Table Status;
If you want status for a particular table then try:
Show
OK getting somewhere now...I have modified the code to the
more advanced option that you suggested...I am now getting a
return when I search by the ID but still not when I search by
the FName or LName:
Here is the html:
snip
* No, no error reported
* What command do I type to find
Hello,
I have a fairly complicated and large MySQL installation that I need to add
a new slave server to and I'm uncertain about the best way to get this done
with the least risk to my live environment and least downtime of my existing
masters. I'm hoping that someone here can suggest the best
Hello,
Thank you very much, everyone.
Yes, I want to know the table jean1 status.
I tried:
show table status like jean1
It works.
Thanks a lot.
Jean
--- mos [EMAIL PROTECTED] wrote:
Jean,
The from jean1 is looking for a database
named jean1, it is
not the table name. See
I'm not sure of the right way to submit these things, so I'll do it here...
I want to dump some data form the binlogs and process it back into the
servers. However I just want to process the data from one specific server.
In mysqlbindump I can optionally specifiy a specific database for the
For the benefit of the list...
Marty and I corresponded off list to make sure his PHP wasn't at fault, it
wasn't!
Turns out the problem was a corrupt table or index that 'optimize table
tablename' fixed up.
Cheers
Dean
--
MySQL General Mailing List
For list archives:
I'm wondering how mysql actually sends its data to a mysql client? Is it
binary data or plain text or encrypted with some general function? When
I use ethereal to capture the packets all I can see is anything but
plain text.
Thanks,
Craig.
--
MySQL General Mailing List
For list archives:
I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM.
They use InnoDB for all tables, and the ibdata file is 70GB.
The DBs seem to be a little slow, and the darn thing is always using a huge
chunk of swap. I've tried increasing and decreasing what it's allowed to
use, but this
Hi,
For a project I'm creating a search function, the deal is this, a select
query must be submitted and in this query a check must be done to confirm a
previously found and accepted item is not shown anymore, a short version of
the query I need is this:
SELECT * FROM t1 WHERE {all kinds
Have you tried using a JOIN as a way of eliminating the subquery?
If I understand you correctly, you are looking for certain items from
table1 only if there is no corresponding entry in table2. Am I close?
You would write that generally as:
SELECT field names from either table
FROM table1
LEFT
You might do something like:
SELECT t1.* FROM t1 LEFT JOIN t2 ON(t1.field1=t2.field1 AND field2={fieldvalue}) WHERE
{all kinds of limits} AND t2.field1 IS NULL LIMIT 0,20;
the LEFT JOIN/WHERE idfield IS NULL will join the table and then lists
rows in table 1 that don't exist in table 2
Mark van
Hi,
For a project I'm creating a search function, the deal is this, a select
query must be submitted and in this query a check must be done to confirm a
previously found and accepted item is not shown anymore, a short version of
the query I need is this:
SELECT * FROM t1 WHERE {all kinds of
In just installed mysql 3.23.58 on my debian system. and copied my.conf to
/etc/mysql/
I tried to start the the database by
mysqld --user=mysql
and it works just fine
but as I tried to start it by
./bin/safe_mysqld
--user=mysql
or ./support-files/mysql.server start
there is only one line
Hi all,
This is my first time on the mysql mailing list, I appreciate if someone
can help me with a major problem I encountered with mysql.
I have this weird problem with 1 transaction locking out another for no
apparent reason and in an inconsistent fashion. I'm using mysql 4.0.18
with innodb
Is there a COPY row or DUPLICATE row command? I would like to duplicate a
row with in a table with 38 columns (auto-incrementing the Primary Key on
the copied row, of course) and then alter the entry in ONE of its columns.
Can this be done without doing a SELECT, then INSERT, then UPDATE?
Hi,
Thanks for your reply Peter. Each booking is based on a particular project
by Project_ID. Is it possible to modify the query such that the projects are
listed in turn? For example:
Jan Feb Mar Apr May Jun Jul
Project 1 6 7 3 0 3 4 3
Project 2
I'mwrestling
over deciding on which data type to go with, TEXT or BLOB. I have one
table with one column of400 characters, I was thinking that TEXT may be
the way to go for that one.
I also have another table that
use 4 columns of 800 characters along with 5 columns that use 250
On Thursday, June 10, 2004, 1:20:03 PM, Mark wrote:
MvB Hi,
MvB For a project I'm creating a search function, the deal is this, a select
MvB query must be submitted and in this query a check must be done to confirm a
MvB previously found and accepted item is not shown anymore, a short version of
Hello All,
Is it possible to share a database between two processes when using
libmysql, the embedded version of MySQL?
My application will have one writer process and many reader processes and I
would like to share a single embedded database between all the processes. Is
that possible
Yes! but you will have to do some typing
Just use the INSERT ... SELECT command. You do NOT want list the PK column
in your statements (so that it will autoincrement) so you will have to type
out the rest of the column names. With a table that looks like:
CREATE TABLE testme (
id int
Hi, I'm dumping my database with Mysqldump using this command
mysqldump --extended-insert --add-drop-table -K --user=root xdatab
xtable xtable.sql
For a certain number of tables, the command seems to work perfectly..
But
some of the tables are missing records at the begining.
Could it be
John:
Try:
Insert into TABLE
Select *
from TABLE
where TABLEID = ?;
Update TABLE
set column = 'desired value'
where TABLEID = newPK;
It's a bit manual, but defn the quick and dirty for a single row now and
again.
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
Would you be willing to share your perl script? Perhaps offlist if you are
concerned about everyone seeing it?
I would like to see it as well.. If at all possible
- --
How
I recently upgraded a customers server from a P3/XEON box to a 64-bit Opteron
with 16GB RAM. They have more data than can easily be handled by a 32-bit
machine with the inherent limit of ~2GB on innodb_buffer_pool and is now much
faster. The old server ran 4.0.18 and I upgraded to 4.0.20 on the
Hi Scott,
No, TEXT and BLOB are the same except for the case-sensitivity differences.
Neither is like VARCHAR (except the with/without BINARY attribute part) in
that TEXT/BLOB columns don't lose trailing spaces when inserted, as VARCHAR
will -- just to clear that up.
That article is wrong, at
I have a strange problem importing data from a text file. There are 1353
rows in the text file (generated by a Perl script) but only 1000 get
imported into MySQL. I am clueless why would this be happening - it
seems as if there was a cutoff point at 1000 rows which, of course,
doesn't make any
Hi
Configure run command:
./configure \
--prefix=${INSTALL_DIRECTORY} \
--exec-prefix=${INSTALL_DIRECTORY} \
--libexecdir=${INSTALL_DIRECTORY}/bin \
--disable-shared \
--enable-thread-safe-client \
--enable-local-infile \
sounds like --safe-mode has been turned on, check your my.cnf files
- hcir
On Jun 10, 2004, at 7:18 PM, Nik Belajcic wrote:
I have a strange problem importing data from a text file. There are
1353
rows in the text file (generated by a Perl script) but only 1000 get
imported into MySQL. I am
72 matches
Mail list logo