Uploading Large SQL imports

[sarahA]

Is there any type of software that can take a large sql export and break it down into smaller filesizes? I've got 2 files, one is 3mb and one is 10mb. At present I can't even get the 3mb file to upload to my localhost phpMyAdmin let alone the server it's due to go on. Right now I'm going to have to sit and copy X rows until I've done all 120,000+ of them. I'd rather not have to sit and do this every month when the table is updated!

Have I been completely out the loop and is there an easier way? Or any ideas?

tyvm

[JasonD]

You can change your upload limits in a .htaccess, and since PMA is hopelessly inefficient with big files you'll need to increase memory limit and execution time.

Code:

php_value upload_max_filesize 30M
php_value post_max_size 30M
php_value memory_limit 128M
php_value max_execution_time 3600

[sarahA]

thanks Jason, I'll give that a go and see how it goes