update-mysql-database.md

update-mysql-database.md

Login to server with database

SSH server you're copying from than:

scp -i ~/.ssh/id_dsa.pub /[file].sql [user]@[server]:/[folder]

Login to dest server

Login to server you're copying from, than drop database and update

mysql -p [user] -u

drop database [database name];

CREATE DATABASE [database name];

Load the new database

mysql -u [database name] -p [database name] < [file].sql