It is unusual for phpMyAdmin to timeout.
Are you able to use phpMyAdmin in ways other than import ?
How big is the file you are trying to import ?
Are you able to successfully import even the smallest file ?
Have you checked with your hosting providor ? Do they have some particular problem ?
If it really is that your file is just too big, then it is possible to cut it up into smaller more easily digested fragments, and import your data in stages.
Thread Starter
ClintN
(@clintn)
Ahhhh yes the SQL is 185 mb which may be too big!
I will investigate how to cut up a SQL file into smaller chunks, I did a test run with the original file doing it manually, which I believed worked even though there was an SQL error message in phpMyAdmin.
I an not sure if the there is any special naming conventions or file headers required to do it manually, but I would prefer a tool to cut up a 185mb file
Thanks heaps
Perhaps give it a try using a gzipped export file.
In phpMyAdmin Export, select Custom in the Export Method, then in Output, select gzipped from the compression drop down.
You may also want to investigate a tool such as Navicat for MySQL.
