UpdraftPlus Home › Forums › Paid support forum – UpdraftPlus backup plugin › Trying to upload a backup to my recently renewed site…
Tagged: database issues, Importing backups, migration.
- This topic has 6 replies, 3 voices, and was last updated 8 years, 10 months ago by udadmin.
-
AuthorPosts
-
February 25, 2016 at 12:40 pm #145132MichaelParticipant
I was trying to use the WordPress free version and it was just not loading the dB correctly and I was at a loss.
So…I was thinking maybe if I purchased the migration plugin it would work. Sadly, to no avail.
These backups are from my Gmail account and they’re all here and in full condition.
I just don’t understand why it will not load my previous posts. Layout, etc…you know…my whole database. It will load the plugins, themes and everything else, but where it really matters it falls short.
I’m needing assistance in a bad way. My site has been down since 2013 and I thought since I brought it back up, I could just reload the backups and be good to go.
This is proving quite not the case. And I feel like I wasted 30.00 of the migration software.
Please help.
Thank you.
February 25, 2016 at 3:54 pm #145168Dee NutbourneModeratorHi Michael,
Do you have a restoration log available? You can find this log in the wp-content/updraft directory of your site.
It will be too long to post here directly, but you can use an online tool such as pastebin, and post the link here.
Best Wishes,
David NFebruary 26, 2016 at 2:41 am #145236MichaelParticipantIt says it cannot be read, but here is the cut and paste from the screen.
UpdraftPlus Restoration: Progress
Follow this link to download the log file for this restoration (needed for any support requests).
Final checksLooking for db archive: file name: backup_2012-12-25-0740_The_Axalon_490e16087683-db.gz
Archive is expected to be size: 67.3 Kb: OK
Looking for plugins archive: file name: backup_2012-12-25-0740_The_Axalon_490e16087683-plugins.zip
Archive is expected to be size: 12135.4 Kb: OK
Looking for themes archive: file name: backup_2012-12-25-0740_The_Axalon_490e16087683-themes.zip
Archive is expected to be size: 8579.7 Kb: OK
Looking for uploads archive: file name: backup_2012-12-25-0740_The_Axalon_490e16087683-uploads.zip
Archive is expected to be size: 369.9 Kb: OK
DatabaseUnpacking backup…
Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
Enabling Maintenance mode…
New table prefix: wp_iqr2d5_
Old table prefix: wp_
Restoring table (MyISAM): wp_nyzkh2_commentmeta – will restore as: wp_iqr2d5_nyzkh2_commentmeta
Restoring table (MyISAM): wp_nyzkh2_comments – will restore as: wp_iqr2d5_nyzkh2_comments
Restoring table (MyISAM): wp_nyzkh2_links – will restore as: wp_iqr2d5_nyzkh2_links
Restoring table (MyISAM): wp_nyzkh2_options – will restore as: wp_iqr2d5_nyzkh2_options
Database queries processed: 50 in 0.14 seconds
Database queries processed: 100 in 0.18 seconds
Database queries processed: 150 in 0.24 seconds
Database queries processed: 200 in 0.28 seconds
Database queries processed: 250 in 0.32 seconds
Restoring table (MyISAM): wp_nyzkh2_postmeta – will restore as: wp_iqr2d5_nyzkh2_postmeta
Restoring table (MyISAM): wp_nyzkh2_posts – will restore as: wp_iqr2d5_nyzkh2_posts
Restoring table (MyISAM): wp_nyzkh2_term_relationships – will restore as: wp_iqr2d5_nyzkh2_term_relationships
Restoring table (MyISAM): wp_nyzkh2_term_taxonomy – will restore as: wp_iqr2d5_nyzkh2_term_taxonomy
Restoring table (MyISAM): wp_nyzkh2_terms – will restore as: wp_iqr2d5_nyzkh2_terms
Restoring table (MyISAM): wp_nyzkh2_usermeta – will restore as: wp_iqr2d5_nyzkh2_usermeta
Database queries processed: 500 in 0.66 seconds
Restoring table (MyISAM): wp_nyzkh2_users – will restore as: wp_iqr2d5_nyzkh2_users
Disabling Maintenance mode…
Finished: lines processed: 523 in 0.77 seconds
Cleaning up rubbish…
PluginsUnpacking backup… (backup_2012-12-25-0740_The_Axalon_490e16087683-plugins.zip, 11.9 Mb)
Moving old data out of the way…
Moving unpacked backup into place…
Cleaning up rubbish…
ThemesUnpacking backup… (backup_2012-12-25-0740_The_Axalon_490e16087683-themes.zip, 8.4 Mb)
Moving old data out of the way…
Moving unpacked backup into place…
Cleaning up rubbish…
UploadsUnpacking backup… (backup_2012-12-25-0740_The_Axalon_490e16087683-uploads.zip, 0.4 Mb)
Moving old data out of the way…
Moving unpacked backup into place…
Cleaning up rubbish…
Clearing cached pages (WP Super Cache)…
Restore successful!Actions: Return to UpdraftPlus Configuration
February 26, 2016 at 3:39 am #145243MichaelParticipantMy Apologies…I found it…
February 26, 2016 at 10:15 pm #145371udadminKeymasterHi Michael,
I can see from the log two things:
– That it’s a backup from December 2012 – i.e. really old. Is that intended? (There were no paid UpdraftPlus products then – updraftplus.com wasn’t registered until the next month!).
– That UD is failing to detect the table prefix in the database backup, because of the old format. If you attach the database backup to a reply, I can adjust it for you, so that it will work.
David
February 27, 2016 at 1:24 am #145381MichaelParticipantThis reply has been marked as private.February 27, 2016 at 9:30 pm #145471udadminKeymasterThis reply has been marked as private. -
AuthorPosts
- The topic ‘Trying to upload a backup to my recently renewed site…’ is closed to new replies.