RE: MySQL Poll

2002-07-14 Thread Bert VdB
MysqlFront is thé best tool for me. http://anse.de/mysqlfront/download.php Works on remote databases to, nice and smooth interface, exporting tables in various formats, export/import from one active db to another ... B. -Original Message- From: Correale, Ernest [mailto:[EMAIL

RE: Implementing commit,transaction in isam table type

2002-07-10 Thread Bert VdB
Seems fairly impossible to me to really emulate transactions on a non-transactional db. Even if you develop a system where you : a. collect all queries untill the end and then perform them in 1 block b. keep your own logs of the queries and be able to roll them back in case of error even then it

RE: SHOW TABLE STATUS InnoDB Tables

2002-07-03 Thread Bert VdB
From the manual : Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. CB. -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: innodb is disabled, how can i make it yes?

2002-07-03 Thread Bert VdB
Are you sure that you are starting mysqld-max-nt.exe for the server ? If so, try mysqld-max-nt --print-defaults to see what parameters are set, maybe that will give you a clue ... CB. -Original Message- From: Hytham Shehab [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 00:19

RE: starting MySQL automatically

2002-07-03 Thread Bert VdB
You can use the winmysqladmin tool located in the bin directory to install it as a service. (I'm not sure wether this also works on a '98SE machine) CB -Original Message- From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:00 To: [EMAIL PROTECTED]

RE: PERROR on Windows

2002-07-03 Thread Bert VdB
Yes there is: perror.exe located in c:\yourmysqldir\bin\ :) -Original Message- From: Christopher A. Libby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:16 To: [EMAIL PROTECTED] Subject: PERROR on Windows Is there a command like perror for the Windows version of MySQL?

RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-07-02 Thread Bert VdB
To: [EMAIL PROTECTED] Subject: Re: high level: enabling transactions in mysql-max with WebLogic TX datasource? Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC

RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?

2002-07-01 Thread Bert VdB
Hi, all you have to do use a transaction enabled data-source and use the Mm-MysqlDriver for your JDBC connections. (http://mmmysql.sourceforge.net/) Best is to read the InnoDB documentation carefully (http://www.innodb.com), as you cannot choose from a wide variety of transaction-levels ... in

FW: Display Records in Multiple Pages

2002-06-27 Thread Bert VdB
Oops, forgot to send it to the list: Use an index and offset in your queries. You need 25 queries per page(=the offset), each page starting display from a different record (=the index) This would give something like this for page 1: $result = mysql_query(SELECT * FROM your_table WHERE

RE: default table type

2002-06-27 Thread Bert VdB
Add this to your my.cnf file : # The MySQL server [mysqld] # Default table type for new tables default-table-type=InnoDB CB. -Original Message- From: Pierre Baridon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 12:09 To: [EMAIL PROTECTED] Subject: default table type how

RE: How to recover if .frm file get lost/corrupted

2002-06-26 Thread Bert VdB
I think u just have to create exactly the same table in another database, and then copy the .frm file to the one where you lost the original one. CB -Original Message- From: Jonathan Stockley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 00:20 To: [EMAIL PROTECTED] Subject:

RE: innodb bug

2002-06-26 Thread Bert VdB
Hi, I'm sort of glad we're not the only one having this problem. Yesterday we had kind of the same error message on an Solaris 8 machine with 512Mb of ram. Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by the orion-web-server. Today I will perform crash-tests on another

RE: installing 2 servers on the same Win 2K machine

2002-06-24 Thread Bert VdB
Hi, I have 2 version installed on my win2k machinge (.49 , .50 and .51) As long as you install in different directories , take care of config files and don't try to start 2 server simultaniously, I don't see why this should give problems. (At least, I haven't got any problems ;) ) CB.

RE: Re-do logging feature with InnoDB: is it possible ?

2002-06-24 Thread Bert VdB
Hello everybody, I have a small question regarding to the Mysql-InnoDB-tables : Is it possible to use an Oracle-like 're-do logging' feature with InnoDB ? This means more or less taking regular consistent backups of your database, and then in case of corruption, you restore the latest

FW: Binary data mysqldump and restore.

2002-06-24 Thread Bert VdB
Just for those people who have the same problem: -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:13 To: Bert VdB Subject: Re: Binary data mysqldump and restore. That did it thanks! MWP Hi, Have you tried making a dump