Due to the frequent question: “How to recover a corrupted site / database?”. I will describe three practical and easy ways to recover the website in case of failure. But remember, your main duty is to have an efficient copy.
“The blonde” – if you were so stupid that you forgot about the regular backup then you become a “sweet blonde”and write to the administrator of hosting your site to restore from a backup. In general, this is going, but some companies are doing the customer a copy of the pages is true every day, but keep it only for 7 days, or worse, a shorter length of time. In general, it is also a copy of the database itself, but as we know are articles (content) is very difficult to recover.
“The Greek” – at once an explanation of this follows from the fact that the authors of Akeeba Backup are from Greece. So if you have a full copy, you can feel safe. Remember to always unknown before installing these “miraculous” extensions click Backup. I assume you have a copy of such a full and, thus containing both files and database. If you want to restore only the database is sufficient that this package extract only one folder “/installation” and copy it to the server. Use Akeeba eXtract Wizard – this is a cross-platform archive extraction utility, designed to extract any ZIP, JPA or JPS archive on your desktop. Than rename the file configuration.php in the root folder and run the page. If you see a slightly different view than the normal installation setup, this should reassure you, now known type of file over the MySQL database and browse the entire importing process. After a few moments, your site should work. If you have not changed the database prefix, you can restore the old configuration.php file. It should work, also. Remember, if in the meantime you have installed an extension of their files are still there and if you try to install them again it will certainly Jooomla screamed that he could not the above mentioned reason. Thus, you must manually delete the unnecessary folder (s).
“The magician” – this solution is useful when you have only a “clean” database. Then you need to use management tools such as databases PHPMyAdmin – those included with most hosting panels. You log into the database username and password. Then you select the Import button, then pointing at the file from the database and start the process. This method should also work in 100%. Remember that the database is encoded in UTF-8.
I installed the second website on the same database, and now the first one does not work – what now?
Ifbyhisabsent-mindednessinstalledanotherinstallationof Joomla!onthesamedatabase, whichresulted inthe “old”sidestoppedworking, you probablyfeelthe panic.Monthly/weeklywork…gone,butare you sure?
You have a chance to return to work. Yes, of course, you can write to the admin to restore the backup, but there is also another way. Since the default (without changing any settings) the new Joomla! they find archives database by giving it the prefix “bak_” there is a chance that both parties will work on the same database. Go therefore to the folder where you have a dead page, then copy the configuration.php file to disk. Open it in the editor and make simple changes (line 37), as follows:
var $dbprefix = ‘bak_’;
Save the changes to the file, now you can copy it to the server. Refresh the web, it should work. Of course, it is best to check in phpMyAdmin control panel, whether such a database is maintained, but it is a good chance it will. However, if during installation you have selected the options Remove the old database is, unfortunately, but you are left with the humble e-mail to the helpdesk hosting.