I've been going through a couple threads now and I feel like I'm on the brink of solving this issue. I just need a little push from the more experienced users.
My situation in full:
I first got my godaddy domains and immediately went and installed wordpress which was running on the web. I tinkered in that for a while until i got some tutorials from lynda.com saying the best way was to go localhost. So I did.
I'm running MAMP on my macbook pro. I installed it and wordpress locally and have been working for the last month preparing my website for upload. Today we were supposed to go live.
I FTP'd all my wordpress file structure to Go Daddy server. The problem then became getting my .sql backup from mamp onto the FTP client so it could read it and upload it. At first i didn't know how to do that but after some research i found how to export the .sql file from the phpmyadmin tool in MAMP. I uploaded the file to the FTP site and tried to restore the DB from there. However, on GO Daddy the file does not appear as an option to restore from. There is another file available which is half the size of my current DB.
I've since created a new DB on GoDaddy and changed all the 'hostname','password', and 'databasename'components within my wp-config.php file to match the settings of the NEW DB on my ftp client.
My problem is now that:
1) the database online has all the tables of the localhost site, but the changes i've made do not reflect on the site.
2) my local host is not accessible. "Error establishing a database connection"
I feel like I'm really close to solving this issue. Can someone please point me in the right direction. I appreciate it greatly.