1. Create new account on your hosting
2. Choose user name and password
3. Open Navicat 8 fro SQL
4. Choose folder drupal 6
5. Choose all tables of the site -> right click -> dump sql file -> choose place where you save it
6. Go to IP/cpanel
7. Enter user name/password you got after creating account
8. Click on My Sql Data Base Wizard
9. Choose name of the database
10. Click on next step
11. Choose user name and generate password (tip: do not use symbols in the password)
12. Create new user
12. Check box ALL PRIVILEGES
13. Click on next step
14. Click on return to home
15. Click on My Sql Database
16. Click on Add User To Database
17. Click on Add button
18. Click on Home button
19. Click on phpMyAdmin
20. Choose on left side your database
21. Click on import -> browse – check if Character set of the file – utf8 is the default -> click on go -> get the message “Import has been successfully finished, xxxx queries executed.”
22. Go to setting of your site
replace username, password and databasename with data you got in N9 and N11
$db_url = ‘mysql://username:password@localhost/databasename’;
23. Upload settings file to the server.
24. Change DNS of the domain to DNS you got after creating new account in N2.
25. Wait 24 hours