Dumb Question - Moving Data from Access to MySQL
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 EXPARTAB1 VALUES (SELECT * FROM EXPARTAB) I have used exportSQL from CYNERGI which is a very simple script for access, but the file it creates is 125 Megs to add the data, and I can't easily work with that. Ugh! And I can't just UNLOAD/LOAD it all to a file like I did back in my Informix Days. It's gotta be simple, but this had been beating me up all day. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: Platform vs. Performance
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 memory off and will also be using this computer for file sharing and burning cd's as backup's - or using a tape drive. Thanks Again! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Platform vs. Performance
We are currently using an access database going through an odbc connection in vb.net for our application (which is still in development). The plan was to use MySQL in the end and we are needing to cross that bridge. I was wondering the Performance differences between running MySQL on a Linux box vs. a WinTel Platform. The WinTel looks inviting because we can put in an easy to administrate Windows 98 or XP Pro box in the corner of our clients office. I would rather not tackle Linux as I would need file sharing and the ability to backup and remote administration. Pros? Cons? I know the windows box would need a good reboot now and then and what is the performance hit on a WinTel 98/XP Pro platform vs Linux? Looking at a 40K record database with maybe 3 users at a time running 5-10 Large (length of the select statment is over 500 characters normally) queries at a time. 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
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 answer myself after a day on the web. 1. What is InnoDB? 2. Are their direct API's for Apache and MySQL and how reliable are they? Any other references would be useful and welcome! Thanks Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php