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
- Improve your SQL queries
- Error reporting for PHP
- Banned sites with Squid proxy
- Ubuntu 9.10 Karmic Koala in Eee PC 1101HA
- Improve LAMP performance, for low cost servers or VPS
- How to Steer Comments in the Right Direction
- How To Organize Email
- Contest: Win $10 Gift Card from Barnes and Noble
- How to Use Your Corporate Blog for Networking
Help sharing and Flatter me ;)
