i have a database table structure all set up in phpmyadmin but with no records in it. all the records are in a 200MB .csv file (67MB when zipped) on my local drive. i'd like to find a simple way of uploading this data as i'm going to have to re-upload files of this size fairly frequently and the phpmyadmin import tool has a limit of about 50MB (and it doesn't seem to work when i try to upload zipped files). i've tried using the free 'bigdump' tool to split the huge csv file up but i think it only works with .sql databases and not .csv files?
i'd be very grateful for any advice!
p.s. it's getting late here in london so i'm not going to last much longer but i'll check back first thing in the morning!