Transfering from another VPS company to Linode

If it's not too complex, it sounds to me that building from scratch and copying over the files is a good way to go.

As for MySQL, I think mysqldump is the way to go, then you can just import it in the new database.

thanks I thought if I did that I would have to do all the databases individually but them I discovered you could do all at once…

Is this correct:

> mysqldump –all-databases> backup.sql

mysql -u root -password < backup.sql

Thanks.

I think that is more or less the exact thing I do for backups, so yeah.

Yep that's fine but it maybe faster to do this

mysqldump –all-databases | gzip > backup.sql.gz

then transfer over ssh

and run gunzip backup.sql.gz | mysql -u root -p

That way it's compressed and SSH transfer time will be reduced

Great advice will try that - thanks all

@obs:

Yep that's fine but it maybe faster to do this

mysqldump –all-databases | gzip > backup.sql.gz

then transfer over ssh

and run gunzip backup.sql.gz | mysql -u root -p

That way it's compressed and SSH transfer time will be reduced

Pfft, skip the intermediate step, pipe it right through mysqldump/gzip/ssh/gunzip/mysql in a single command without ever hitting the disk :P

(Note, I'm joking, although you can do this)

lol - actually I saw this example

> mysqldump -u sadmin -p pass21 Customers | mysql –host=202.32.12.32 -C Customers

from ~~[http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/" target="_blank">](http://www.devshed.com/c/a/MySQL/Backin … atabase/2/">http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/](

which basically does what you say?

Except it does it by exposing the MySQL servers directly to the public Internet (or at least one of them), as opposed to doing it safely over SSH.