Q: How do I restore my database from a backup?

A: Briefly, use phpMyAdmin, which is included with most hosting control panels. This page has more details and links to further explanations.

-----------------------------------------------------------------

Q: My backup stops or hangs without completing.

A: If you edit the text of wp-db-backup.php in a text editor like Notepad, you'll see around line 50 the following:

/**
 * Set MOD_EVASIVE_OVERRIDE to true
 * and increase MOD_EVASIVE_DELAY
 * if the backup stops prematurely.
 */
// define('MOD_EVASIVE_OVERRIDE', false);
define('MOD_EVASIVE_DELAY', '500');

Do what it says: un-comment MOD_EVASIVE_OVERRIDE and set it to true like so:

define('MOD_EVASIVE_OVERRIDE', true);

That will slow down the plugin, and you can slow it even further by increasing the MOD_EVASIVE_DELAY number from 500.