Dump file times out?

[Bengal313]

i actually have 2 questions that are related.

I have a huge Access database (about 50,000) records. I use Access dumb to create a sql file which I can them go into phpmyadmin and import the records. Well, after a while the process times out. Is there a way I can import large amount of data into MYSQL without timing out?

Also the access database that I convert over gets updated every week. I don't know which records get updated or added. Also the app I am using only works with Access so I can not completely convert over. Is there a way I can update the MYSQL without having to import that huge file again. Maybe something that will not override the records that are same just change the modifed ones and add the new records.

[raf]

Maybe check out this
http://www.mysql.com/portal/software/item-152.html
Or, you could import the table in 2 or 3 times. Or set the timout time higher. I assume the phpMyAdmin import is threated as a php-script, so it's probably the webserver that will timout. So maybe try the commandline. ( but just cutting the file up is easier
:) )

Is there a way I can update the MYSQL without having to import that huge file again.
Yes. Insert a timestamp field in MsAccess table, that registers the date the recordd was inserted/updated. Then just select the records with a timestamp higher then the last ofload. (these records are called the "delta's" for that table. So you then use a
select into ... where timefield >= #lastofload-datetime#

You could then use a replace
http://www.mysql.com/doc/en/REPLACE.html
to insert new records, and update old ones in the MySQL table.