Question: Restoring a database backup

Answer: The easiest way to restore the backup of your Geeklog site would be from the command line:

    mysql -uuser_name -p -D database_name < backup_file

replacing user_name, database_name, and backup_file with the proper values, of course.

If you don't have access to the command line on your server, use phpMyAdmin to upload and restore your backup.

With phpMyAdmin, you may be running into timeout issues, though, when you have a large database (this should not happen if you do the restore from the command line). You may have to ask your hosting service for help here. They should be able to restore the backup for you or will be able to point out other options to you.

Hits: 257

FAQ » Usage » Restoring a database backup