Did you try to use packages instead of ports? It is simpler then
compiling from source. Try it if you have not reasonable causes to use
ports.
[EMAIL PROTECTED] wrote:
I hope I can get some help here, I'm installing mySQL on OpenBSD and i
cannot find the mysql_install_db file, all the
Hello,all!
Is this planned to add support of milliseconds
to TIME types (DATETIME and TIME) in mysql? In ISO we have time_precision
parameter both for TIME and TIMESTAMP.
-- Sincerely , Evgeny
-
Before posting, please check:
Dear all,
I was downloaded the mysql-3.23.53-sol8-sparc-local.gz from
www.sunfreeware.com . But I don't know why I got the following error when
I start the mysql service :
030306 16:10:14 mysqld started
030306 16:10:16 /usr/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host
.frm'
Dear all,
I was downloaded the mysql-3.23.53-sol8-sparc-local.gz from
www.sunfreeware.com . But I don't know why I got the following error when
I start the mysql service :
030306 16:10:14 mysqld started
030306 16:10:16 /usr/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host
.frm'
Harish B M (RBIN/ECM2) * would like to recall the message, Error while
starting mysqld .
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I am trying to install MySQL version 3.23 database server (Downloaded from Internet)
on a Intel Pentium III machine installed with SuSE Linux 8.0 Professional. While
starting the mysqld daemon, it is giving the following Error.
Can't connect to the local MySQL server through
Hi!
I'm having this main table with references to files in it:
files
+-+-+
| id | filename |
+-+-+
|168 |v008-12.jpg|
+-+-+
Then I have this table to relate one file to one or several categories:
relatedtable
+-++--+
|
Description:
The update command seems does not using the index to find the rows to update.
Here are the command I have execute on MySQL client. You will be found the different
in execute time used. I don't know it is normal or just a bug of the MySQL server.
EMS HiTech Company is pleased to announce EMS MySQL Export/Import v1.3 - the
new version of our easy and useful data management utilities for MySQL.
You can download the latest versions of MySQL Export and Import from
http://www.mysqlutils.com/download.phtml
What's new in MySQL Export 1.3?
1.
I'm currently building a database and am using a timestamp(14) column for
keeping track of when an entry was added to it. Is there an easy way to
remove records that are more than 180 days old inside a MySQL query
instead of going through and removing tham all by hand,
Thanks,
Ed
Filter-fodder: mysql, query
Ah. Sorry about that.
Given a query:
SELECT academic_institutions.name,
academic_institutions.town, countries.abbrv,
inst_types.name, academic_institutions.acinstid
FROM academic_institutions, inst_types
LEFT JOIN countries ON
* [EMAIL PROTECTED]
I'm currently building a database and am using a timestamp(14) column for
keeping track of when an entry was added to it.
Beware that this column also will be updated when you update _any_ column in
the row...
URL: http://www.mysql.com/doc/en/DATETIME.html
Is there an
Hi all,
If I develop a software for my company that works with MySQL and this
software will be used only inside the company, do I have to purchase
commercial license?
Thanks,
Dan
-
Before posting, please check:
On Wed, 2003-03-05 at 15:16, Johannes Ullrich wrote:
on mysql 4.0.10-gamma (rpm install, Redhat advanced server), I
am running into 'too many open files' issues ( error 24 ).
I am using a rather large merge table (30 distinct tables merged),
which is likely the culprit. The error
But I have no idea what the warning is. Is there any
way to find out? mysql_error returns '\0' so it's no
help.
Thanks!
Do you have access to your mysql logs? If you do I'm thinking that the warning
should be in there. When I just looked at my logs I only see one specific mysql
log named
Perhaps TIMESTAMP will provide what you need.
Daevid Vincent wrote:
http://www.mysql.com/doc/en/CREATE_TABLE.html states Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE.
Is
Hi William,
Sleeping processes are the result of persisitant connections and
should not slow down your server. As to why you server is so slow
you will have to provide specific examples of what is slow. We reach
speeds of 600 queries per second on slower hardware. Also please
indicated
Make sure you have an index on billingstatus.
Murugavel wrote:
Dear Mr. Venu Tech Group,
We are facing few problem in mysql database.
Take an eg.
we have table called bb_usersession0
user A is trying to delete a record which is having the billingstatus B .
User A
delete from
What does, rcmysql status say?
--- Mark [EMAIL PROTECTED] wrote:
Hi, I just installed 3.23.55 and I started getting
this message when
I run mysql from the shell.
/tmp/mysql.sock exists and the permissions are right
and mysqld is
running, also the weird thing is that php is
connecting just
On Thursday 06 Mar 2003 3:11 am, William Wang wrote:
Question 1: Does sleeping processes slow down database server?
Nope, I have had many a discussion whats best to use, pcconect or normall
connect but have yet to conclude what is better. We feel that pconnect works
best for us.
Question 2:
Hi,
I'm running MySQL-Server 2.23.55-nt under Windows XP SP1 and use Connector/J 3.0.6 .
Some fields in my database contain windows pathnames including backslashes, for
example doc\testdat.
When I try
PreparedStatement psZuBearb = conn[dbindex].prepareStatement(select dokid, pfadname,
The user under which the mysql server runs must be the owner of these files.
Kevin Chan wrote:
Dear all,
I was downloaded the mysql-3.23.53-sol8-sparc-local.gz from
www.sunfreeware.com . But I don't know why I got the following error when
I start the mysql service :
030306 16:10:14 mysqld
On Wednesday 05 March 2003 19:34, Bruce Feist wrote:
I'm having trouble getting MySQL running on a RedHat Linux 7.1 machine.
The log file complains that host.MYD is missing; I don't see mention
of this file in the documentation, and it's not on my computer anywhere.
Did you run
On Thursday 06 March 2003 13:40, wrote:
I'm currently building a database and am using a timestamp(14) column for
keeping track of when an entry was added to it. Is there an easy way to
remove records that are more than 180 days old inside a MySQL query
instead of going through and removing
On Thursday 06 March 2003 10:36, Kevin Chan wrote:
I was downloaded the mysql-3.23.53-sol8-sparc-local.gz from
www.sunfreeware.com . But I don't know why I got the following error when
I start the mysql service :
030306 16:10:14 mysqld started
030306 16:10:16
Hi all,
I am trying to run this script below on a MySQL-4.0.11-NT server. It stops
at the UserLogs table, but if I swap the last two tables' creation order,
it runs correctly. Can anyone help me with this?
Thanks
Dan
/* Begin */
CREATE TABLE `Branches` (
`Id` int unsigned not null,
Hi all,
Sorry, I forgot to tell, that my default table type is InnoDB.
I am trying to run this script below on a MySQL-4.0.11-NT server. It stops
at the UserLogs table, but if I swap the last two tables' creation order,
it runs correctly. Can anyone help me with this?
Thanks
Dan
/*
Egor Egorov wrote:
On Wednesday 05 March 2003 19:34, Bruce Feist wrote:
I'm having trouble getting MySQL running on a RedHat Linux 7.1 machine.
The log file complains that host.MYD is missing; I don't see mention
of this file in the documentation, and it's not on my computer anywhere.
Did
Hello Tonu,
I remember your name from the revision history:
you Added VIO wrapper (needed for SSL support) ; P
anyways, yes I did run
# ./configure --with-vio --with-openssl --prefix=/usr/local/mysql
and also tried the max version
I also ran mysql_fix_privilege_tables.sh (one along 3.23.46
Am 05.03.03 schrieb Thomas Spahni:
Some words like Tetraeder have the combination 'ae' and should be found
looking for LIKE '%ae%'; surprisingly this works:
Queries with LIKE '%...' can't use the index and work correct.
Unfortunately this is no option for big tables.
Ciao,
Fabian Schmidt.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gerfried Günteer wrote:
Hi,
I'm running MySQL-Server 2.23.55-nt under Windows XP SP1 and use Connector/J 3.0.6 . Some fields in my database contain windows pathnames including backslashes, for example doc\testdat.
When I try
PreparedStatement
* Jerry
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en/Replication_FAQ.html
* me
master-master replication is the same as two-way replication, and
it is mentioned in the above FAQ, halfway down the page:
Q: What issues
For example I have three databases, db1, db2, db3.
I have used command mysql use db1; to select db1, then forsome silly
reason I forgot which db I am in. Is there a quick mysql command that
can show that you are in db1?
Cheers
Jonathan
Well no because real two-way replication would happen at the dB level, or
through some distributed transactional layer.
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Jerry [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 4:02 PM
Subject: Re: Data
Hi.
On Thu 2003-03-06 at 12:45:19 +, [EMAIL PROTECTED] wrote:
If I develop a software for my company that works with MySQL and this
software will be used only inside the company, do I have to purchase
commercial license?
No, the GPL license will do: The GPL focuses on _distributing_
Hi,
I need to dump a database table in tab seperated or comma seperated format
and then want to delete the entries in that table.(And then mail the dump
to someone.)
Can i get some pointers about this. (I was not able to use -T option in
mysqldump, i am trying ./mysqldump -T awf_four false_info
On Tuesday 04 March 2003 22:34, Andrew Braithwaite wrote:
This is quite an involved one...
Using MySQL 4.0.11 on linux
I have two logical db's on the same machine, lets say db1 and db2.
I have perl apps doing the following: replace into db2.tablename .
In my.cnf I have the line
* me
ok... then you are not doing real two-way replication, you are only
replicating two ways, so to speak... if I understand you correctly,
which I probably don't... why do you tell us this? :)
* Jerry
Well no because real two-way replication would happen at the
dB level, or through
* Jonathan Li
For example I have three databases, db1, db2, db3.
I have used command mysql use db1; to select db1, then forsome silly
reason I forgot which db I am in. Is there a quick mysql command that
can show that you are in db1?
select database();
or \s (or status) in the standard
If you confused I wouldn't bother replying.
I was answering another question from a while ago.
J
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: Jerry [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 4:23 PM
Subject: Re: Data sincronization
* me
I have a mysql table that I refer to a lot and needs to be quick. I set
it as a HEAP table because of the speed (and HEAP tales ARE fast. zip
baaannn). Anyway, whenever I restart the server the contents of
the heap tables disappear! What the hell? But I read the manual and it
seems
Store it in another table and have a start up script that creates a heap
once the server is started ?
Jerry
- Original Message -
From: Steve Quezadas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on disappearing!
I have a
Or just give MySQL plenty of ram and trust it to keep frequently used data
in ram - which it does. Prime the system by doing some form of search
which forces all the rows into memory (Select * from table where
unindexedfield = somethingimpossible), the do a speed test on this versus a
heap table.
Description:
I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X
machine (version 10.2.4) and I couldn't get it to start up. When I run
bin/mysqld_safe, I kept getting the error Fatal error: Can't open
privilege tables: Table 'mysql.host' doesn't exist [note: I later
figured
http://www.mysql.com/doc/en/SEC457.html states that there must be an
index where the foreign key and the referenced key are listed as the
FIRST columns. Will this restriction be lifted soon? It is incredibly
frustrating. I don't see why they have to be indexes, and more
importantly, I don't
when I try to connect to mysql (on the same host as mysqld):
mysql -h mysql.vhost1.com
I get: Access denied for user [EMAIL PROTECTED]
mysqld runs at hostname.domain.com
mysql.vhost1.com and hostname.domain.com have the same ip
mysql first looks up the ip of mysql.vhost1.com
then resolves it
Hi,
You also get back a hell of a lot as a result of buying support. It has
really been a grand experience for us so far. If your databases are
important, and esp if you work on more than one machine. Support is a very
small price to pay to get *THE* answers. For example we had a query problem
On 5 Mar 2003, at 19:39, Daevid Vincent wrote:
Right, but sometimes it isn't, or you already used up that 'first'
spot for a different foreign key reference in another table.
I think you're misunderstanding something. In the subject line you
talk about the first index, and talking about
Hi,
What am i doing wrong:
# ./mysql database name -e delete * from table name where id 5;
I get the mysql help page on exectuting the above command.
The mysql verison i am using is : 3.23.52.
Thanks and regards
anil.
-
Hi,
The right DELETE syntax is :
delete from table name where id 5;
Regards,
Jocelyn
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 6:26 PM
Subject: command line exectution of query(newbie)
Hi,
What am i doing wrong:
Sorry,
# ./mysql database name -e delete from table name where id 5;
The above command too doesn't work, it shows the mysql man page.:(
any more ideas?
thanks and regards
anil.
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 2:38 PM
Database name goes after options. It is showing you the help page because
it does not understand what you are passing to it. It's kind of saying
Here, look at this, this is how I work, follow these directions they might
help you out.
-Original Message-
From: Anil Garg [mailto:[EMAIL
At 11:41 -0800 3/6/03, Steve Quezadas wrote:
I have a mysql table that I refer to a lot and needs to be quick. I
set it as a HEAP table because of the speed (and HEAP tales ARE
fast. zip baaannn). Anyway, whenever I restart the server
the contents of the heap tables disappear! What the
At 13:40 -0500 3/6/03, Anil Garg wrote:
Sorry,
# ./mysql database name -e delete from table name where id 5;
The above command too doesn't work, it shows the mysql man page.:(
My quess:
It's not showing the man page, it's showing an error message, followed
by the mysql help message. The help
thanks, that helped :)
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 1:49 PM
To: Anil Garg; [EMAIL PROTECTED]
Subject: RE: command line exectution of query(newbie)
Database name goes after options. It is showing you the help page
Hi,
I am Revati, graduate student from University of Texas
at Dallas. I want to use mysql for learning puopose,
so I have downloaded mysql-3.23.55-win.zip file.
While I unziping it using winzip, it gives meaage of
INSTALL NOW. After I click install it gives me
following error:
The NTVDM CPU has
Hi,
I have searched the archives and unfortunately could not find a solution to
my problem. I have setup a machine as a mysql server and cannont connect to
it remotely. When I try telnet localhost 3306 all seems ok. When I try
telnet domain.com 3306 I get the message Connection closed by foreign
Hi,
I'm using a mysql table to store small messages
in a p2p messaging server.
The primary key (message_id)is a UNSIGNED BIGINT,
Which is supposed to be 64 bit, with autoincrement.
The each row is deleted as soon as it is fetched
By the client, and also after the expiry of a period
(~30 days).
Hail,
Below is the table that is generating the following error:
LOAD DATA LOCAL INFILE '/www/htdocs/car-list/admin/8_rows_dealerX_test.csv'
REPLACE INTO TABLE carlist_db.e_xoops_dealerX_cardealers FIELDS TERMINATED
BY '\t' LINES TERMINATED BY '\r' (manufacture name,name,street
/var/lib/mysql/ i think that path needs to writable 777 so it can write the
socket to it
-Original Message-
From: Harish B M (RBIN/ECM2) * [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:51 PM
To: '[EMAIL PROTECTED]'
Cc: Pemmaiah B D (RBIN/ECM2) *
Subject: Error while starting
Hi,
While unzipping and installing mysql-3.23.53-win.zip
file the following error message was reported in a
dialog box with caption '16 bit MS-DOS Subsystem' (?)
The NTVDM CPU has encountered an illegal instruction.
CS:020a IP:0115 OP:0f 00 00 00 00 Choose Close to
teminate the application.
Hi,
While unzipping and installing mysql-3.23.55-win.zip
file the following error message was reported in a
dialog box with caption '16 bit MS-DOS Subsystem' (?)
The NTVDM CPU has encountered an illegal instruction.
CS:020a IP:0115 OP:0f 00 00 00 00 Choose Close to
teminate the application.
Hi All,
After googling around and checking out the archives I still haven't found
the exact answer to my following question:
First off the goal is to give a family multiple quotes from different
companies for insurance based on several factors: age, length of coverage
and coverage limits. All
Hi, all
I have a mysql server that has been suffereing performance problems due to
disk fragmentation problems.
The server is on a red hat 7.3 box, and the tables in question are MyIsam.
The problem seems to be occuring because there are millions of inserts and
millions of deletes each week.
In the last episode (Mar 06), Lou Ann Hammond said:
Hail,
Below is the table that is generating the following error:
LOAD DATA LOCAL INFILE '/www/htdocs/car-list/admin/8_rows_dealerX_test.csv'
REPLACE INTO TABLE carlist_db.e_xoops_dealerX_cardealers FIELDS TERMINATED
BY '\t' LINES
At 1:19 +0530 3/7/03, Jeethu Rao wrote:
Hi,
I'm using a mysql table to store small messages
in a p2p messaging server.
The primary key (message_id)is a UNSIGNED BIGINT,
Which is supposed to be 64 bit, with autoincrement.
The each row is deleted as soon as it is fetched
By the client, and also
Hi Folks ...
I'm new to mysql, not to databases nor to programming.
I am developing a web-based app using php and mysql.
I want to drive the app off of metadata, a set of mysql databases which
contain the list of database field names and both their database and
screen attributes. I would
I have a DB where all of the tables are InnoDB, and there are a few
straightforward FOREIGN KEY constraints. I would like to use mysqldump to
back up the data or move it to another machine.
The problem I'm running into is that when I try to import the data using
mysql, the data is imported in the
Description:
Under a variety of circumstances, creates and inserts of a
table with many columns, 2304 to be exact, hang the server. The
symptoms are that the mysqld thread gets a signal 11, and the client
never completes. show processlist gives, for example
mysql show processlist;
Rick Mann wrote:
I have a DB where all of the tables are InnoDB, and there are a few
straightforward FOREIGN KEY constraints. I would like to use mysqldump to
back up the data or move it to another machine.
The problem I'm running into is that when I try to import the data using
mysql, the data
Howdy,
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Here's what I want to do: I have two tables, categories
Mysql version 3.23.55 Slackware linux 8.0
Mysql version 3.23.55 OpenBSD
I have tried 3 versions of mysql on linux and
on OpenBSD. I have even tried compiling on linux
from the source tarball.
Without the GRANT privs to allow network access:
mysql GRANT ALL PRIVILEGES ON db.*
- TO
Hi Steve,
Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
mysqladmin -p reload
B.
In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.
Mysql version 3.23.55 Slackware linux 8.0
Mysql version 3.23.55 OpenBSD
I have tried
Or
mysql flush privileges;
Roger
-Original Message-
From: Ben Balbo [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:08 PM
To: MySQL List
Subject: Re: ERROR 1045: Access denied for user:
Hi Steve,
Really silly question, but you are reloading the tables once you
change the
I am running RedHat 7.3, mostly using InnoDB's. I am using the
MySQL-Max rpms (4.0.11) from mysql.com.
Earlier today it crashed, and while trying to start up again it
crashed again. Now I can't start the server with the InnoDB tables.
I don't see any tools to fix it. What to do? I would like
75 matches
Mail list logo