Migrating Websites with databases

1. Create ‘table’ folder on old website.

2. Sql dump all databases

cd …/’table’
mysqldump -u[username] -p[password] –opt datanamename > databasename.sql

3. FTP all files/folders to local PC

4. Create new folder “sitename” on new site

4.5 add domain name

6. FTP all the files to new site in sitename folder

7. create new database in phpmyadmin

8. on new site in tables folder sql load all databases
mysql -u[username] -p[password] datanamename < databasename.sql

9. check database in phpmyadmin

10. change password in on config files

11. Test Website.

12. change the DNS settings for site