RE: [PHP] Importing Access into MySQL

Yeah it is also a good way:... but what I do is I use the both phpmyadmin and dbtools. with dbtools you can check the newly created database for accuracy right after you converted it. error ? delete mysql database, modify access file, import again ... and so on.. when database becomes ok, I use phpmyadmin to play with it for a better performance.. I also do it this way sometimes: I use a php file on the server and write there queries, one after one ... modifying so the entire database. this is because it takes some time to convert and in actual access database are new entry and some data was maybe modified already. So by time I am ready I just make a copy of real access database convert it and run my script which rewrites the whole database in split of a second and brings it online. this is way is much safer. Cheers, Maxim Maletsky. -----Original Message----- From: David Smith [mailto:webmaster@indywebdesign.com] Sent: Friday, December 08, 2000 10:42 AM To: Maxim Maletsky Subject: RE: [PHP] Importing Access into MySQL Actually I exported the data into a "";"" text file and with the help of phpMyAdmin I imported it into MySQL. Was a litle tricky but I managed to get it right... Thanks to all who replied... David Smith -----Original Message----- From: Maxim Maletsky [mailto:maxim.maletsky@japaninc.net] Sent: Thursday, December 07, 2000 8:37 PM To: 'Joseph H Blythe'; David Smith Cc: php-general@lists.php.net Subject: RE: [PHP] Importing Access into MySQL be careful though about field names. If while transforming an error occurs it won't stop. The only way to see that will be only software's error log. You should first make a copy of access file and check there carefully all the field names. Then transform it into mySQL and play with column properties. Who usually makes access databases has all the fields f...ed up. So be aware: it is not like: click-a-button-and-it's-done, you'll have restructure lot's of things over there. But there's no easier way to do it. And DBtools is easy enough to use. (sometimes it crashes, but still is OK) This is what I am playing with whole this week. Cheer, Maxim Maletsky -----Original Message----- From: Joseph H Blythe [mailto:joe.blythe@binarylogic.com.au] Sent: Friday, December 08, 2000 6:40 AM To: David Smith Cc: php-general@lists.php.net Subject: Re: [PHP] Importing Access into MySQL On Thu, 7 Dec 2000 12:58:39 -0500 "David Smith" <webmaster@indywebdesign.com> wrote: > Anyone know where I can get info or tell me how to import an access database > into a MySQL db? > > David Smith > > DBTools is a windows program which can do just this, I have used it and it works, you can find it here: http://dbtools.vila.bol.com.br/ hope this helps, Regards Joseph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net