Optimize table time estimation...

2004-08-31 Thread Christopher M Bergeron
stamp | timestamp(14) | YES | MUL | NULL | | +---+---+--+-+-+---+ Can anyone give me an estimate on how long it would take to optimize this? I don't want to start the process and not know how long it will take to complete. Thanks in advance! Chris Bergeron

install problem... (permissions?)

2003-01-11 Thread Christopher Bergeron
Hey guys, I'm having a little problem with my new mysql installation. I built from source, and everything built find and installed okay (I think). Here's the problem: when I start safe_mysqld it just ends. Here's the snippet from my error log: /usr/local/libexec/mysqld: File './proto2-bin.1

Command out of sync error...

2002-12-11 Thread Luc Bergeron
Hello to everyone, I'm currently programming a client interface for a MySQL DB using MySQL++ api. When trying to save a Broker record to the database with the following code : std::string QuerySQL = d_Query.preview(); if (QuerySQL.empty()) return true; if (returnResult) d_Res = d_Query.

RE: Order By number of rows returned ?

2001-12-14 Thread Christopher Bergeron
Creating temporary _fileS_ will create a lot of disk unnecessary disk i/o. depending on how "busy" your DB is, I would use tables in memory vs. files on disk... just my .02c -CB -Original Message- From: sherzodR [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:25 AM To: Giri

REPLACE acter or so descriptive subject here (for reference)]

2001-12-13 Thread bergeron
>Description: >From the MySQL on-line manual (Section 7.22): REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before the new record is inserted. >From the MySQL on-line manual (F.2.3 Ch

mysql using existing .MYD .MYI files?

2001-11-16 Thread Chris Bergeron
Is there a way I can import data from a mysql using the mysql files? They weren't created using mysqldump; they were just copied from another directory. For example, I have the files: databasename/table1.frm databasename/table1.MYD databasename/table1.MYI how can I bring these into mysql? Mysq

RE: into outfile error

2001-10-24 Thread Christopher Bergeron
You may also want to make sure that you did: flush privileges; to make sure they are implemented. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 7:36 PM To: Avelino F Cc: [EMAIL PROTECTED] Subject: Re: into outfile error At 1:08 -0400

Mysql as backend for email ?!?

2001-09-21 Thread Christopher Bergeron
Does anyone know of any applications that insert email into mysql databases? I can use either Windows or Linux as the client; however, I want mysql server on the linux box (for stability). I don't like having all of my email in MSOutlook's proprietary format because in 5 years when I need to look

delete a file from disk?

2001-09-06 Thread Christopher Bergeron
How can I delete a file from disk if it exists from mysql? If it's not possible, how can I append to an existing datafile? is there an append function using SELECT * FROM DATA INTO OUTFILE "filename"; - Before posting, pl

Table Creation

2001-06-27 Thread Richard Bergeron
Hi, I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98, I seem to be missing components? 1. I can only create Databases not Tables? 2. I'm don't know which source editor/compiler I can use? Can anyone help? Thanks.Get more from the Web. FREE MSN Explore