Topics

User Functions

Events

There are no upcoming events

What's New

Stories last 2 weeks

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Thursday, April 17 2014 @ 05:24 PM EDT

Restoring a database backup

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.

FAQ Manager » Usage » Restoring a database backup