Hi i want to upload the mysql backup of my article site to my new article site which is this www.articlesauce.com .. I want to restore all of the articles from my previous site transfer to my new article site.. please advice. Im using cpanel.
Cpanel has an option to restore a full site but it's more likely the script be installed outside the public_html The advisable is unpack your backup, upload manually your files and using phpMyAdmin for dumping your database. However, if it is big in size, you should better try bigdump: www.ozerov.de/bigdump.php
If your mysql backup is not too big, try to use the Restore feature of Cpanel. Its on the same page as the backups. If its big enough and you know how to navigate via Phpmyadmin, better use it after unpacking your backup for the dump. Normally, the restore function with CPanel works. So try it first.
I've just followed someone's instructions to create a backup of my website's database using the mysldump command. What is not clear now is this. The backup file which I saved to Desktop is a .sql file but appears just the same as and has the same icon as an ordinary text file. Is this the way it's supposed to be and if a disaster were to strike my website, would this be all that's needed to restore it to its configuration at the time this backup was performed? Thanks for any knowledge shared.