RE: compare tables from two systems

2005-10-06 Thread Tim Hayes
to update it and put it back in synch. Tim Hayes -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 05 October 2005 23:25 To: Claire Lee; mysql@lists.mysql.com Subject: Re: compare tables from two systems - Original Message - From: Claire Lee [EMAIL PROTECTED

RE: good database design

2005-09-22 Thread Tim Hayes
customers happy. Tim Hayes MYdbPAL - www.it-map.com -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 22 September 2005 09:02 To: mysql@lists.mysql.com Subject: Re: good database design I need links about good database design information for high loaded web

RE: good database design

2005-09-22 Thread Tim Hayes
should start worrying abt the DB Tuning and harware requirements. sujay -Original Message- From: Ian Sales (DBA) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 2:17 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: good database design Tim Hayes wrote: I disagree

RE: Changed Number

2005-04-06 Thread Tim Hayes
Ken Looks like you used a medium int field on the mysql table - if you import a figure that is too big for the medium int to handle - on overflow it places a value of 8388607 into the colum. You need to change to an integer column. Regards Tim hayes -Original Message- From: [EMAIL

RE: Need Help with 813-MDB File

2005-03-30 Thread Tim Hayes
David Please also have a look at MYdbPAL for MySQL. Freeware again - this will sort out any schema conversions you might need - auto corrections. Plus you can model the schema. MDB conversion is shown in the tutorials. Tim Hayes -Original Message- From: David Blomstrom [mailto:[EMAIL

RE: Need help coverting MDB SQL

2005-03-26 Thread Tim Hayes
Try MydbPAL at www.it-map.com. Its a FREE product that will do a complete .mdb (access) to My SQL translation - schema and data. There is a learning curver but you can follow the tutorial which takes you thru an mdb conversion Tim Hayes -Original Message- From: Rhino [mailto:[EMAIL

BIGINT UNSIGNED issue?

2005-02-23 Thread Tim Hayes
misunderstanding something? Tim Hayes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to Version Control a database

2005-02-20 Thread Tim Hayes
Try using MYdbPAL from www.it-map.com . The product has complete schema version control, alowing you to track changes and compare sche,as for diffrences. Its FREE to MySQL users. Tim -Original Message- From: Will Merrell [mailto:[EMAIL PROTECTED] Sent: 20 February 2005 14:00 To: Mysql

RE: Pulling a database schema out of a unknown MySQL database?

2005-02-02 Thread Tim Hayes
Dan Please try MYdbPAL for MySQL - www.it-map.com. It is FREE, and you can reverse-engineer the schema; view, model, forward engineer etc. Tim Hayes -Original Message- From: Dan Stromberg [mailto:[EMAIL PROTECTED] Sent: 02 February 2005 12:31 To: mysql@lists.mysql.com Cc: [EMAIL

RE: Data and strucuture importing from MSAccess to MySQL

2005-01-29 Thread Tim Hayes
/solutions/archives/002944.asp Tim Hayes -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: 29 January 2005 04:44 To: mysql@lists.mysql.com Subject: Data and strucuture importing from MSAccess to MySQL Which way is easier to import data and structure of database from

RE: Data fields from one database to another

2004-09-28 Thread Tim Hayes
Try using MYdbPAL - its a new free program that will do the job plus lots of other goodies. www.it-map.com Tim Hayes -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 08:23 To: [EMAIL PROTECTED] Subject: Data fields from one database to another

RE: Data fields from one database to another

2004-09-28 Thread Tim Hayes
record. Stuart --- Tim Hayes [EMAIL PROTECTED] wrote: Try using MYdbPAL - its a new free program that will do the job plus lots of other goodies. www.it-map.com Tim Hayes -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 08:23 To: [EMAIL

Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
to be unique in both environments. Q. Is there some sort of practical advantage for having case sensitive table names in Linux, or is this a design shortcoming? Postgress rejects duplicate table names. Thanks Tim Hayes

Re: Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
OK There is still the possibility of an in-compatability between the 2 platforms. However - in both Linux and Windows (MySQL 4.0.17) the variable is not recognized / updateable using the set command! I get - Unknown system variable 'lower_case_table_names' Tim Hayes - Original Message