Transffering a large databases

how can transfer a large sql database over the internet

[akande]

Hello everyone,

I have recently changed web hosts. I have a very serious problem. I need to transfer a MySQL database which is around 2GB is size from server A to server B.

I can't download the content to my computer because the database size is too large and my connection is too slow.

I also do not have permission to create files on the server because the OS's permissions are messed up so I cannot delete or create files.

Can anyone please assist me with this dilemma?

By the way, Server A is running Freebsd and Server B is running Redhat

Thanks a lot.

[jatar_k]

what about overwriting an existing file on the server with the dump(since you can't create one)?

[akande]

How can I do that? I only know how to create a dump to zip but thats in the CP which only saves to disk.

[jatar_k]

if you can log into mysql via ssh you can manually use the mysqldump [mysql.com] command. I don't how this will help you though. You would still need to retrieve the file somehow to transfer it to the new host.

You are in a bit of a bad spot. Can the old host help you in anyway?

[dingman]

Do you have shell access on the new server? if so, perhaps you can download directly from the old server to the new server. That way, you use the two servers' internet connections, which are much more likely to be fast and reliable enough for a 2gb transfer to complete.

[sun818]

Related thread also referencing mysqldump:
[webmasterworld.com...]

[akande]

Thank you everyone,

I figured out how to solve the problem. It was so easy and starting a thread almost seems pointless.

1) Call the host and request them to sort out your server permissions

2) Log on to the server and create a sql dump and zip it up

3) Use wget from server B to grab the dump

4) unzip and upload to the new database.

Simple