Benetl, a free ETL tool for MySQL, is out in version 3.9.

2011-11-09 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for MySQL, is out in version 3.9. This version is correcting two bugs in GUI and brings code improvement. Benetl is freely dowloadable at: http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Tha

Re: Reusing "ibdata1" space

2011-11-09 Thread Nick Khamis
Hello Reindl, I just noticed that I misspelled your name. Sorry about that! Cheers, Nick. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Restore data from MySQL data files

2011-11-09 Thread Yves Goergen
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote: > Am 09.11.2011 21:46, schrieb Yves Goergen: >> The old machine was an unknown MySQL version on Windows XP > > pfff - unknown version? how comes? The old MySQL installation doesn't run anymore because the OS is gone. I could only backup the files.

Re: Restore data from MySQL data files

2011-11-09 Thread Reindl Harald
Am 09.11.2011 21:46, schrieb Yves Goergen: > The old machine was an unknown MySQL version on Windows XP pfff - unknown version? how comes? > The error log is attached to this mail. It all sounds like real bugs in > MySQL, at least it's standing in the file there is no attachment so please CLEA

Restore data from MySQL data files

2011-11-09 Thread Yves Goergen
Hi, Recently a home server has crashed and would not boot anymore into Windows. We decided to replace it altogether and I managed to repair the file system more or less so that I could copy some directories from the broken disk. One of them is the MySQL data directory of that XAMPP installation.

Re: Reusing "ibdata1" space

2011-11-09 Thread Nick Khamis
Hello Reindi, I don't mean to revisit an old post however, we are also using innodb and experiencing a rough start. Should we set innodb_file_per_table to 1? Also we expereince this scenario a lot: mysql> show tables; +---+ | Tables_in_symax | +-

Re: Issue With Subqueries

2011-11-09 Thread Mike Seda
Rong, On the server, we are using the following RPMs (from MySQL): - MySQL-server-5.5.11-1.rhel5.x86_64 - MySQL-client-5.5.11-1.rhel5.x86_64 On the clients, we are using the following RPM (from Red Hat): - mysql-5.0.45-7.el5.x86_64 RPM Mike On 11/09/2011 10:49 AM, Rong Chen wrote: Javier, I

Re: Deleting Records in Big tables

2011-11-09 Thread mos
If you could use MyISAM tables then you could use Merge Tables and create a table for each day (or whatever period you are collecting data for). Then when it is time to get rid of the old data, drop the oldest table (T2001 or T10 for 10 days ago) and create a new empty table for the new day

Re: Issue With Subqueries

2011-11-09 Thread Javier Yévenez
Hi, mysql> select count(distinct field1) from db2.table1 where field1 not in >> (select field1 from db1.table1); >> ++ >> | count(distinct field1) | >> ++ >> >> If the field db1.table1.field1 has the same name that the field db2.table1.field1, may

Re: Issue With Subqueries

2011-11-09 Thread Shawn Green (MySQL)
Hi Mike, On 11/8/2011 20:46, Mike Seda wrote: All, Can anyone out there explain the result of the third statement provided below: mysql> select count(distinct field1) from db1.table1; ++ | count(distinct field1) | ++ | 1063 | +