On Thu, 24 May 2001, Scott Baker wrote:
I don't agree.
If mysql install in other directory then /usr/local
you need use --with-mysql=mysqldir
and sometimes --with-mysql-include and --with-mysql-lib
options.
Do you need to specify a directory? I just did --with-mysql
At 01:14 PM 5/24/2001
Am I posting to the right list? I'm new to this thing.
Anyway, I have an interesting, though I think not unusual predicament.. I'm
maintaining a number of different tables that contain timestamp fields that
keep track of the last time a record was modified. My problem is that if I
want to
Hello Alice,
Friday, May 25, 2001, 7:14:23 AM, you wrote:
A Hi, i am a win2k professional user,
A and i would like to get a mySQL front end tools which can make
A mySQL to be work more user friendly.
A currently i am using MySQL-Front, for those who had tried out others this kind of
tools,
hello,
when i rebooted the system, an error occured :
Can't connect to local MySQL server through socket
/var/lib/mysql/mysql.sock
I've already check var/lib/mysql directory and mysql.sock does exist..
how do i connect this ? why is it everytime i reboot the system it produces an error
Dear,
easy way to install another application with mysql is specify
mysql dir and mysql data dir at installation. use this parameter while
install mysql
./configure --prefix=/usr/local/mysql \ -- this will install all
mysql
---Reply to mail from Nathanial Hendler about How many queries per second do you get?
Hello, I was just looking at my MySQL databse using mytop and saw that I was
getting over 60 queries per second. Can people give me an idea of how many
queries per second they get?
Hello
I have a
Hi,
I am looking for an easy way to synchronize two mysql-databases (only
the sql-structure). I want to compare two structure dumps, find out the
differences and get alter table statements as result.
CU
Dorthe
-
Before
hy
i m using mysql-3.23.38.tar.gz in redhat6.2
i have .db tables
1-how can i bakup them ?
when i use mysqldump or a simple copy , it s failed : when i remove table to
another mysql server : the server dont read the .db files even if their size
are he same then the original
i can t export .db
Stelian Anton writes:
Hello All,
When I check to running the mysql_install_db I have the error:
root@gem:/usr/local/mysqlscripts/mysql_install_db
ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file
or directory
Environment:
System: SunOS
Hello all
I have try several time to install MySQL on my windows 98 machine with no luck I
have look thur the readme file. It seems to load but will not start. Any help will be
welcome
Paul
Hi,
got a problem as mysql does not allow writing but 127 entries to a
database, any idea how to correct this abnormality?
Jari Mäkelä
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
got a problem as mysql does not allow writing but 127 entries to a
database, any idea how to correct this abnormality?
Jari Mäkelä
You probably created an auto-increment field of type tinyint - check the data
specification for tiny int in the online manual to see whay it's happening
Define your tables so you're not using TINYINT as your primary key - it has
a maximum size of 127.
If you use INTEGER you should be fine.
HTH
Jon
-Original Message-
From: Jari Mäkelä [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 12:29
To: [EMAIL PROTECTED]
Subject: Database accepts
I have a very annoying problem in a big program, that I
reduced toa small and reproductible java program (see code excerpt
below).The problem is as follows :I have 2 separate connexions on the
same BDB table, and I try to do:
Connexion1: Set autocommit (false)Connexion1
: INSERT INTO
hi again,
am not quite sure of this as Mysql is too new thing to me but apostrophes
like plain 'and é in text being written in has to be dealt with
somehow, is the say 0'keefe solution the proper way to do that.
meaning that O\'keefe works?
Jari Mäkelä
Hi,
Try DBTools ( http://dbtools.vila.bol.com.br
http://dbtools.vila.bol.com.br ). It's a Win32 client for mySQL, free, and
has lot of features, including an Import/Export Wizard to help you convert
other sources to mySQL.
[]'s
Crercio O. Silva
-Original Message-
From: Alice
Yes, you have to escape special characters.
Not sure about accents etc, but a search on the list archives
(lists.mysql.com) should turn up something, this gets discussed pretty
regularly.
HTH
Jon
-Original Message-
From: Jari Mäkelä [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 13:03
[EMAIL PROTECTED] writes:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query
This is very silly. I am subscribed to the list and I used
Rolf Hopkins writes:
You can still use foreign keys, just that it has no effect in mysql.
Yes, I know. I just would like to provide the information in the
CREATE TABLE definition and be able to retrieve it later.
Nothing more.
The manual says:
In the near future we will extend the
This does not return any results
SELECT LAST_INSERT_ID() FROM tablename;
there is an indexed, auto-incrementing field in the table, but it refuses to
show any results. I don't understand the manual's text, so any help would be
appreciated.
Dave Carter
Chief Web Architect
Accelerated
Hello Dave,
If your auto-incrementing field in your table are Account_ID for exemple,
try :
Select Account_ID From tablename Where Account_ID = LAST_INSERT_ID();
This work fine for me
Bye
Ghislain Proulx
Web Programmer
Groupe Ordimax
http://www.ordimax.com
http://www.infoteck.qc.ca
Also
http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip
-Original Message-
From: Crercio Osmaildo da Silva [mailto:[EMAIL PROTECTED]]
Sent: Fri, 25 May 2001 14:17
To: [EMAIL PROTECTED]
Subject: RE: MySQL front end tool
Hi,
Try DBTools (
So in my insert into select, I would just add another Select Like
this:
INSERT INTO tablename (field1,field2,field3)
SELECT table2.field1, table2.field2, table2.field3
FROM table2
SELECT LAST_INSERT_ID();
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
Folks,
I am with Security Managment Consulting, and we have a liscensed copy of
mysql. I don't have the lisc. # on hand.
We have a very large database in mysql, and one of the tables (call it
badge_history) has about 4,000,000 records, with the potiental to get
much bigger...
Now, we are
The problem has been resolved. There is apparently an undocumented option
(at least it's not documented in the HTML manual for 3.23.38) required in
the my.cnf file - use-symbolic-links. I was using all default values, so
I wasn't even using a my.cnf or a my.ini file.
Here's how I made it work
The problem has been resolved. There is apparently an undocumented option
(at least it's not documented in the HTML manual for 3.23.38) required in
the my.cnf file - use-symbolic-links. I was using all default values, so
I wasn't even using a my.cnf or a my.ini file.
Here's how I made it work
Hello, I´m Brazilian and a new subscriber of this list.
(sorry my english)
I´m working with MySql and with a 100.000 rows table, this table is
growing 300 rows in each day.
How can I arrange this information to get a good performance of my
queries (my SELECT´s) ?
We intend to do this:
Work with
I'm sorry, but we need a little more information, Such as the query
you're using, the machine type, ram etc., the table structure. With out
those its very hard to help you optimize anything.
Bruno Faé wrote:
Hello, I´m Brazilian and a new subscriber of this list.
(sorry my english)
I´m
It's all about index's. My current big table is a table which currently
has ~500,000 rows. We add around 4000-5000 rows a day. This is simply a
table storing session data for visitors. Because of the large amounts of
inserts, we keep the index's low, have 1 primary and 2 non unique index's
Hello Gurus,
I am trying to write a C client for a mysql server and I compile the
example with the following line
gcc -g Bug_Report.c -o test.o
-I/usr/include/mysql -L/usr/lib/mysql
-lmysqlclient -lnsl -lsocket
but I get the following linking errors
/home/nicu/QA/Bug_Report.c:7: undefined
Hi,
I have a book explanning mysql and the commands, and I was here searching
for some kind of a command that do waht I want. But I didn't find
anything
I have a table named as mytable and two columns (id, name).
Like this
id name
1 blue dot
2 blue pencil
3 blue pen
.
And I want to alter
If each record is about 1K byte, how many records can MySql handle? Does anyone have
any estimation or hands-on experience?
Thank you very much in advance.
Regards,
George
-
Before posting, please check:
Does your Bug_Report.c have an #include line for the mysql headers?
- Original Message -
From: Nicu Popovici [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 9:54 AM
Subject: Compilation problems.
Hello Gurus,
I am trying to write a C client for a mysql server
UPDATE table SET name = REPLACE(name,'blue','');
- Original Message -
From: Tiago Mota [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 9:43 AM
Subject: update a column
Hi,
I have a book explanning mysql and the commands, and I was here searching
for some kind of
Depends on OS, memory, disk space.
Theoretically there is no limit.
If your using linux, and don't have support for large files built in, then
your table size limit is 4GB. Putting a table with 1k rows at a max size of
around 4 million records. If you have large file support in, and have the
With the correct indexes this query should run in less than a second.
Basically what you should do is make an index for every column that is used
in the where clause. For instance, if you had a query ... WHERE A=X AND B=Y
AND C=Z (A,B,and C are in the same table) you would create an index (A,B,C)
it all depends on your hardware, technically the MyISAM table type can
handle up to 8 terabytes of data.
Zhu George-CZZ010 wrote:
If each record is about 1K byte, how many records can MySql handle? Does anyone
have any estimation or hands-on experience?
Thank you very much in advance.
Hi,
(Sorry about my previous post: wrong list)
In 3.23.32, I can do a show databases, no problem, it shows my 18 database names.
But with
3.23.38, with the same user, I only get 36 empty rows
for a show databases.
Same problem with show tables.
However, my applications work ok under
Hi,
Using linux redhat 6.2, apache1.3.20 (compiled fresh), php4.0.5 (compiled
fresh with msql support), mysql 3.23.38 (rpm install for server and
client).
I run the following php4 test script in query.php from a browser:
snip--
?php
$hostname=localhost;
$username=;
$password=;
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the
Depends on OS, memory, disk space.
Theoretically there is no limit.
If your using linux, and don't have support for large files built in, then
your table size limit is 4GB. Putting a table with 1k rows at a max size of
around 4 million records. If you have large file support in, and
I am trying to start mysqld on a RH7.1 box. The mysql server was installed by the
initial RH install routine. I ran the install script to setup the initial databases.
I can run either the msql.server or mysqld commands and while the process starts with
the /var/lib/mysql database, it just
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the
1) Don't use the Redhat RPM's, download the RPM's from mysql.com
2) Check /var/lib/mysql/hostname.err for error reasons
3) Check your config
4) Don't use the Redhat RPM's.
- Original Message -
From: Tom Walker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 10:37 AM
hi.
quick fix:
if it's really in /var/lib/mysql/, just make a symlink in /tmp...
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
not-so-quick fix:
or, recompile php w/ the path to mysql and it should figure it out.
-ravi.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
I'm not sure if an index would help me or not in this case.. and not
sure how to set one at creation. So I'll explain it all
My main select is
select * from on_db where time$t_tim ORDER BY place DESC
I also run the query
select * from on_db where time$t_tim AND place='thisplace'
$t_tim is the
For the following select:
SELECT DISTINCT badge_history.xact_date AS xact_date,
badge_history.xact_time AS xact_time, badge_history.last_name AS
last_name, badge_history.bid AS bid, badgests.cond_desc AS status,
department.description AS department, badge_history.reader_desc AS
reader_desc,
Did you try EXPLAIN before SELECT?
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#EXPLAIN
Mike Baranski a écrit :
For the following select:
SELECT DISTINCT badge_history.xact_date AS xact_date,
(...)
--
Marc Delisle
Service de
I am trying to do a left join query to retrieve all the rows in Table T1
and a value from server01_history.
There are 100 rows in T1 and I expect some NULL values for b.total
returned from server01_history.
Does anyone have any Idea why I only get back 93 rows with no nulls
Has there been any resolution the
show tables;
show databases;
my @tablenames = $dbh-tables;
etc...
not working on RedHat 7.X machines?
--
Daniel Bohling
NewsFactor Network
-
Before posting, please check:
A few people have said that they've fixed it by recompiling mysql with
gcc 2.96
Daniel wrote:
Has there been any resolution the
show tables;
show databases;
my @tablenames = $dbh-tables;
etc...
not working on RedHat 7.X machines?
--
Daniel Bohling
NewsFactor Network
At 9:48 AM -0400 5/25/01, Dave Carter wrote:
This does not return any results
SELECT LAST_INSERT_ID() FROM tablename;
It doesn't return *any* results? Or do you mean it returns 0?
FROM tablename is superfluous here; the most recent AUTO_INCREMENT value
is maintained on a per-connection basis.
At 10:39 AM -0400 5/25/01, Dave Carter wrote:
So in my insert into select, I would just add another Select Like
this:
INSERT INTO tablename (field1,field2,field3)
SELECT table2.field1, table2.field2, table2.field3
FROM table2
SELECT LAST_INSERT_ID();
Uh, no. Perhaps you should tell us
No results not even a zero. So what I did was something like this:
INSERT INTO table1 (field1,field2,field3)
SELECT table2.field1, table2.field2, table2.field2
FROM table2
WHERE table2.UID = SomeVariable;
SELECT MAX(table1.UID) FROM table1;
---
Now this assumes that
I'm up to 3.23.37-1 (compiled with gcc 2.96-69).
Haven't had one work properly starting with 3.23.32.
Gulp...It's been months now.
Thanks for the reply though,
--
Daniel Bohling
NewsFactor Network
Colin Faber wrote:
A few people have said that they've fixed it by recompiling mysql with
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
^
You're quite ahead of me, timewise *G*
Is there a way to store the time and date that a record was added within
MySQL? I want to show the time and date on some of my records and can't seem
Add a
Scratch that, normally egcs and gcc are the same, at least on older
redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
same as your gcc.
I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
3.23.38 from the .src.rpm.
Both show tables, show databases now
Is there a way inside of mysql to force the case of data being inserted into
the database???
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-
Before posting, please
I've been using LEFT JOIN and NATURAL LEFT JOIN for awhile on queries to
medium-sized tables (2500-50,000 items) that aren't TOO large by ane means,
but have seemingly been having some issues with this. Can anyone here
explain to me the memory usage between doing things like:
SELECT
So sprach Dave Carter am Fri, May 25, 2001 at 06:21:08PM -0400:
Is there a way inside of mysql to force the case of data being inserted into
the database???
- http://www.mysql.com/doc/S/t/String_functions.html
LOWER() / LCASE() and UPPER() / UCASE()
Alexander Skwar
--
How to quote:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
Can anyone tell me what to do about this error.
I installed mysql on Redhat 7.0 with the RPM on the Redhat Cd
-
Before posting, please check:
Scratch the Red Hat RPM and get the latest build from www.mysql.com This is
a FAQ here.
Cheers
Mike
-Original Message-
From: Jeff Pace [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 4:40 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2002:
Can't connect to local MySQL server through
I know this is a fairly common question, but I thought I'd ask it anyway. I
want to do something like:
UPDATE tab1 SET tab1.val=tab2.val WHERE tab1.id=tab2.id;
Is there any way to do a query like this?
Thanks,
Chris
-
Hi,
i am unsure what to put in this line, currectly i have the following line
$RS=mysql_fetch_array($RS_query);
but i get the following error message
supplied argument is not a valid MySQL result resource. so that statement most be
total wrong.
i am trying to get a result from a row when
Please Click Link For an Example
www.jmelynch.com
Need More Business? Contact Us.
Email: [EMAIL PROTECTED] with your Phone Number
Thank-You
Jamie Lynch
We comply with proposed federal legislation regarding unsolicited
commercial e-mail by providing you with a method for
Hey all,
Using a CGI script, I want to access a database from A DIFFERENT server than the mysql
database is
hosted. What is the proper syntax to access the mysql database on a different server?
They're 2 levels of secruity:
1. Log into Telnet shell
2. Log into database
This is what I have
This is what I have derived from O'Reilly books, though they make the
assumption that you are
running the script from the same server as the database:
$dbh = DBI-connect(dbi:mysql:table1, $host, $user, $password) or die
Unable to connect;
# table1 is the name of database.
I believe it's
The syntax for connecting to a mysql database from perl/DBI is
my $dbh =
DBI-connect('dbi:drivername:database:host','username','passwor
d');
If host is ommitted, it presumes localhost.
Eg: $dbh =
DBI-connect('dbi:mysql:testDB:dbserv','$username','$password');
There are more options see
This is well outlined in the DBI perldoc btw ;-)
Andy Sharp wrote:
The syntax for connecting to a mysql database from perl/DBI is
my $dbh =
DBI-connect('dbi:drivername:database:host','username','passwor
d');
If host is ommitted, it presumes localhost.
Eg: $dbh =
At 5:13 AM + 5/26/01, tu tuande wrote:
Hello,
Does Mysql run on Windows ME? I have tried to start mysql, version
3.23.38, by mysqld but I got the error message: Can´t initalize
InnoDB as 'innodb_data_file_path' is not set. How could I solve
this problem? Thank
Frank Tu
70 matches
Mail list logo