Re: DB recovery

on the new host. You may have to use > myisamchk to repair the indexes. > > http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html > > You will want to do all of this with mysqld stopped. > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County,

DB recovery

ible to get the MySQL 3 files and recreate them on another box we have here that runs MySQL 4.0. Is this possible? It wouldn't be as simple as getting the files from the dead box and putting them in the new box, would it? Thanks, -- Yves Arsenault -- MySQL General Mailing List For

Re: Data conversion question

pe the attachment did not get > stripped). it contains some udf-functions for base64 en/de-coding. a > little description is included. > > ciao, > konrad > > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Data conversion question

Hello, I was looking throught the manual a bit, I haven't found the answer I'm looking for... Does MySQL have commands that would allow me to convert Base64 data to Binary and then convert that Binary to a string format? Thanks, -- Yves Arsenault -- MySQL General Mailing Lis

Re: MySQL and partitions

Thanks to all of you who replied. Yves On Wed, 3 Nov 2004 13:57:33 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how t

Re: Fwd: MySQL and partitions

Ah, Thank you all so much. :-) My purpose for asking was some concerne with the possibility of growing DB sizes.. Question answered. Score one for the list. Yves On Wed, 3 Nov 2004 14:52:35 +0100 (CET), Thomas Spahni <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsena

Fwd: MySQL and partitions

ed, 3 Nov 2004, Yves Arsenault wrote: > > > Hello all, > > > > I have MySQL installed on a Mandrake Linux system, it is installed on > > the /usr partition. > > > > I was wondering, is it possible to store some databases on the /var > > partition while

MySQL and partitions

(or at least 2 different partitions). Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tables and performance

Thanks for the reply. Yves On Tue, 19 Oct 2004 14:22:01 +0300, Egor Egorov <[EMAIL PROTECTED]> wrote: > Yves Arsenault <[EMAIL PROTECTED]> wrote: > > > Does a very large number of tables in a database affect MySQL's performance? > > Strictly saying, yes. But

Tables and performance

Hello, I have 2 questions. Is there a maximum number of tables that can be created in a database? Does a very large number of tables in a database affect MySQL's performance? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Windows VS Linux Platform

Hello, I have a very short question I was wondering if there are any differences in how MySQL behaves on Windows and Linux. (i.e. difference in performance, slightly different syntaxetc) If anyone has a link to such documentation it would be greatly appreaciated. Thanks, -- Yves

Re: Function in Where clause

conversion, the format of that field wasn't quite as before. After I noticed that, a couple of changes, no prob. Thanks again, Yves At 10:52 2004-01-21, you wrote: Yves Arsenault wrote: SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month

Re: Function in Where clause

ession.month#' to '$month' which is the language,u r using anyway? - Original Message - From: "Yves Arsenault" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 6:37 PM Subject: Function in Where clause > Hello, > >

Function in Where clause

Hello, I have a client using a already made calendar component on my server... The problem seems to be the SQL code. This code works (i believe) with an MS Access or MS SQL server DB... MySQL version is 3.23.58 The code is: SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate)

RE: Loosing "é" characters in DB insertion

The only language I installed on this box is English... would that be why? Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 14:16 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB

RE: Loosing "é" characters in DB insertion

y the 'é' characters.. Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:29 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion What operating system does

RE: Loosing "é" characters in DB insertion

The è caracter is being changed to a square... Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced

Loosing "é" characters in DB insertion

Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user

RE: Access to MySQL

Thanks to all who replied! I was just looking at MySQL Front. Thanks all, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: December 17, 2002 12:24

Access to MySQL

Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault Carrefour Infotech 5,promenade Acadian Charlottetown, IPE C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823

Unique identifier in MySQL

Hello, Hope this makes sense, I am totally new with using MySQL. How would I create a unique ID number for a table, for, say, a field named UserID for example? Thanks Yves - Before posting, please check: http://www.mysql.com