Restoring Database seems to miss wp-options data | Wordpress Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Lost password?
Advanced Search
Forum Scope


Forum Options

Minimum search word length is 3 characters – maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Restoring Database seems to miss wp-options data
January 9, 2011
4:36 am

Hello All,


Just started using Xcloner to test out some site backups/mirroring and I seem to have a small issue I can't solve.


Wordpress 3.03


Steps I took.

1. Installed Xcloner with no issues.

2. Kicked off a backup all is good.

3. scp'd the backup file to backup server.

4. untarred the site data

5. imported the db manually

mysql -u root -p <dbname> < database-sql.sql 

6. I tweak the wp-config.php (when I have too if I need to point to localhost)


The site loads but there are theme specific settings that are not being activated. I check the actual db backup file database-sql.sql and I see the settings that are missing in the file. I asked the theme developer and they tell me this:

“ThemeFoo stores all of the Layout & Design Options in the WordPress options table.”

I am not sure what I am missing.

I have tested the same process with other WP sites that use different themes and they restore perfectly.

Any pointers?



January 9, 2011
11:33 am
Ovidiu Liuta
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi there! Try and check the wp_options table from the original site and compare the number of records with the ones restored on the new database, are they different? If so, try and locate the missing records and see if the themes options are there


XCloner does not exclude any records from your tables when creating the backup, but if it helps, try and run repair query on your original database and try the backup again!



Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 737
Members: 9628
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Waldek Sik
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0