Right, to start with, I am using MAMP on Mac and my localhost:8888 root directory is under users/me/sites/wordpress.
I have created a fresh, clean install on my remote server of wordpress and successfully built a site on my local server that I need to upload onto the remote server.
The issue I am having is I am following the steps as laid out in this this video (link: http://www.youtube.com/watch?v=cM9Z8aQTCvQ). However, when I get to the part where I have to export a sql of my local database (3:12 into the video) via phpmyadmin, I select my database (in this case called WordPress_Scope), it says WordPress_Scope (11) in the database drop down but then when opening it, I get the message No tables found in database. All other databases have files within the dropdown like Information_schema, performance_schema and mysql, but on this one database, it says there are no tables.
Whats more puzzling is when I go to the folder Applications/MAMP/db/mysql/Wordpress_Scope/ - All the data files are all there! this is the same root location as the rest of the databases that are being found.
I read somewhere that this may be due to a change in permissions or whatever from mysql.mysql to root.root but this means nothing to me without a clear explanation as to how to fix it!
Any help would be much appreciated. Thought it would be easier to work remotely and upload when its all done - but this is appearing to be the biggest headache EVER!