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
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
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 tri
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 user@'192.
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 an
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 is
>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;
***
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
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 then
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 after
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
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.
(pro
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 the
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.
Pleas
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.
Pleas
/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 m
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
address,city,stat
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).
64
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 fore
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 en
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 becau
At 13:40 -0500 3/6/03, Anil Garg wrote:
Sorry,
# ./mysql -e "delete from 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 message is so long tha
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 h
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 PR
Sorry,
# ./mysql -e "delete from 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
To: Anil Garg; [EMAIL
Hi,
The right DELETE syntax is :
delete from 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:
>
Hi,
What am i doing wrong:
# ./mysql -e "delete * from 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.
-
Before posting, please c
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 usi
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
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 back
> 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 d
>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
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
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
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 that
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
* 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 st
* 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 th
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
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
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
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:
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
--
* 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 pag
-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 psZuBea
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 Schmi
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 sourc
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
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
/* Beg
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, /
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 /usr/local/mysql/l
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 removi
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 mysql_ins
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
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,
anzeig
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:
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
> conn
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 bb_usersess
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 lang
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 t
> 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 name
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
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:
http
* [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...
http://www.mysql.com/doc/en/DATETIME.html >
> Is there an easy
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 academic_instituti
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
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. Ex
>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.
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
+-++--+
|i
> 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 thro
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 archiv
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'
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:
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 document
75 matches
Mail list logo
