Experienced administrators know firsthand that the preservation of the database backup and recovery enable it as a result of an unexpected failure to save a lot of your work.
Therefore, the ability to restore the database - a key management skill.
To restore the database, you need to have itbackup with the latest changes. To do this, after each new operation or to experiments on the code of your database, you can import it to your computer as a backup or sql-file.
Open your browser. In the address bar, enter: localhost. Of the proposed values, choose Phpmyadmin. Visit Phpmyadmin panel. First of all, remove the damaged as a result of the failure of the table. To do this, select the name of the corresponding database in the left column and in the open list of tables, click the link at the bottom of "Mark." Next, click on the field "With Selected" from the list that appears, select "Delete." Confirm the action in the popup window.
Now navigate to the folder on your computer wherekept stored database. If you saved it in sql format, simply open the document and copy the code for the document to the clipboard (Ctrl + A - select, Ctrl + C - copy). Then sign in Import Import phpMyAdmin, select the database that is to be restored, and in the SQL tab, paste the contents (Ctrl + V) into the input box query.
Click "OK", and after a certain time in the case ofsuccessful operation appears on the command line «SQL-query executed successfully." If it does not, then the volume table is too large, and it is better to download the database via the import command.
Back up your sql-file using a programWinrar or 7-Zip. Please note that the name of your file should contain the format and compression (for example, base.sql.zip). Once you have correctly registered the file name, go back in Import Import phpMyAdmin, select the database and select the tab "Import".
Pressing the "Select File", find with the help ofthe conductor had just made the archive. Select it, set the encoding is utf-8. Click the "check mark" next to the words "Allow script to split the import process" and select SQL format. Click "OK". If there are no new errors, you will receive a message: "File Import completed successfully."