I am moving old blog to new domain.
on the new domain i have created sub domain http://www.xyz.mysite.com i have installed new wordpress.
1-from old blog i have copied all my wp-content folder/sql database.
2-created new database/user
2-changed wp-config.php to reflect new database names.
4-opened sql databse file and replaced all instances of http://www.oldsite.com to http://www.xyz.mysite.com
Questions
1-when i went to import the sql database getting an error #1046 no database selected.
2-also do i need to change?what is this?
define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');
3-do i import database first my sql database then move my wp-content (replace on default existing installation) and wp-config.php files?
4-what else do i need to change,i still see /home/esthetac/public_html/mysite.ca
what is this esthetac?
5-does it matter if i am moving from old version of wordpress to new version (latest)
thank you in advance,