I'm moving my site to a colocated machine from a shared hosting machine. The new machine runs windows server 2003 and plesk is being used for a webinterface, though we have remote desktop access as well. The php is version 5 + and mysql is MySQL 4.1.12.

My problem is that I could use ssh to import/export before but I don't know how or if I can do that on the new machine. I tried to use putty to connect to the domain using the ftp username/pass but that failed.

Importing the db kept timing out using phpmyadmin so I ended up exporting from the old db in small pieces and then importing them to the new db.. this worked great except for 2 tables.. post and post index.

I have been told I could increase the php_value max_execution_time but I'm not exactly sure where to edit that. I've found about 7 or 8 different php.ini files on the computer and they vary from values of 30 to 1600.

When I try to import either of the tables I get the following message "Fatal error: Maximum execution time of 300 seconds exceeded "


Is there a way to break down the tables into even smaller parts and the import them that way?

Is there a way to access the actual folder location of the db and add the tables in there?

Or how can I use or setup ssh on this machine?

Thanks.

__________________
$$ for code - Click Here for Info