Re: Problems with float() fields during migration to MySql 5

2005-07-14 Thread Gleb Paharenko
Hello. This weird behavior is very similar to described at: http://bugs.mysql.com/bug.php?id=7361 Nico Alberti <[EMAIL PROTECTED]> wrote: > Hi everybody. > > During the migration of our mysql test server to version 5 I noticed a > problem when I tried to import a table that I dumped

Problems with float() fields during migration to MySql 5

2005-07-14 Thread Nico Alberti
Hi everybody. During the migration of our mysql test server to version 5 I noticed a problem when I tried to import a table that I dumped from our 4.1 production machine. The table has some fields defined as float(31,30) (they came from an old Access table converted with DBTools Manager). When I

Migration to Mysql

2004-09-05 Thread vivek khurana
Hello all, I am going to migrate a MsAccess database to MySQL. I wanted to know if somebody ahs doen it and what problems you might face and workaround them if possible. Also, do let me know if my query is broad?? Reagrds VK ___

Migration to MySQL from flatfiles

2002-04-03 Thread Denny Snyder
Hello all, Please pardon my "newbie-ness" I've been looking at somehow migrating from a flatfile user system (/etc/passwd, etc) to a MySQL backend for authentication for all my processes... qpopper, postfix, and apache/frontage (ick) I can't seem to find anything that would enable me

Re: Help - Migration to mysql from a legacy ISAM

2001-11-02 Thread Sergei Golubchik
gei Golubchik [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 15, 2001 11:49 AM > To: Ian Collins > Cc: [EMAIL PROTECTED] > Subject: Re: Help - Migration to mysql from a legacy ISAM > > > Hi! > Actually, HANDLER command was created exactly for this. > That is, it ca

RE: Help - Migration to mysql from a legacy ISAM

2001-11-01 Thread Sinisa Milivojevic
Ian Collins writes: > So how do you use the HANDLER command in a C program? > I perused the code for 3.2x for this, and ended up installing mysql-4.0.0. > I found what I believe to be the code for HANDLER in > libmysqld/sql_handler.cc > in the functions, > mysql_ha_open, mysql_ha_close, mysql_ha_r

RE: Help - Migration to mysql from a legacy ISAM

2001-10-31 Thread Ian Collins
surmise, off on a tangent)? Are there any examples anywhere of how to use these? Many regards, Ian Collins. -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 11:49 AM To: Ian Collins Cc: [EMAIL PROTECTED] Subject: Re: Help - Migration to

RE: Migration to mysql from MS SQL Server

2001-10-04 Thread Will French
IL PROTECTED] > Subject: Re: Migration to mysql from MS SQL Server > > > > Harpreet writes: > > > Can we create a php page that will use mssql_connect to connect > to ms sql > > server get the data and then use mysql_connect and connect to > mysql server > &g

Re: Migration to mysql from MS SQL Server

2001-10-04 Thread Carl Troein
Harpreet writes: > Can we create a php page that will use mssql_connect to connect to ms sql > server get the data and then use mysql_connect and connect to mysql server > and populate the table. > > Is this possible. Yes, but only if you don't include 8 kilobytes worth of redundant irrelevanc

RE: Migration to mysql from MS SQL Server

2001-10-04 Thread Harpreet
: Will French [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 10:00 PM To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] Subject: RE: Migration to mysql from MS SQL Server venu:> If you can make use of MS Access and ODBC in the middle layer in venu:> the conversion, venu:> f

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Will French
From: Venu [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 4:00 PM > To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] > Subject: RE: Migration to mysql from MS SQL Server > > > Hi !!! > > > -Original Message- > > From: Will French [mail

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Venu
Hi !!! > -Original Message- > From: Will French [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 12:28 PM > To: Pavel Hant; [EMAIL PROTECTED] > Subject: RE: Migration to mysql from MS SQL Server > > > I just did this with a rather large database. H

RE: Migration to mysql from MS SQL Server

2001-10-03 Thread Will French
> -Original Message- > From: Pavel Hant [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 2:59 PM > To: [EMAIL PROTECTED] > Cc: Pavel Hant > Subject: Migration to mysql from MS SQL Server > > > Hi everybody, > > I am trying to migrate a d

Migration to mysql from MS SQL Server

2001-10-03 Thread Pavel Hant
Hi everybody, I am trying to migrate a database from MS SQL Server 2000 to mysql. Does anybody know any source of information on this matter, or can anybody share his/her own experience of such a migration? Suggestions? Any help would be appreciated. Thanks, Pavel