Leonardo,
Earlier you said that a statement without a parameter ('?') works, but
one with a parameter doesn't.
In both cases, are you still using a PreparedStatement?
-Mark
yes, it is always a preparedstatement.
If you need more details (or you want me to try something else)
After upgrading from to 4.0.18 I can no longer access my innodb tables
created under 3.23. I get these errors:
% mysql -uroot db0
...
Didn't find any fields in table 'Employees'
...
My database files and .frm files are all present and readable.
No errors in the hostname.err file either.
I tried
( first.. sorry for my english )
hello people..
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i have
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i
Rusty Weaver [EMAIL PROTECTED] wrote:
After upgrading from to 4.0.18 I can no longer access my innodb tables
created under 3.23. I get these errors:
% mysql -uroot db0
...
Didn't find any fields in table 'Employees'
...
My database files and .frm files are all present and readable.
Hello,
how can I prevent users from creating databases with the type MEMORY
(also known as HEAP)?
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael Stassen wrote:
SELECT init FROM inits GROUP BY init ORDER BY init;
+--+
| init |
+--+
| A|
| B|
| C|
...
| X|
| Y|
| Z|
+--+
26 rows in set (0.39 sec)
SELECT init FROM inits GROUP BY init ORDER BY init DESC;
+--+
| init |
+--+
| Z|
| Y|
|
Hi,
We are looking into migrating our application from oracle to mysql.
Almost every migration issue we've hit could be solved except for this one.
In one of our oracle tables, we've got a column with a timestamp datatype.
select * from (select to_char(ts_action, 'MM/DD/ HH24:MI:SS.FF3')
from
Chris,
Create a username and password in MySQL that has privileges for the database
in question (if it isn't there, create a new database and assign this user
access) then you will know them. :)
Kev
-Original Message-
From: Chris lemon [mailto:[EMAIL PROTECTED]
Sent: 23 June 2004 17:25
Hello:
I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1,
mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9.
When mysql starts, there is just listening one mysql-daemon.
When I had this configuration running in Redhat 7.3, mysql started 4
daemons.
Could someone explain me this
Heyho folks,
Is there any chance that mySQL uses an index and not filesort if I do the
following :
select count(*)as cnt from table where ... group by id having cnt(*) 2 order
by cnt
The Problem here is the order by clause - everything else is easy and clear (
and fast ) but as soon as
I
thx thx :D
thats work right.
the only problem is that mysqldump dont write the 'set FOREIGN_KEY_CHECKS'
sentences until version 4.1.1:
To make it easier to reload dump files for tables that have foreign key
relationships, mysqldump automatically includes a statement in the dump
output to
It seems like all of the questions in the past regarding Unicode have
been of the form: Does MySQL support it? I can see that it does, but
I was wondering if anyone could point me to an example of an INSERT or
an UPDATE on a string that is encoded using Unicode so I can see
exactly how the
Hi,
I have spent the last two days trying to configure PHP 4.3.7 MySQL 4.0.20 - none of
which is successful.
The error I have on MySql is when I go to set the root password I am told
connect to server at 'localhost' failed
error can't connect to MySql server on localhost 10061
check that
I answered this same question from you several days ago.
It is Redhat's ps that changed, not MySQL
Oscar Hernández Hernández wrote:
Hello:
I have just installed a Linux RHAS 3.0 with mysql-3.23.58-1,
mysql-devel-3.23.58-1 and mysql-server-3.23.58-1.9.
When mysql starts, there is just listening
Hi Bug Team,
I have set up a Master Slave System with MySQL 4.0.20. I've done completing every task
from 6.4 How to Set Up Replication.
But my problem is :
040624 14:44:44 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'FIRST' at position 4
Is the MySQL server running? What OS are you using?
-Original Message-
From: Angela Howley
To: [EMAIL PROTECTED]
Sent: 6/24/04 7:13 AM
Subject: connection error
Hi,
I have spent the last two days trying to configure PHP 4.3.7 MySQL
4.0.20 - none of which is successful.
The error I
The simplest thing to do is set up a replication slave and run a script
every night that shuts down the MySQL slave, performs the backup, and
then restarts MySQL. We have a dedicated XServe running MySQL and we
use another XServe whose primary function is filesharing to also act as
a
that is just what we want to do..
but it isnt The simplest thing to do as you say
:P
i am studying this:
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
thx another time
d2clon
On Thursday 24 June 2004 15:22, Kieran Kelleher wrote:
The simplest thing to do is set up a replication
hi
i´m trying to run a local mysql version under w2000.
when calling winmysqladmin.exe file the following error message appears:
the dll libmysql.dll is not found.
what can i do ?
thx. for any help
till
arge web52 -
webdesign, webhosting, online-datenbanken, pressebüro |
tillmann
22 quatloos for you!
Yeah, in retrospect, I imagine Dan's on the money: the seek
time is where the money's at. Thanks for the feedback, all!
Eamon Daly
- Original Message -
From: Frank Bax [EMAIL PROTECTED]
To: [EMAIL
If you are reading from a myisam variable length row table the table
handler actually
reads the entire row from disk regardless of the columns you choose. I
would say store them in separate columns so you can use those in other
parts of your queries (where statement ect) Also you don't incur the
Hi,
I have the following table structure:
tbl_speakers
sid
fname
lname
tbl_presentations
pid
name
desc
tbl_speakers_presentations
sid
pid
I would like to display all presentations, (but each only once), and
display the speakers'
I have a table where one field is a long list of numbers in comma-delimited
format.
I need to do a query like:
SELECT *
FROMTable
WHERE [number] IN list
If I cut and paste the actual list in it works fine but when I use the
column-name containing the list it returns nothing. I've
But unix timestamp doesn't support milliseconds either. You could
store the timestamp in one column and the milliseconds in an extra
smallint column. Then combine the two on output.
-Eric
On Thu, 24 Jun 2004 12:25:19 +0200, Gianpaolo Fasoli
[EMAIL PROTECTED] wrote:
Hi,
We are looking into
Have you looked at the GROUP_CONCAT() function?
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
It returns a string result with the concatenated values from a group. If
you didn't do this you would end up with a ragged-right data set that is
just a nightmare to manage with SQL. In one
I had an interesting situation to deal with this morning. The server that
runs our production version of MySQL crashed with some type of kernel error
(Win2K). When the server was brought back up, MySQL which runs as a service
was not running when I checked on it this morning. I could not restart
I would like to upgrade my mysql server on Solaris from version 3.22 to
version 3.23. I can find a lot of good information in the docs and
online about doing a new installation, but I can find next to nothing
that specifically addresses the steps to take to upgrade. Everyone I've
talked to
On Thursday 24 June 2004 10:20 am, Dirk Bremer \(NISC\) wrote:
1. Is there a way to configure the server to just support MyISAM databases,
i.e. disabling the support for InnoDB? My though is that this would prevent
the same error from happening again.
Put skip-innodb in your my.conf
2. I
Jochem van Dieten wrote:
Michael Stassen wrote:
SELECT init FROM inits GROUP BY init ORDER BY init;
+--+
| init |
+--+
| A|
| B|
| C|
...
| X|
| Y|
| Z|
+--+
26 rows in set (0.39 sec)
SELECT init FROM inits GROUP BY init ORDER BY init DESC;
+--+
| init |
The location depends on the name of the file
my.cnf will go in C:\
and my.ini will go in C:\winnt or C:\windows
-Original Message-
From: James E Hicks III
To: Dirk Bremer (NISC); [EMAIL PROTECTED]
Sent: 6/24/04 10:57 AM
Subject: Re: Server Down/General Server Questions
On Thursday 24
You probably shouldn't have setup your database structure like that.
You should always break out multiple values into a separate table, each
value being stored in one record, then link them through a common
record id. A one to many relation.
As far as the database is concerned, those aren't
I believe you could do:
SELECT *
FROM Table
WHERE FIND_IN_SET(number, comma_delimited_field)
but this will be /very/ slow. This query is forced to
examine each and every row to determine whether or not your
number is in the field.
The better solution is to break up that field, which is
At 10:56 AM 6/24/04, Matthias Kritz wrote:
I have the following table structure:
tbl_speakers
sid
fname
lname
tbl_presentations
pid
name
desc
tbl_speakers_presentations
sid
pid
I would like to display all presentations, (but each only
I understand how these lists come into existence (trust me I have had to
deal with enough of them). However, it is standard practice when working
with _relational_ databases to split those lists of numbers into unique
record pairs in a separate table. Your original source data was not
relational,
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
want to create a special account that has the minimum required rights.
In searching the docs I don't find this listed.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 24 June 2004 12:15 pm, Jim Shea wrote:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
want to create a special account that has the minimum required
Shawn,
Thank you for your reply.
That would have been an elegant solution but unfotunately Im not running
4.1 yet, which is required for GROUP_CONCAT() (no chance of an upgrade
either).
Is there a possibility of running perhaps two queries, one nested within
the other? This way I could pull out
Jim Shea wrote:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security
I want to create a special account that has the minimum required
rights. In searching the docs I don't find this listed.
Setup a .my.cnf file that
In the last episode (Jun 24), Jim Shea said:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available
privileges and
Matthias,
That would have been an elegant solution but unfotunately Im not running
4.1 yet, which is required for GROUP_CONCAT() (no chance of an upgrade
We still don't know which version you're using,
but have a look at
http://www.codeproject.com/Purgatory/mygroupconcat.asp
It worked for me
Does mysql support remote procedure calls or DRDA? I have partitioned
my database between multiple servers and need to join two tables from
two different servers (mysql instances) and I am wondering what the
best method for doing this would be. Any help would be greatly
appreciated!
Thanks
Hi all,
I need a boolean column and at to this time I always used ENUM('Y','N')
for this. I'am wondering that will there be a performance difference between
using ENUM('Y','N') and TINYINT(1) or BOOLEAN?. And put 0 or 1 to TINYINT
column.
Best Regards,
Cemal Dalar a.k.a Jimmy
System
I understand why we would want these to be in relational forms but in this
situation it isn't practical for a number of reasons. Normally that would
be what I would do.
However in this case the nature of the application is such that doing this
would cause an enormous load on the system as we
In the last episode (Jun 24), Donna Croland said:
Does mysql support remote procedure calls or DRDA? I have partitioned
my database between multiple servers and need to join two tables from
two different servers (mysql instances) and I am wondering what the
best method for doing this would
I have just documented how I set it up a new slave last week to
replicate against an existing master and it was really easier than I
expected. It works like a charm so far. Here is the instructions
http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
I hope this helps
Log into the slave and do this command
mysql mysql show slave status\G
. what do you see?
Also, what is in your my.cnf file on the slave?
FYI, here is instructions on how I set up replication last week
http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
-Kieran
Hi,
A quick mysql database question (using innodb) and connection with java.
If someone locks the table with write, can we set
a timeout when we are doing a query on that table, so that that it will
timeout
and throw an exception after say 60 seconds, rather than block ?
/Frank
--
MySQL
Dan Nelson wrote:
In the last episode (Jun 24), Jim Shea said:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available
privileges and
I guess you are stuck building your list with application code, then. You
won't have to run a nested query. That would just overwork your server. You
can do it with a single query and a fairly quick piece of code. I have had
to write this routine at another job but not with PHP so please forgive
Howdy all. If this isn't the right listserv for this
question, my appologies.
What I'd like to do is set up a graph under the
Health section of the mysql administrator so that I
can easliy keep tabs on the INNODB Buffer pool.
The problem is that I don't know which variables to
use to calculate
Does mysql 4 require file locking? I'm not talking about in the
database -- I know how to lock and unlock tables for data consistency.
I'm referring to the filesystem that the data lives on.
For reasons too boring to go in to, I have a mysql server and I'm keeping
the database files (i.e., the
Hello.
My question concerns a large data table that has a DATETIME column
called dt. Specifically, I am often having to do selects based on date
and time functions that look like this:
select * from my_table where hour(dt)= 0
or
select * from my_table where month(dt) = 6
What index should I
I think you are stuck. I can't think of any way to create an index on just
a piece of a column's data. I believe you need to create separate columns
of data for each portion of the date you want to search and index those.
That could mean up to 6 additional columns of data for your table,
chastang wrote:
select * from my_table where hour(dt)= 0
or
select * from my_table where month(dt) = 6
What index should I create to optimize selects on these sorts of queries?
An index isn't going to help you there unless you create separate
columns for hour and month. The columns will be
I'm installing mysql 4.0 on Linux x86
The application for which I'm using mysql requires support for splitting a table
across multiple OS files. On the mysql website I read that this can be done with
InnoDB storage engine. Does mysql 4.0 Standard version (which includes InnoDB) have
this
At 03:49 PM 6/24/2004, you wrote:
Hello.
My question concerns a large data table that has a DATETIME column called
dt. Specifically, I am often having to do selects based on date and time
functions that look like this:
select * from my_table where hour(dt)= 0
or
select * from my_table where
The standard MySQL distribution comes with InnoDB support. You can also
split tables into up to 255 blocks using MyISAMs RAID support.
Cheers
Andrew.
- Original Message -
From: Rahul Sood [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 10:14 PM
Subject: table
Another option depending on your needs would be the MERGE table type.
-Eric
On Thu, 24 Jun 2004 22:21:58 +0100, Andrew Pattison
[EMAIL PROTECTED] wrote:
The standard MySQL distribution comes with InnoDB support. You can also
split tables into up to 255 blocks using MyISAMs RAID support.
MySQL itself doesn't require file locking. Infact there is an option
to turn it off. --skip-external-locking that disables using the
flock() system call. Just watch out
that you don't accidently start two mysqlds on the same datadir.
-Eric
On 24 Jun 2004 13:42:33 -0700, Shelly Zhang
[EMAIL
Hello,
I'm working on a project where I must export to a text file and the text
file needs to be formed into columns so that it can be imported into a
WORD mail merge document.
So, the format of the output file has to have the headers for each
column and the lines must have a CR at the end of
well,
you can easily output into a comma separated file but the INTO OUTFILE option will not
allow you to retain the headers. You will need to build the logic into a perl script
or language of your choice to get the headers there. Sounds like your fields records
are all on one line becausing
Hi - I need some help :)
I set up a simple mysql table:
mysql describe ip2org;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| ip_start | bigint(20) | |
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
[]s,
Sergio Salvi.
On Thu, 24 Jun 2004, MerchantSense wrote:
Hi - I need some help :)
I set up a simple
Seems ok to me...
It seems to be checking all the rows in the explain for some reason too...
mysql show index from ip2org;
+++--+--+-+---+-
+--++-+
| Table | Non_unique | Key_name | Seq_in_index |
On Thu, 24 Jun 2004, MerchantSense wrote:
Seems ok to me...
It seems to be checking all the rows in the explain for some reason too...
mysql show index from ip2org;
+++--+--+-+---+-
+--++-+
|
I added the multicolumn, and still have the same problem :
mysql explain SELECT org from ip2org where ip_start=1094799892 and
ip_end=1094799892;
++--+---+--+-+--+-+-
---+
| table | type | possible_keys | key | key_len | ref | rows|
We are in the process of setting up a new MySQL server. It's a
dual-Opteron (Tyan Thunder K8S motherboard) with 6 gig of DDR333 RAM
(registered) and an LSI SCSI card with 6 SCSI drives (5 in a RAID-5
array, with one hot-spare) running SuSE Enterprise 8.1 (64-bit).
I loaded all our data (about
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part of a multi-field index. From the manual
Yes, but I now have multi-column indexes, but still have the problem
It's not using the indexes at all... very strange - some sort of bug?
Look at this:
mysql explain SELECT org from ip2org use key (ip_start,ip_end) where
ip_start=1094799892 and ip_end=1094799892;
Re: Master Slave Problem :
mysql show slave status\G
*** 1. row ***
Master_Host: 164.23.43.160
Master_User: Replikator
Master_Port: 3306
Connect_retry: 60
Master_Log_File:
Read_Master_Log_Pos: 1934
On Fri, 25 Jun 2004, Michael Stassen wrote:
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part of a
On Thu, 24 Jun 2004, MerchantSense wrote:
Yes, but I now have multi-column indexes, but still have the problem
It's not using the indexes at all... very strange - some sort of bug?
Look at this:
mysql explain SELECT org from ip2org use key (ip_start,ip_end) where
ip_start=1094799892
Yep, that's exactly what I did
-Original Message-
From: Sergio Salvi [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 10:55 PM
To: [EMAIL PROTECTED]
Subject: RE: strange table speed issue
On Thu, 24 Jun 2004, MerchantSense wrote:
Yes, but I now have multi-column indexes,
74 matches
Mail list logo