Hi all,
I get a very strange error from a join in Mantis and this started after I
upgraded from Mysql4 to Mysql5. I know there were some changes regarding the
joins but this error doesn't say anything about the join.
The select is this:
SELECT f.name,
f.type, f.access_level_r, f.default_value, f
Hi all
Problem description
OS: Solaris 9
Mysql: 4.1.8
I have two configuration database for my application and I need to have some
tables with same data and some tables with different data. I solve this problem
with symbolic linked tables (for MYI and MYD files). Periodically I get error
me
P. Evans wrote:
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
Can you please show us the CREATE TABLE command that you are using?
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
I've also tried alterring the table to change the engine , which says it
complet
This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app server
& database server running on the same box. I'm using the Tomcat Database
Connection Pool to get a JDBC connection and insert the data. I dont have
too much free disk space on this machine (approx 2GB). At the time of the
in
Aru,
Gleb is right. Best to upgrade to 4.0 or 4.1. In those versions InnoDB will
print the operating system error number and better diagnostics of the error.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Whil Hentzen wrote:
> Hi folks,
>
> I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
> following
Hello.
I don't see any attempts from InnoDB to recover the data, so
it is crashing before the recovering. To save your data, if you're
unable to get tables with mysqldump, this might be helpful:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
> MySQL 3.2.3 installed in o
Hello.
As others suggest send the 'CREATE' statement for your table, and,
please, include the output of :
'show status';
'show variables';
> How long should it take to insert approx 30,000 rows into MySQL. It
> takes me
> about 30 mins. I'm using version 4.1.10-nt. Any ideas?
Hello.
>I do have my data
Check if yum has cleared the data directory, if not, you should be
able to recover the data.
>Can I install mysql 5, and it will migrate/work with my existing data?
In my opinion it is a good idea, but be aware of compatibility issues
for your applications wh
onsdagen den 9 november 2005 18:07 skrev Burke, Dan:
> For example, one field has to be >= 0, so I put this validation
Why don't you just declare that field as unsigned?
Björn Persson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
That seems like a long time. Although I don't know how much data you
are importing, how many indexes you have on the database, memory,
etc. How you are going about importing can affect your speed
dramatically. If you are importing a tab delimited (or other
delimination) file, you should get
I'm using the MySQL .Net connector to access my MySQL database from my
ASP.Net application. I've got kind of a catch 22 thing going on here. I'm
getting an error, which indicates that I need to set the debug="true" in my
web.config file (I realize this isn't a MySQL problem, but bare with me...).
> How long should it take to insert approx 30,000 rows into MySQL.
Depends on the data and field structure. Do you have lots of indexes
on the table?
>It takes me about 30 mins.
There are some tips at http://dev.mysql.com/doc/refman/4.1/en/insert-speed.html
--
Scott Noyes
[EMAIL PROTECTED]
--
> Access MEMO is actually closer to LONGTEXT than to BLOB.
>
> Blob stands for Binary Large OBject.
No it doesn't ... Ok, it does now :-)
http://www.cvalde.net/misc/blob_true_history.htm
;-)
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS S
Access MEMO is actually closer to LONGTEXT than to BLOB.
Blob stands for Binary Large OBject.
Although you can use BLOB, depending on what you are inserting, it is
recommended that you use LONGTEXT for your memo field.
J.R.
http://dev.mysql.com/doc/refman/5.0/en/blob.html
-Original Messag
I'm a bit new to MySQL. I need to create a Memo field (a field that could
contain a lot of information). I know that in some languages, BLOB is a
Memo field. Is that the case with MySQL? If so, are there some parameters
that I need to use here, or should I use another type to represent my Memo
mos wrote:
> Another user privately e-mailed me the errors of my ways.
>
> Here is the problem (returns 0 rows):
>
>> > select * from table1 t1 left join table2 t2 on
>> > t1.date1=t2.date2 where
>> > t2.date2 is null
>> > where t2.name='Smith'
>
>
> Here is the solution:
>
> select * from table1
--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The passage you quoted is so vague that it should be removed or rewritten.
The type of query that the OP wants to write is more than likely one of
those "exceptions" discussed as an afterthought. That makes your warning
inaccurate, doesn't it.
There are many valid reasons for putting conditions
It appears mysql recommends against the solution given
to you
http://dev.mysql.com/doc/refman/5.0/en/join.html
You should generally not have any conditions in the
ON part that are used to restrict which rows you want
in the result set, but rather specify these conditions
in the WHERE clause. The
How long should it take to insert approx 30,000 rows into MySQL. It takes me
about 30 mins. I'm using version 4.1.10-nt. Any ideas?
Thanks,
Dhiren
MySQL 3.2.3 installed in our server suddenly started giving problem after
restarting the server m/c.
/etc/init.d/mysqld status sys,
mysqld dead but subsys locked
Checked the log file and found that there is some Assertion failure for InnoDB,
can you pls. provide a possible solution for this.
Quoting Richard Lynch <[EMAIL PROTECTED]>:
> On Wed, November 9, 2005 11:05 am, Chris W wrote:
> > Richard Lynch wrote:
> >
> >>On Sun, November 6, 2005 2:17 am, Chris W wrote:
> >>
> >>
> >>>I just tried to use the output of the export function on phpmyadmin
> >>>and
> >>>got a million errors. A
On Wed, November 9, 2005 11:05 am, Chris W wrote:
> Richard Lynch wrote:
>
>>On Sun, November 6, 2005 2:17 am, Chris W wrote:
>>
>>
>>>I just tried to use the output of the export function on phpmyadmin
>>>and
>>>got a million errors. After looking at the file I found that
>>> certain
>>>columns t
[EMAIL PROTECTED] wrote:
Jacques Brignon <[EMAIL PROTECTED]> wrote on 11/09/2005 09:58:07 AM:
I have a query which scans a subscription database to locate the most recent
expiration date of the subscription to a given periodical or service to compute
the start date of a renewal.
It works fine wh
I see what you're saying. That won't really help, because I'll still be
duplicating changes in the update and insert triggers every time I add a
new field. The hope was that I would only need to do it once. Your
method sounds like it could become costly from an execution time
perspective if a
Try this
{I wasn't sure whether cd_nature_ltr is in ligne_trans
or transaction. This assumes ligne_trans. If it is in
transaction thatn move "cd_nature_ltrsn = 2" into the ON clause.}
SELECT CASE id_ltrsn
WHEN NULL THEN 0
ELSE id_ltsrn
END AS id_ltrsn,
CASE
Hi Melanie,
Thanks for the explanation, I will try the SET NAMES to export my XML
file in utf8 (I actually want it to be in utf8)
I'm sorry if this is a basic question, but as I said before I'm kind of
lost with the encodings
I asked almost the same here about a week ago, so I don't think
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i
mean if i want to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes
At 22:38 -0500 11/8/05, [EMAIL PROTECTED] wrote:
There can also be a [mysql] section that will apply to all applications
that read the my.cnf file. It is sort of the "default" section.
Eh?
The [mysql] section applies to the mysql client program and not
to anything else.
[mysql]
socket=/tmp/
In article <[EMAIL PROTECTED]>,
Jacques Brignon <[EMAIL PROTECTED]> writes:
> Thanks, that makes a lot of sense.
> My only problem is that I am using here a standard piece of code on the
> application side and I would hate to modify it, the thing I have all liberty
> to
> change is the query! Rea
Thanks, that makes a lot of sense.
My only problem is that I am using here a standard piece of code on the
application side and I would hate to modify it, the thing I have all liberty to
change is the query! Reason for trying to ask the query itself to tell me if
there is nothing in the DB!
--
Ja
At 09:54 PM 11/8/2005, David Turner wrote:
If you could present sample data of both table1,
table2, and an example of the result set it would be
easier to give you the sql. I believe you could
eliminate the temporary table with a subselect in the
original query. The subselect is where you would
s
Jacques Brignon <[EMAIL PROTECTED]> wrote on 11/09/2005 09:58:07 AM:
> I have a query which scans a subscription databse to locte the most
recent
> expiration date of the subscription to a given periodical or serviceto
compute
> the start date of a renewal.
>
> It works fine when for a given pe
"Burke, Dan" <[EMAIL PROTECTED]> wrote on 11/09/2005 09:05:50 AM:
> Hello,
>
> Can triggers in 5.0 handle multiple events? I have some range checking
> I'd like to enforce at the database level when inserting or updating a
> record, and I'm finding myself duplicating trigger code to make an
> IN
I have a query which scans a subscription databse to locte the most recent
expiration date of the subscription to a given periodical or service to compute
the start date of a renewal.
It works fine when for a given person such a subscription exists. If none
exists, as expected the query produces n
Hello,
Can triggers in 5.0 handle multiple events? I have some range checking
I'd like to enforce at the database level when inserting or updating a
record, and I'm finding myself duplicating trigger code to make an
INSERT and an UPDATE trigger, which makes it harder to maintain in the
long run,
As seen in manual there's no exact data type for your kind of data:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
see also:
http://dev.mysql.com/doc/refman/5.0/en/column-types.html
so you can:
1. Use 1 timestamp column and 1 INT column just for milliseconds
2. Use BIGINT
> (nevertheless i dunno what
> i shall do with 3 instances of mysql on my workstation lol).
I have 3 instances running on one workstation, and I could really do
with 4. I have 4.1.7 because that's what we want to move our product
to use, 5.0.15 so I can play with new features like stored procedur
Hi,
I have a master and a slave mysql server. On the master I write binlogs
needed for replication. From time to time I have chronological
auto_increment problems, here's a short explanation.
- the table structure :
| Field | Type| Null | Key | Default | Extra |
+---+--
Hi András,
Thanks for the explanation, I will try the SET NAMES to export my XML file
in utf8 (I actually want it to be in utf8)
I'm sorry if this is a basic question, but as I said before I'm kind of lost
with the encodings
From what you tell me, if the client utf8 send data to mysql isolat
Hi all
I got it - just found another posting that briefly explains how it's done. I
gave it a quick try on my workstation and i works (nevertheless i dunno what
i shall do with 3 instances of mysql on my workstation lol).
http://lists.mysql.com/mysql/115628
Cheers
-Frank
> -Original Message
I guess you should be able to run multiple instances if you start each
instance on a different port.
sujay
-Original Message-
From: Frank Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 2:17 PM
To: mysql@lists.mysql.com
Subject: Multiple MySQL services running on t
Hi all
i just read some postings related whether it is possible to run multiple
services of mysql on windows. One posting states, that is's not possible,
another states that is can be done using mysqld-nt for the first instance
and mysql-nt-max for the second instance and a third posting states t
45 matches
Mail list logo
