I have created my website in php and database in mysql on my local computer (Environment: WinXP Home, Apache, PHP, MySQL), and its working fine on my local computer.
So, I recently registered a domain name and also the hosting plan from GoDaddy.com. They provide PhpMyAdmin interface inorder for us to work with our database on their server.
From that interface (they call it controlview) I can create tables, run SQL statements. There is also an option of running SQL statements by selecting a file even it is located on our local computer.
So, inorder to upload my database from my local computer to the hosting server, I have dumped my database to a .sql file and tried to execute it from the controlview considering that it will create all my tables with data in them. It is executing that .sql file and tells that your sql statements have been executed but I dont see any tables created. I contacted GoDaddy but it looks like those people are not familiar about that as well as I couldn't find any articles on the internet also.
Please provide help in uploading my database from my local computer to my hosting server, as that is the only thing stopping me in launching my website. Help would be appreciated.