i should think it's the upload_max_filesize variable, set in php.ini - the default is 2 megabytes, so if your sql dump is 4.5, then phpmyadmin won't upload, and neither will any other php script. You could change it in the php.ini, but a lot of hosts won't give you access to this. Some ini option can be set in a script using ini_set, but not upload_max_filesize.
So what I suggest is you open the file in notepad and split it into three chunks; at around 1.5mb each, these should be fine to upload. When you open the file, you will see it is composed of sql statements - you can just split the file in between the statements.
OR - i have just upgraded to phpmyadmin 2.50 and when you dump the sql file, you can specify which rows to dump. If you are dumping, say, 3000 rows and your file is 4.5mb, try dumping 1000 rows at a time. BUT don't forget that only the first file will need the DROP TABLE and the table structure.
Sorry i've rambled - it's 2am!
ads
