If you read my previous message you will see where i said i wanted to move the site to a sub-domain (subdomain.domain.com) so i can redevelop it and change theme before moving it back to the normal domain (domain.com) in other not to disrupt public users. Now to do this, the database needs to be edited (change URLs etc sub-domain.domain.com). which was why i downloaded the database to my PC for edit. The problem is uploading it back to the godaddy web server. The database is about 300mb which is too large to upload via PhpMyAdmin. I needed an option.
But i have been able to upload it using SSH remote transfer.
Thanks so much for your time, i really appreciate.
But again, now i changed the wordpress theme and i discovered that all posts thumbnails have disappeared. How can i restore post thumbnails please... ?