| Author |
 Topic  |
|
|
TonyB7
Junior Member
USA
267 Posts |
 Posted - 26 January 2007 : 18:37:10
|
I'm trying to convert an Access db to MySQL, but I'm getting hung up with CGI errors when trying to import one 30mb table to PHPMyadmin:
quote:
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.
I have already submitted a trouble ticket but they've given up, so I was wondering if anyone has seen this or could suggest a workaround?
I have Access2MySQL Pro, but the .sql dump it outputs also generates errors when I try to upload it:
quote:
CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process.
Suggestions welcome. TIA |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 27 January 2007 : 12:05:41
|
sounds like a straight timeout on the script server-side. If you can extend the script timeout temporarily, do so, otherwise pull the db's local and do it on your own hard disk/machine.
30Meg is pretty big for a db - have you tried compacting it in Access before doing the conversion? Just a thought.
It's not free unless you own a SQL Server license, but DTS is just the ticket for this kind of thing, if you can use a copy anywhere.
I reckon the phpMyAdmin thingy is the borking point, so if all else fails, if you have completed the conversion locally etc, could you just FTP the file across to the server? |
 |
|
|
TonyB7
Junior Member
USA
267 Posts |
Posted - 28 January 2007 : 14:46:54
|
Oh yes, I always 'compact and repair' before attempting to work with the db. The compacted size is about 50mb. The second largest table uploads fine, it's just forum_a_reply with 30mb that throws the errors.
We have no remote access to the dbs for security reasons, so PHPMyAdmin is it. I tried uploading the .sql dump and tech support tried importing it, but twice now that's generated (different) errors and I just don't see how I can accomplish this conversion by secondhand proxy anyway.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 January 2007 : 15:08:45
|
| In cases like these, I usually split the .sql dump and let it run each half, hoping it will not timeout. Or even split it into 4 parts or even 6 parts. That's the limitations of using a web interface though. |
Support Snitz Forums
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 28 January 2007 : 15:39:49
|
| I wish I knew more about MySQL - does it support BCP or something similar? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 January 2007 : 16:02:04
|
| Yeah... phpmyadmin and the upload limits simply are not acceptable for many MySQL DBs... I also find the security argument for non-external access a statement of incompetency by a host... the argument simply is not acceptable, IMHO. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
