Posted by NC on 03/02/06 19:51

Simon wrote:
>
> I need to export a 200MB database from one domain to another.
> phpMyAdmin timeout after a while and is not ideal.
>
> I don't mind spending money if I have to but this is rather urgent.
>
> I only work on win32 machines but the servers are Unix machines.
> I don't have command line access to the servers.

Another potential problem is that your Web hosting company may be
blocking remote access to MySQL...

> Do you guys know anything I could use?

Start with the obvious -- the command-line MySQL client tools. You can
install mysql client and related utilities on your Windows machine and
use it to access your remote servers. Just start MySQL client with a
-h key to access a remote server, something like this:

mysql -h mysql.myremoteserver.com -u myusername -p

There are also plenty of third-party tools to access and manage remote
MySQL servers. My personal favorite is MySQLmanager:

http://www.sqlmanager.net/en/products/mysql/manager

You can download a fully-functional 30-day trial version and actually
migrate your data before you buy...

Cheers,
NC

[Back to original message]