i need help for shifting db from server to server

[chems]

hello guys

i want to shift my big db ( more than 1.5 Gb )

from a vps that i have root access

to another with directadmin without root access any help to do that ?

chems Reviewed by chems on 22nd Mar 2011. i need help for shifting db from server to server hello guys i want to shift my big db ( more than 1.5 Gb ) from a vps that i have root access to another with directadmin without root access any help to do that ? Rating: 5

[Mr.KiLLeR]

u can do that through big dump

[Sp32]

I'd advise mysqldumper as I've had problems with bigdump in the past.

[Dl4uall]

i can do it it

[chems]

i think mysqldumper will take much time

[faizulhaque]

if you have access with SSH than use Commands to Get DB backup in within 5 to 10 sec.

mysql -h servername -u dbusername -p databasename < backupname.sql

servername= localhost
dbusername=you already know that
databasename=you know that too

when you press enter it will ask database password.

Use Putty for SSH is good and lite weight.

[Sp32]

If you're good at linux, do it the linux way via ssh.

mysqldumper doesn't take any longer than bigdump when it comes to backing up or downloading, why would you assume it did?

[chems]

If you're good at linux, do it the linux way via ssh.

mysqldumper doesn't take any longer than bigdump when it comes to backing up or downloading, why would you assume it did?

if you have access with SSH than use Commands to Get DB backup in within 5 to 10 sec.



servername= localhost
dbusername=you already know that
databasename=you know that too

when you press enter it will ask database password.

Use Putty for SSH is good and lite weight.

the problem is that i havent the new server ssh access

[Gavo]

You should ask for ssh access, your could do the transfer in 10-20 minutes then.

Compress your database in /var/lib/mysql & push it to the new server, then decompress.

[faizulhaque]

if you are facing any problem than post here...