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
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
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
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
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 |
(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
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
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,
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
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
INSERT and
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 person
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
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!
--
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! Reason for
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]
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
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
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
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
[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
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 that are strings were
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. After looking at the file I
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.
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
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 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
--
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]
mos wrote:
Another user privately e-mailed me the errors of my ways.g
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 t1 left join table2
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
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
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 SQL
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]
--
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...).
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
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:
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
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 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
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
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
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
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
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
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
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,
45 matches
Mail list logo