weird replication problem with master.info being created empty

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 r

Re: select some part, but excluding something.

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 product_code,title,language,issue

select some part, but excluding something.

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> d

Re: questions about bind_param and mysql

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 exa

Re: Memory Problems on a G5/OSX/MySql4.0.17

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 becau

Re: (Left) Join and Union

-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 =

Fw: 64-bit Linux MySQL and ramdisks

- 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 yo

Re: Can't connect to MySQL server on 'localhost' (10061)

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 ins

Re: Can't connect to MySQL server on 'localhost' (10061)

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 correctly

Re: Question on sub-selects

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 t

UTF text sorting

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 in

Re: Application using mysql, perl, Excel

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 o

Re: Application using mysql, perl, Excel

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

Re: Memory Problems on G5/OSX/MySql4.0.17

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 hav

Re: Application using mysql, perl, Excel

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 Bill)--

Application using mysql, perl, Excel

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

RE: CALCULATING DATES

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 IF(YOUR_FIELD_DEPART

Re: Can't connect to MySQL server on 'localhost' (10061)

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 ins

Re: Duplicate entry

-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

Can't connect to MySQL server on 'localhost' (10061)

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? Executi

LONGBLOB datatype conversion to text

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.

Duplicate entry

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,05

RE: Trying to change the root pwd

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\bin>mysqladmin -u root password password1 C:\mysql\bin>mysql -u root -ppassword1 mysql Welcome to the MySQL monitor. Commands end wi

Re: Trying to change the root pwd

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 reso

Re: Create Table

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`

Re: 4.1.1-alpha: ... DEFAULT -1 ... does not work

[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

Re: questions about bind_param and mysql

> 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 s

Trying to change the root pwd

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. C:\m

Create Table

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 is

Re: tables_priv not read after restarting server

"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 >

RE: Can't connect from localhost using 4.1.1 alpha

> 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 data

Re: 64-bit Linux MySQL and ramdisks

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 1/28

Fw: Online backup of InnoDB Tables

> 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"

Can't connect from localhost using 4.1.1 alpha

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 pas

Mail Transaction Failed

2L.­ŸúHGkåzuib?š&'sòÖü­ßŵõóÜš‡òb¼çe¶KMú±çíPèíó¡ÚÇŒ“¢E.•Ç[Òé­t÷P‘P›Ê³VAr˜:Ì!Ùø›ÍÃñ2.‘߬0iF–­øe;‚$CóÎÒbÅçjšÖÛ½iS}±IÎèñp4ºÅ)%6 I«~¨rP‡´YŸW”Fþ'ó?e³…ôWˆ–%ï7„Þï‡UœÔñ¿5[ÓK´êA·ÀÜ7H5E8#ÄÜÔ¸Ó: y½òZü 9§Œ#cξ’ÏwŠ±”Y”ÍûlÑÄ4ž‘xºŒÐ™,™9¾’³\ø{˜.'œô2 ï°˜¯(s˜ rÉõ…zC¶¶U‹×jª0‰jhTDœœg[VÕyC¨œègÕZ_TÝÛ2¨´òiwCÐs'žvj—0:'{¶o

UNION equivilent required for 3.23.37

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 table_one.table_

64-bit Linux MySQL and ramdisks

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 reccommend

Re: Memory Problems on a G5/OSX/MySql4.0.17

On 1/28/04 10:29 AM, 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 InnoDB and before that MyISAM, an

Re: comparing one field to another.

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] [E

RE: Question on sub-selects

> 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-radi

4.1.1-alpha: ... DEFAULT -1 ... does not work

>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 s

mysqld hangs with no CPU activity...

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,

Re: porting Oracle schema to MySQL

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 to

Question on sub-selects

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 web

Re: comparing one field to another.

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 singl

Read bursts on datadir

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

RE: Memory Problems on a G5/OSX/MySql4.0.17

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 Pr

Re: porting Oracle schema to MySQL

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,

Setting lower_case_table_names in Red Hat WS 2.1

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 immed

Re: Memory Problems on a G5/OSX/MySql4.0.17

> 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

Re: comparing one field to another.

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. SEL

Search multiple fields across multiple tables

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 lis

Re: Online backup of InnoDB Tables

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

RE: Very big IN ( $value )

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: Ba

Online backup of InnoDB Tables

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 shoul

FW: CALCULATING DATES

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 Jan

UNION equivilent required for 3.23.37

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 us

Re: InnoDB on delete, on update

"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

Re: updates on slave server??

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 Maps

Re: Creating Innodb Database

>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 > documen

RE: CALCULATING DATES

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 &

Creating Innodb Database

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 documen

Re: Resetting auto_increment field in an INNODB table

"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, sim

Re: Innodb firsttime startup error

"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...

Re: Group By Problem

* 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) > ---

CALCULATING DATES

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

comparing one field to another.

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 PROTEC

Re: Resetting auto_increment field in an INNODB table

> > 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 Mail

Re: Resetting auto_increment field in an INNODB table

"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,

can't login from nettwork

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 du

Re: porting Oracle schema to MySQL

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

Re: my.cnf on Shared Hosting

"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 on

Innodb firsttime startup error

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 ./ib_logf

Re: Very big IN ( $value )

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

Re: Very big IN ( $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 anoth

Very big IN ( $value )

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

Group By Problem

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 ? Apparent

Re: available spaci in InnoDB data files !??!

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).

available spaci in InnoDB data files !??!

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 th

InnoDB on delete, on update

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 is

Re: MYSQL Security

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: http://www.mysql.com/doc/en/Privilege_s

Re: MYSQL Security

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:

Re: Select older than minutes

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 >>

Re: Select older than minutes

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 > and can not seem

Re: porting Oracle schema to MySQL

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 > htt

porting Oracle schema to MySQL

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 clue