moving large mysql database

to big for myAdmin

[Scally_Ally]

Hi there,

I have done alot of trawling of the net trying to find an answer for this but didnt really come up with that much, at least not that much that i could use.

I want to tranfer my Mysql database to another server, the thing is that it is 15Mb and has alot of binary data in it storing images.

From what i have found so far i have to use shell commands to do this but i have never used these or TelNet before.

I have access to the server via remote desktop so maybe there is a way of doing it this way?

Any help or tutorials that you know of would be greatly appreciated.

Thanks

[jatar_k]

using telnet/ssh isn't too tough it just mostly takes some getting used to. It is the only way I have ever used mysql, I like it. ;)

another option might be to see if your host could just tar up the mysql files and then you could drop them on the new server.

Otherwise you just need to use standard mysql commands instead of clicking buttoins that do it for you.

this might be a place to start
[dev.mysql.com...]

[maccas]

Of course you could just split it up and use phpmyadmin. There is a free file splitter (by line) floating around the web somewhere... forgotten it's name.

[Jaunty Edward]

Hi,

I had a somewhat same problem yesterday... please reffer

[webmasterworld.com...]

15MB is not too big... export the file to a zip or gz file using phpmyadmin and then you can import that on the new server.

If you are using cpanel you can add the new servers IP in your old cpanel and then both the mysql servers can communicate remotely itself.

Hope this helps,
Jaunty