WordPress.org

1. vguy
   Member
   Posted 6 months ago #

   Hello, I have one (actually several) problems because I want to restore my blogs without the original files. I will explain better:

   I had three blogs on a paid server, these two blogs I posted the drafts in an account in blogger that I still have, the other blog I posted everything on the paid server. So when you open the posts of two blogs the photos were downloaded from the blogger, not the paid server.
   I spent a long time without posting these blogs and ended up not paying a monthly fee and my account was canceled. That means, I lost everything I had on these servers. The backup files that I have, are the ones emailed to me by the plugin WP-DB-Backup.

   Now I hired a new host with the same domain, and would like to restore the old blogs. I installed wordpress and tried to restore following the tutorials I found on the net (with myphp), but obviously not been successful. The problems are that the new database is with a different name than the original and I do not have the original files in the folder "wp-content" with photos and so on.

   Is possible to restore the blog without these folders, for posts with all the pictures I have stored on blogger? And the blog that has no picture on another site, it can be restored that I manually correct the absence of these photos later? The most important thing for me are the backup posts (obviously) and comments. And finally, can I restore with no theme and plugins that were installed on the other server?

   Please, help me.

2. ChristiNi
   Member
   Posted 6 months ago #

   Hi vguy,

   In order to restore your posts, you'll want to import your old database backup to your new database through phpMyAdmin:

   http://codex.wordpress.org/Restoring_Your_Database_From_Backup

   This will only restore your posts, pages and plugin settings. You will still need to add your images back into posts and pages.

   You could also ask your previous hosting provider if they could provide you with a backup of your site files so you could restore your wp-content folder.

   Hope this helps!

3. vguy
   Member
   Posted 6 months ago #

   Thank you Christini, but I already did this steps on phpMyAdmin, I even had a "success" message, but nothing changed on my blog. Do I have to activate anything after that? Or it is automatic?

4. ChristiNi
   Member
   Posted 6 months ago #

   Hi vguy,

   Did you import a backup of your old database into the new database? Did you double check the backup to make sure it contains data? Depending on your backup, you may need to "drop" existing tables in the new database first (see the section on"Importing a Database using phpMyAdmin"):

   http://www.webhostinghub.com/support/website/databases/creating-importing-exporting-databases

   Finally, have you tried refreshing the page and/or clearing your browser's cache to make sure you are not viewing a cached version of your site?

   Hope this helps!

5. vguy
   Member
   Posted 6 months ago #

   Thank you for the help Christini, but the problem still persist. I drop the tables before upload the new database, but is not working. But I notice something in the db. The tables from the instalation of wordpress starts with "apswp" (example: apswp_comments), and the tables from the db that I upload starts with "wp" (example: wp_comments).
   I think that's why the wordpress doesn't recognise the old data. Is that a way to change that?

6. govpatel
   Member
   Posted 6 months ago #

   What prefix you want to use as they need to match with what you have in wp-config.php file.

7. vguy
   Member
   Posted 6 months ago #

   Perfect!!!!!!! The backup is now working, without any of the original files, only with the database!!!! Thank you govpatel!!!

   I changed the information in the wp-config.php, to this.

   * You can have multiple installations in one database if you give each a unique
   * prefix. Only numbers, letters, and underscores please!
   */
   $table_prefix = 'wp_';

   After that I refreshed the admin page, and updated the database. With this done my whole site was back(!!!) of course, without the plugins and pictures. I had one issue when I access the website, because it showed me a blank page. This was solved when I refreshed the theme.

   Thank you Christini and govpatel!!!!! The problem is solved!!!!!

8. govpatel
   Member
   Posted 6 months ago #

   You are welcome glad to know that you have your problem solved.
   if you upload wp-content folder from backup you will have your plugins,themes,and uploads.

Reply

You must log in to post.