CSV import

I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any app/snippet written for this task in .net , which I can modify according to my need. -- Sharique uddin Ahmed Farooqui (C++/C#

Re: Table compression with write (append) support

In the last episode (May 27), Yves Goergen said: > I'm thinking about using a MySQL table to store an Apache access log > and do statistics on it. Currently all access log files are stored as > files and compressed by day. Older log files are compressed by month, > with bzip2. This gives a very goo

RE: MySQL 5.0 creates 100,000 Window handles

Hi, Try [EMAIL PROTECTED] instead. Bye. Geof. -Message d'origine- De : mos [mailto:[EMAIL PROTECTED] Envoyé : vendredi 25 mai 2007 06:41 À : mysql@lists.mysql.com Objet : MySQL 5.0 creates 100,000 Window handles I noticed if my program executes a lot of Select statements, Windows XP w

RE: restore one database.

Hi Ananda, Recovery strategy depends essentially of the backup strategy you choose. I think that if you want be able to proceed to a restoration, database per database, you should separate their backups. It can simply be done with this kind of script: for db in (`echo 'show databases;' | mysql -u

RE: restore one database.

Hi Ananda, Recovery strategy depends essentially of the backup strategy you choose. I think that if you want be able to proceed to a restoration, database per database, you should separate their backups. It can simply be done with this kind of script: for db in (`echo 'show databases;' | mysql -u

RE: error message

Hi, Could we show your procedure to try to help you ? Geoffroy. -Message d'origine- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : vendredi 25 mai 2007 17:35 À : MySQL General Objet : error message Hi All, We are using 5.0.40-enterprise-gpl-log version on our production db. If we

Re: General Questions About Indexes

INDEXES - A Science AND an Art I've been continuing to look for answers to my own questions. I've found a few ... Q1. What good does it do to store the primary key or a unique key if you're normally SELECTing columns that don't use that primary or unique key? "As you can see, it only make

Table compression with write (append) support

Hi, I'm thinking about using a MySQL table to store an Apache access log and do statistics on it. Currently all access log files are stored as files and compressed by day. Older log files are compressed by month, with bzip2. This gives a very good compression ratio, since there's a lot of repetiti

Re: restore one database.

Hi All, I think my question was not understood. All the database are important. Now that one of the database is accidently dropped, can i restore from that single database from my dump and use the bin log and recover till "AS OF NOW". regards anandkl On 5/27/07, John Meyer <[EMAIL PROTECTED]> w

Re: restore one database.

Ananda Kumar wrote: > Hi Pelle, > I dont have enough space on any other storage, so i was thinking if we > would > just restore one database from dump that would save lot of time , rather > than restoring all the database. > > regards > anandkl > >> Well, if only one database is important enough t

Re: restore one database.

Hi Pelle, I dont have enough space on any other storage, so i was thinking if we would just restore one database from dump that would save lot of time , rather than restoring all the database. regards anandkl On 5/26/07, Ezequiel L. Pellettieri <[EMAIL PROTECTED]> wrote: Hi Ananda, I don't k