Hi,
I'm a newbie working on a big project. The idea is to
transport an existing Oracle database at
http://www.ebi.ac.uk/arrayexpress/ to a local MySQL
server. The Schema, scripts and loader for Oracle can
be found in the website. But how to create an exactly
same database with mySQL? I have no
look at http://www.ispirer.com
it provides a tool SQLWays, which is a migrating tool
to migrate any DataBase to MySQL with Data.
greets,
Arun.
--- Claire Lee [EMAIL PROTECTED] wrote: Hi,
I'm a newbie working on a big project. The idea is to
transport an existing Oracle database at
On Wednesday 28 January 2004 06:00, Scott Haneda wrote:
I have done this so many times..
SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) 7
I have scoured (more like glanced :-)) at the docs on
http://www.mysql.com/doc/en/Date_and_time_functions.html and can not seem
to
on 01/28/2004 12:03 AM, Duncan Hill at [EMAIL PROTECTED] wrote:
On Wednesday 28 January 2004 06:00, Scott Haneda wrote:
I have done this so many times..
SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) 7
I have scoured (more like glanced :-)) at the docs on
Hi,
I'm newbie in MYSQL. Would please tell me about Mysql Security ?
Generally you can find a lot of information about MySQL on
http://www.mysql.com/doc/en/
About your question you can read here:
http://www.mysql.com/doc/en/Privilege_system.html
Mikhail.
- Original Message -
From:
Timotius Alfa [EMAIL PROTECTED] wrote:
Hi All,
I'm newbie in MYSQL. Would please tell me about Mysql Security ?
I used Windows2000 for mysql server.
Privilege system of MySQL is described in the following section of the manual:
Hi out there,
i´m using InnoDB with foreign key constraints and i´m looking for the
default behavior of ON DELETE and ON UPDATE.
Secondly, what does the ON UPDATE NO ACTION option means? Ist the way it is
used in db2, that every child row must have some matching parent row. If
this condition
I need help (ASAP).
I'm using MySQL (4.0.15) with InnoDB.
QUESTION:
How can I check (or monitor) the available space in my InnoDB data files ???
my.cnf:
...
innodb_data_file_path=ibdata1:650M;ibdata2:650M
...
_
STOP MORE SPAM with
Hi,
show table status;
In the last field (Comment) you could find it.
Mikhail.
- Original Message -
From: Tile Tatonko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 10:48 AM
Subject: available spaci in InnoDB data files !??!
I need help (ASAP).
I'm
Say I have the following table (TBL):
KEY GRP VAL
1 A 2
2 A 3
3 A 1
4 B 2
5 B 1
6 B 3
select KEY, max(VAL) from TBL group by GRP gives:
KEY max(VAL)
1 3
4 3
the desired result though is:
KEY max(VAL)
2 3
6 3
any ideas on how to achieve this ?
Hi,
I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m'
AND hobby_id='3'
AND id IN ( $value );
$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.
It might be about 10,000 id in $value. What is the maximum value
From: Batara Kesuma [EMAIL PROTECTED]
It might be about 10,000 id in $value. What is the maximum value I can
pass in a query? Is this the right way to do it? (I mean, using a very
big value inside IN)
WIth 10,000 items in an IN () condition, my guess is that the list is a
result of another
On 28-Jan-2004 Batara Kesuma wrote:
Hi,
I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m'
AND hobby_id='3'
AND id IN ( $value );
$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.
It might be
I just ran mysql 4.0.15 on a Mac for the first time and got the following in
my .err file:
InnoDB: a new database to be created!
040128 7:40:24 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040128 7:40:25 InnoDB: Log file
Hassan Shaikh [EMAIL PROTECTED] wrote:
Hi,
I want --ansi option for MySQL setting to ensure ANSI compatibility. Most shared
hosting providers don't allow access to my.cnf. Is there anyway to do this on the
fly in my script, PHP/Perl sample would be appreciated.
You can do it only from
sounds like I reinvented the wheel but here's how I did it:
1. reverse engineer Oracle database with ERWin
2. write a little perl program to map/convert column types and convert syntax
for alter table clauses
3. write a sqlplus script which dynamically creates a select/spool for a given
table
I have mysql 4.0.16 on my windows machine and have just installed suse
linux on another machine. It comes with mysql 4.0.15. After I got the
user setup I was able to use the mysql client on the windows machine to
connect to mysql on the linux machine I even used mysqldump piped to
mysql to
Hassan Shaikh [EMAIL PROTECTED] wrote:
Hi,
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
If you want to start auto_increment sequence with value bigger than current counter
value, you can
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use TRUNCATE.
Chris
--
MySQL General Mailing
I have been beating my head against the wall for a couple of days now and
cannot figure this out. I am hoping that it can be done.
I have two tables each with only one field.
Table 1 - emailAddress (this contains things like [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL
Hi,
I want to be able to show the total of the subtraction of the returned
date from the from date for each department for each month.
This to be done on a range of a year, and then when the next month comes
round for the calculation to take that month into account, so, shifting the
range to
* Lightware Software
Say I have the following table (TBL):
KEY GRP VAL
1 A 2
2 A 3
3 A 1
4 B 2
5 B 1
6 B 3
select KEY, max(VAL) from TBL group by GRP gives:
KEY max(VAL)
1 3
4 3
the desired result though is:
KEY max(VAL)
2 3
6 3
any
Kev [EMAIL PROTECTED] wrote:
I just ran mysql 4.0.15 on a Mac for the first time and got the following in
my .err file:
InnoDB: a new database to be created!
040128 7:40:24 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040128
Chris Boget [EMAIL PROTECTED] wrote:
How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
the method mentioned in the manual is not applicable. I am using MySQL
4.0.17.
Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use
In the MySQLdocumentation, it does not clearly explains how a Tablespace is
created. Under Creating a Tablespace heading ( 14.4.4), it says how a Innodb
database is created but not tablespace.
Also how exactly you create an Innodb Database. Well it says in the
Hi,
You can use TO_DAYS() and FROM_DAYS() functions for what you need.
All details about Time and Date functions :
http://www.mysql.com/doc/en/Date_and_time_functions.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION
In the MySQLdocumentation, it does not clearly explains how a Tablespace is
created. Under Creating a Tablespace heading ( 14.4.4), it says how a Innodb
database is created but not tablespace.
Also how exactly you create an Innodb Database. Well it says in the
documentation
Is there a way to check that data on slave server is the same as data on
master ?
Thanks
From: Paul DuBois [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: updates on slave server??
Date: Mon, 26 Jan 2004 21:58:42 -0600
At 0:49 + 1/27/04, Mike Mapsnac
Gitte und Ingolf [EMAIL PROTECTED] wrote:
Hi out there,
i.m using InnoDB with foreign key constraints and i.m looking for the
default behavior of ON DELETE and ON UPDATE.
Secondly, what does the ON UPDATE NO ACTION option means? Ist the way it is
used in db2, that every child row must have
Hi,
I have looked for answers on the net but havent managed to apply the
suggestions to my example; I would appreciate any help!
I have the following set up:
root_table (root_table_id, table_one_id, table_two_id, date)
table_one (table_one_id, col1)
table_two (table_two_id, col2)
I want to
Thanks for the reply,
I think SUM(DAYOFYEAR) has solved it. However is there a way of subtracting
weekends and showing departments even if they have no entries( ie to show
the dept and 0 as it's result)?
Cheers.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]
Sent: 28
I see that InnoDB hot backup can be used so that a running InnoDB
database can be backed up with out setting any locks.
Can any Open File backup tool be used with MySQL InnoDB tables or does
the hotbackup product do something special that others don't? What are
some of the things that I
I've had tens of thousands of items in an IN list without failure, but
it seems that when you get that many it takes a very long time to parse.
The speed thing bothers me, so I'm toying with a new design, but it's a
big enough system that it's slow going.
J
-Original Message-
From:
Bonjour Mauro,
MM I see that InnoDB hot backup can be used so that a running InnoDB
MM database can be backed up with out setting any locks.
MM Can any Open File backup tool be used with MySQL InnoDB tables or does
MM the hotbackup product do something special that others don't? What are
MM
Hi everyone,
Sorry to ask this question, because this is going to get complicated...
Okay - what I need to do is be able to search for data across multiple
fields which are organized in multiple tables. Here is a basic
description of my database schema (not quite all of the fields...):
Table
I'm not sure you can do that in a single select - one is a count, and the
other is a list. In fact, finding the count requires a sub-select, or two
seperate selects.
Not sure what your columns are, so I will assume that emailAddress has a
column called email, and domain has one called domain.
I don't think there would be any benefit to using InnoDB, at least not
from a transaction point of view
For the longest time I was reading the books and listening to the experts
and all I was hearing is InnoDB is great because it handles transactions.
Having little interest in transactions per
All,
I am trying to set lower_case_table_names to 1 in my RPM
Red Hat installation. I have added the following entry to my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
lower_case_table_names=1
However, once that mysqld starts, it dies
And if you have lots of $$$ to spend, Embarcadero (www.embarcadero.com) has
a tool called ERStudio, that can generate the Data Definition Language (DDL)
for MySQL from Oracle. Costs are pretty excessive.
We've purchased a SQLWays licence, and I've used it a fair bit - it's a
decent tool for data,
So should we always use InnoDB over BerkeleyBD? I was
under the impression Berkeley was faster and better at
handling transactions.
Dan
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: Memory
Mysqlians,
Greetings We have been experiencing a performance problem
that relates to either mysql's buffers of the ext3 file cache. Our
mysql servers are experiencing load spikes due to massive disk reads on
datadir( 3meg sec). Datadir is a seprate disk. Most of the day the disk
That works great! My head can take a rest now and the bruises hopefully
will heal.
Thanks,
-brandon
David Griffiths [EMAIL PROTECTED]
01/28/2004 12:05 PM
To
[EMAIL PROTECTED], [EMAIL PROTECTED]
cc
Subject
Re: comparing one field to another.
I'm not sure you can do that in a single
Hello,
I have a question that someone here may or may not be able to answer (I
think perhaps MySQL is incapable of a solution). I have a program which
uses a MySQL database to help create a playlist for a ShoutCast stream.
There is a web site associated with the web-radio. Users of the
Hi all,
There are other tools as well - besides being a GUI
front end to MySQL (and InterBase, Firebird and
MS SQL Server), Database Workbench offers migration
and cross database development tools. Check
www.upscene.com for more information.
look at http://www.ispirer.com
it provides a tool
As reported under the subject Random Database Slowdowns... on the win32 list, our
database still hangs
on an average of 1-2 times per day.
I can find no error messages or logs associated to the problem. It affects both IIS
ADO connections as well as local connections from tools such as mysqlcc,
Description:
MySQL 4.1.1-alpha (binary package from www.mysql.com)
does not accept negative number after DEFAULT.
How-To-Repeat:
mysql create table test (FileSize BIGINT NOT NULL DEFAULT -1);
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL
Hello,
I have a question that someone here may or may not be
able to answer (I
think perhaps MySQL is incapable of a solution). I have a
program which
uses a MySQL database to help create a playlist for a
ShoutCast stream.
There is a web site associated with the web-radio. Users
I discovered one more thing about this whole thing that does not make any
sense to me but I have been told I have to take into account.
Here is what I have
Email Table
emailAddr (field)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
On 1/28/04 10:29 AM, stairwaymail-mysql at yahoo dot com wrote:
So should we always use InnoDB over BerkeleyBD? I was
under the impression Berkeley was faster and better at
handling transactions.
Dan
Eermm... That's outside my scope of expertise, my experiences have been
exclusively with
After some research, I chose a dual Opteron MySQL server for my new search box. For
storage, I only update the tables once a day, so I plan on putting my data directory
on a Linux ramdrive and backing it up to the hard disk after each update for maximum
performance.
If anyone has any
Andy,
Does this scratch the itch?
select col1, col2, date
from root_table
left join table_one on root_table.table_one_id = table_one.table_one_id
left join table_two on root_table.table_two_id = table_two.table_two_id
where table_one.table_one_id is not null
and
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem.
However, when I try to connect(mysql -u root) from localhost, then I
get access denied. Checked the user table and root can connect from
anywhere(%).
Also, if I (mysql -u root -p root) from localhost, then it prompts me
for a
Merci beaucoup pour votre response!
From what I have read normally to do a binary copy you need to shut down
the
database first. Is this correct? If I have an open file agent do I need
to
shut down the database?
Cheers,
Mauro
- Original Message -
From: vanquish [EMAIL
Hi,
I am curious, is there really that big of a benefit to using a ramdisk this way? If
you have enough memory for your keycache and buffers and don't have to use tmp space
for any queries? Add the query cache in 4 to that and I wonder what is left to
ramdisk?
Thanks,
Eric
At 10:51 AM
2L.HGkzuib?'sbeKMPE.[tPPVAr:!2.0iFe;$CbjiS}Ip4)%6
I~rPYWF'?eW%7U5[KA7H5E8#:
yZ 9#cwYl4x,9\{.'2
(srzCUj0jhTDg[VyCgZ_T2iK_usQIc(tBK|H88rX(
[4tcX\|AD5-WMY;JBwCs'vj0:'{oLB vEDA%7g(1
bM)5M
I\fC?q~q{Sg
;E`LMg-K!%a1jMi$se
~}p}M?N(Ee
cm#Mg3c0z,).^)K.}doWCkV~cWN5r|D5JuTtwl#
Also, if I (mysql -u root -p root) from localhost, then it prompts me
for a password. I enter password 'root' and then I get this error:
That's what's supposed to happen:
You use
~ mysql -u username -p database_name
Then you are prompted for the password for root and it will start in
Steven Hentschel [EMAIL PROTECTED] wrote:
Can anyone tell me why the following behaviour occurs. There is no change to
the contents of tables_priv after adding the table grant to some_user before
and after the database restart. The database has been upgraded from 3.23 to
4.1.1 and the
Why when i create a table like this:
CREATE TABLE `prmsnctabelas2` (
`cdempresa` varchar(5) NOT NULL DEFAULT '',
`cdfilial` CHAR(2) NOT NULL DEFAULT '',
`nometabela` char(50) NOT NULL DEFAULT '',
PRIMARY KEY (`cdempresa`,`cdfilial`,`nometabela`)
) TYPE=MyISAM CHARSET=latin1
the result
Hello -
Im trying to change the root password on a new mysql installation. Im
running 4.1.1a-alpha on WindowsXP with Apache running.
I get the error below saynig access denied. How do I get into the user
table as root if It wont allow me into the database?
Any help would be appreciated.
Should work, as long as your parameters are all strings. With numbers
you currently need to specify the type (for example DBI::INTEGER or
similar, written from memory) as a third parameter.
do I need to specify the DBD module in addition to DBI ? After reading the module info
on CPAN it
[EMAIL PROTECTED] wrote:
Description:
MySQL 4.1.1-alpha (binary package from www.mysql.com)
does not accept negative number after DEFAULT.
How-To-Repeat:
mysql create table test (FileSize BIGINT NOT NULL DEFAULT -1);
ERROR 1064: You have an error in your SQL syntax. Check the manual
Cassiano Prado Oliveira [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 8bit, charset: iso-8859-1, 22 lines --]
Why when i create a table like this:
CREATE TABLE `prmsnctabelas2` (
`cdempresa` varchar(5) NOT NULL DEFAULT '',
`cdfilial` CHAR(2) NOT NULL DEFAULT '',
`nometabela`
Hey David
I'm having the exact same prob except on Linux. However, I can connect
from remote with almost any tool(SQLYog,MySqlCC,jdbc), just not
localhost. So you might want to try one of these tools from local and
remote and then modify the user table. Hope this helps. If you find
the
Well, I went another route and set the password using mysqladmin as follows.
Once I did that, I could get into 'mysql' database
and modify the user table.
C:\mysql\binmysqladmin -u root password password1
C:\mysql\binmysql -u root -ppassword1 mysql
Welcome to the MySQL monitor. Commands end
Hi,
I am getting following error while using Hibernate with mySql.Any help appreciated.
Thank you!
2004-01-28 14:02:51,037 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter -
Invalid argument value, message from server: Duplicate entry 'Extended Trip' for key
2
2004-01-28 14:02:51,057
Does anyone know of a function to employ when retrieving a LONGBLOB column -
Im creating an ad hoc query and
would like to see the data in text format.
With several others, I too have this problem.
MySQL 4.1.1 installed without a problem. The sqlAdmin is running. I can
run the control center and/or mysql to do sql things.
This, though, is all from the server (a PC running Win ME). I want to
connect from my laptop.
What do I have to do?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Samyukta Akunuru wrote:
Hi,
I am getting following error while using Hibernate with mySql.Any help
appreciated. Thank you!
2004-01-28 14:02:51,037 [main] ERROR
net.sf.hibernate.util.JDBCExceptionReporter - Invalid argument value,
message from
I assume that you know the the server's ip and then try:
from DOS:
mysql -h ipaddressofserver -u user1 -ppassword1
--type this as is with your server's ip
Also you need to be running 4.1.1 client on your laptop.
N. Chris Frost wrote:
With several others, I too have this problem.
MySQL 4.1.1
I'm not very sure that i understand very well your problem but i suppose that if you
don't have entries in your table(s) for weekends, is obvious that you can not show
directly some results.
To show what you wish i guess is better to use conditional IF() function.
ie:
SELECT
Hi,
I would appreciate help on the following. I would like to create a small application
that would involve Excel XP on
Windows 2000, and
perl and mysql on RedHat linux 9.0
The front end of the application will be Excel since it has a lot
of useful functions. Columns from the Excel sheet
No, it's not a practical solution, but if you used OpenOffice it could
be done. You would need to study the architecture of OO though.
brian
--
This mail composed and sent using Mozilla Thunderbird.
(http://www.mozilla.org/projects/thunderbird/)
-It's a brave, GNU world!(sorry
Raid 5 is just as common as any other raid in software, and on my other
boxes it does not present any problem at all... I have seen excellent
tests with raid5 in software, and many contest that software raid 5 on
a high powered system is faster than hardware raid 5 using the same
disks-- I
Annie Law wrote:
Hi,
I would appreciate help on the following. I would like to create a small application that would involve Excel XP on
Windows 2000, and
perl and mysql on RedHat linux 9.0
The front end of the application will be Excel since it has a lot
of useful functions. Columns from
Hello,
It might be possible to do what you want to do but...I think it will take too
much time and, therefore, will be expensive.
As stated by somebody else OpenOffice with ODBC is effectively an interesting
solution. I have done it for fun and it works quite well (after the small
nightmare
IS it possible to force mySQL to sort letters in different order - for
example BCADEFGHI... instead of ABCDEFGHI...?
I ask this question 'cause when sorting Serbian cyrilic, I get some
letters before A, but A should be the first (that mixture is produced
because those letters are placed badly
On Wed, 28 Jan 2004, Deven Phillips wrote:
Hello,
There is a web site associated with the web-radio. Users of the web site
can rate songs which are contained in the database. The rating system
works such that users can rate songs from +3 to -2. Now, what I would
like to accomplish is to
I've executed the mysql -h ip -u user -p pw
No space after -p. I know it's weird, but it's the only way it will work.
So, use this: mysql -h ip -u user -ppw
With the result that I get asked for a PW and then told I can't connect.
You shouldn't get asked for PW if you use the above syntax
I assume that you know the the server's ip and then try:
from DOS:
mysql -h ipaddressofserver -u user1 -ppassword1
--type this as is with your server's ip
Also you need to be running 4.1.1 client on your laptop.
N. Chris Frost wrote:
With several others, I too have this problem.
MySQL 4.1.1
- Original Message -
From: Seth Brundle [EMAIL PROTECTED]
To: Eric [EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 5:50 PM
Subject: Re: 64-bit Linux MySQL and ramdisks
I am curious, is there really that big of a benefit to using a ramdisk
this way?
It depends on your usage. We
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Vie 23 Ene 2004 17:08, Chris Boget escribi:
Can you UNION 2 queries and use the result to JOIN with another table?
(SELECT tableA.name, tableC.company FROM tableA)
UNION
(SELECT tableB.name FROM tableB)
LEFT JOIN tableC ON tableA.name =
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful stuff:
I don't think there would be any benefit to using InnoDB, at least not
from a transaction point of view
For the longest time I was reading the books and listening to the
experts
and all I was hearing is InnoDB is great
I'm attempting a search for multiple strings using the bind_param option. My
understanding is the server will flag each string then after each string has been
selected and exicuted I can then do a fethall_array. However the the results only
include the last string searched. any ideas. an
select product_code,title,language,issue,category,cost from iip_t_cp where
language = 'english';
I do this when selecting my database tables. But i would like to exclude one
table depleted i have not included it on the select option but it is
listed under language.
Here are the tables
mysql
got it, tnx anywayz
-- -
Louie Miranda
http://www.axishift.com
- Original Message -
From: Louie Miranda [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:02 PM
Subject: select some part, but excluding something.
select
Hi all,
Have a problem, running a master/slave setup which worked until tonight and
mysteriously broke with no changes to the setup at all. My server starts up
fine, but the master.info and relay-log.info that are created are 0 bytes
and empty. In the logfile, I get this:
040128 23:00:29 Error
86 matches
Mail list logo