Perhaps you could try MySQL Migration Toolkit
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
still beta though...
NB!
ATTENTION: Before installing the MySQL Migration Toolkit please download
and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from
http://java.sun.com
I have two configuration database for my application and I need to have some
tables with same data and some tables with different data.
Jasper Bryant-Greene wrote:
Vlad Shalnev wrote:
Periodically I get error message can't get stat of xxx.MYD for
tables that are symbolic link to tables on
Hello there,
I have a question regarding the possibility of creating a string from a
resultset directly using an SQL command. I'm not sure if this is possible.
Here is what I have:
A table with links between articles and category in a catalog.
For ArticleID #1, I have say 3 categories, and I
Jasper Bryant-Greene wrote:
Vlad Shalnev wrote:
Periodically I get error message can't get stat of xxx.MYD for
tables that are symbolic link to tables on different database on
the same file system. Error disappear after executing flush
tables.
Why are you doing this? You can access tables
Henri-Maxime Ducoulombier wrote:
I have a question regarding the possibility of creating a string from a
resultset directly using an SQL command. I'm not sure if this is possible.
Here is what I have:
A table with links between articles and category in a catalog.
For ArticleID #1, I have say 3
Hi Gleb,
I am sorry i forgot to metion the storage engine we are using, its innodb.
The below option is only for myisam engine.
Innodb stores data and index in the same file as per documentation.
Can you please correct me if i am wrong.
regards
anandkl
On 9/15/05, Gleb Paharenko [EMAIL
Hi James,
You can do this
show engine innodb status\G ---this will show how many
insert/deletes/updates/reads happening per second and also how much of
Buffer is being used and how many queries are currently running and how many
are in queue.
show processlist---This will give the list of SQL
Hola,
Tengo una base de datos realizada con MySQL y desearía generar informes
mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10
me sale el siguiente error:
Logon Failed
Details: ADO error Code 0x8000fff
Source: Provider
Description: Error catastrófico
Native Error:
Take a look at the GROUP_CONCAT function, under functions for use with
GROUP BY clauses in the MySQL manual. You'll need MySQL 4.1+ AFAIK.
Thanks a lot Jasper, that is EXACTLY what I was looking for !
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I'm sure I read somewhere about a new function that would give the
totals of all columns, ie if i have 2 cols, numberOfOrders valueOfOrders
for a range of dates i can get something like the following
Date numberOfOrdersvalueOfOrders
01-09 4 20.00
02-09 6
You can achieve this with the WITH ROLLUP option of GROUP BY. Although you
would probably have to perform a trick on the date column to have the NULL
value that WITH ROLLUP would return to return as total - i.e
IFNULL(date,'Total') as a quick (and dirty) example, as this doesn't work
too well on
Vicente [EMAIL PROTECTED] wrote on 09/16/2005 07:45:22 AM:
Hola,
Tengo una base de datos realizada con MySQL y desearía generar informes
mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC
3.51.10
me sale el siguiente error:
Logon Failed
Details: ADO error Code 0x8000fff
You may want to think about doing this the opposite way around also, and
look at pushing the data from Oracle in to MySQL. Oracle has something
called heterogeneous services, which allows you to define ODBC datasources
as valid entries in the tnsnames.ora file. Then you could simply create a
job
I have a web site that have 100unique users online at the same time. I will
optimize DB structure.
1. Is there anysource about mysql optimization and performance tricks?
2. I can change the DB type, which is the best for high mysql traffic web
sites, innoDB or MyIsam?
Thanks
2005/9/16, OKAN ARI [EMAIL PROTECTED]:
I have a web site that have 100unique users online at the same time. I will
optimize DB structure.
1. Is there anysource about mysql optimization and performance tricks?
you might want to look here :
http://dev.mysql.com/doc/mysql/en/query-speed.html
All,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
application using ColdFusion with Oracle. Now I like
to point my application to mysql database. How do I
fix my application to work with Mysql?
Thankyou
Hi,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
oracle sql plus is a client side application to execute SQL statements.
oracle sql is Oracles version of standard SQL (which is not standard)
and mysql sql is MySQLs version of standard
Hi,
always reply to the list, you'll get better answers.
2005/9/16, OKAN ARI [EMAIL PROTECTED]:
My actual DB isoptimized well about field types. I am using tinyint If i
need etc;)
But my problem is about examining logs, because
1. I dont' want to know how to reach mysql logs? Can you
Phong Nguyen [EMAIL PROTECTED] wrote on 09/15/2005 10:56:57 AM:
All,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
application using ColdFusion with Oracle. Now I like
to point my application to mysql database. How do I
fix my
On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone use circular replication with MySQL 4.x? For instance:
A to B
B to A
I know it's possible as long as you're carefull with your client
applications and the way they write/update the db. Just wondering if
anyone has had success or problems with this type of situation.
Thanks,
In the last episode (Sep 16), Jeff said:
Does anyone use circular replication with MySQL 4.x? For instance:
A to B
B to A
I know it's possible as long as you're carefull with your client
applications and the way they write/update the db. Just wondering if
anyone has had success or
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:34
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
In the last episode (Sep 16), Jeff said:
Does anyone use circular replication with MySQL 4.x? For
I'm using it with four machines (geographically separate) and it works fine.
Stefan
Am Friday 16 September 2005 17:31 schrieb Jeff:
Does anyone use circular replication with MySQL 4.x? For instance:
A to B
B to A
I know it's possible as long as you're carefull with your client
Jeff wrote:
Am I correct in this setup process:
Server A exists
Server B to be built
Stop Server A, take snapshot, record Master info.
Start Server A
Setup server B, Install snapshot from A
Set B up as a master
Set B up as a slave to A
Set A up as a slave to B, no need for binlog file or
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Jeff wrote:
Am I correct in this setup process:
Server A exists
Server B to be built
Stop
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I realize there are a billion different
Brian Dunning wrote:
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I'm a programmer, not a
Hi all,
Im researching switching a production database system to use UUID's instead of
AUTO_INCREMENT columns for various ids. I've looked at various MySQL
documentation, and it seems to be what i want.
This change will really affect 2 separate database servers. Both are using
InnoDB tables.
Jeff wrote:
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc:
On Fri, 16 Sep 2005 10:32:23 -0400
[EMAIL PROTECTED] wrote:
You asked basically two questions:
a) what are the differences between ORACLE SQL plus and MYSQL?
snip
depends on how they are with MySQL already. One well-known point on
how
MySQL and Oracle differ is in how to define a JOIN in
Wigs @Claw wrote:
Hi guys , sorry for responding if this message is a bit off topic!
Id have to say that you are assuming no glitches come into play with
that response.
I just recently had to do a Red Hat install , with Apache , MySQL and
the works. The install of Redhat ran into some
Hello.
For a pity in your case it won't help.
Hi Gleb,
I am sorry i forgot to metion the storage engine we are using, its
innodb. The below option is only for myisam engine.
Innodb stores data and index in the same file as per documentation.
Can you please correct me if i am
Privet!
Usually there is a number in the brackets after an error message. What
is this number?
Vlad Shalnev [EMAIL PROTECTED] wrote:
Hi all
Problem description
OS: Solaris 9
Mysql: 4.1.8
Periodically I get error message can't get stat of xxx.MYD for tables that
Hello.
Tools like mytop or mysqladmin (with -r option) don't produce
a high load on the server. You might be interested in --sleep option
for mysqladmin and --delay for mytop.
James Black [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We have a production
Hello.
What is SHOW PROCESSLIST reporting when the server is reaching the
max_connections limit?
Kishore Jalleda [EMAIL PROTECTED] wrote:
Hi All,
Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17,
I upgraded the slave a week ago and the replication was
Hello.
My $0.05 :)
If you find out the unique queries (they often contain date and time),
add SQL_NO_CACHE to SELECT statement - this will decrease the number
of inserts of unique queries.
Brent Baisley [EMAIL PROTECTED] wrote:
You tripled the amount of memory assigned to the
I need to do an import of mysql data that I dumped from an older mysql server
the older server is running version 4.1.8 official mysql rpm. The new server
is running the version of mysql that comes with Fedora Core 3. The problem Im
having is with the Charsets that are in the older version. Is
I don't know if this is relevant to you - but I had exactly
the same experience when upgrading to MySQL v4.1. It turned out
that MySQL was trying to do reverse DNS lookups before authenticating
the connecting hosts - and was failing slowly on each because the database
machine didn't have external
Hi,
Unfortunately I dint check SHOW PROCESSLIST as I was overwhelmed with the
state of the server and had to bring back the old version online, but the
reverse DNS lookups could be the reason, but surprisingly it was infact
serving some client requests
, also is there a way to stop mysql from
41 matches
Mail list logo
