Categories
Linux

Do it easy – Transfer your MySql and Files

Transfer from a ftp to your server:

wget -r ftp://user:password@server.com/dir/*

Transfer your BBDD:

mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname

Also, how to enable remote connections to your mysql:

Edit file my.cnf : vi /etc/mysql/my.cnf
Search for: bind-address = 127.0.0.1
Replace with: bind-address = 0.0.0.0 (to allow all machines)
This line must be commented: #skip-networking
Restart mysql: /etc/init.d/mysql restart