Dumb Question - Moving Data from Access to MySQL

2003-09-22 Thread Jeremy Proffitt
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tried: INSERT INTO EXPA

Re: RE: Platform vs. Performance

2003-09-19 Thread Jeremy Proffitt
First, Thanks for all replies, I'll be going with XP Pro on a P4 machine. The next question is RAM, I know more is better, but the access database file I'm using now is 120Megs and will stay about the same size. Do I need more than 1G, can I get by with 512M Ram? I will of course turn virtual

Platform vs. Performance

2003-09-17 Thread Jeremy Proffitt
. Any help is greatly appriciated! Thanks! Jeremy Proffitt Computer Programmer, Pearson Appraisal Services, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

New to MySQL

2002-08-24 Thread Jeremy Proffitt
Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to