I have been using a free web host while I set up my WP site. Now that it's all done I went and bought hosting from Namecheap.
I uploaded the site and WordPress and everything seems to look fine, but I think I may have problems with my WP database. I couldn't figure out a way to import my old sql database which I have saved. So now my wp-config file is connected to my old sql database from the free host. My site still displays normally, but I'm guessing this will cause problems somewhere down the road.
After this, I created a new database, user, and password from my Namecheap cPanel. However, with Namecheap there is no option to choose a host and it didn't tell me what the host was. So I took my old wp-config file and updated the database's name, user, and password. I left host a lone and it's still left as my old host before I switched to Namecheap hosting. With this wp-config file uploaded, the site again loads normally.
So with either wp-config file the site loads properly, but I don't think it's set up properly. Does anyone know what I should put for host in my wp-config file for Namecheap? Also, will I be fine using my newly created database for Namecheap or do I need to import my old database from the free host?
If I do need to import the database, how do I do that? I don't see any obvious options for it in the cPanel?