Broken link to theme asset after restoring backup
Check your wordpress db table wp_options and from there check option name : siteUrl and home url and change %20 from there.
backup
Backup custom table
No it does not, it will only export all of your posts, pages, comments, custom fields, terms, navigation menus, and custom posts. https://codex.wordpress.org/Tools_Export_Screen
WordPress manual restore not completely successful
Problem seems strange since you can see the content in the backend but not able to see it in the frontend. So here are a few suggestions. Try to save the permalink again? And try to clear the cache too. Try to change the theme to any other basic theme available. Also when I tried … Read more
Which Blog Client for Windows/Linux has the best support for backing/restoring your posts?
It is not really direct answer to your question, but I think complete (database plus files) backup/restore is more comprehensive and important. Content backup is only content. Database is all of your blog, which can help you go from nuked database back to normal in no time (speaking from sad practical experience, that would be … Read more
WordPress staging environment that syncs everything except posts?
It’s a hard problem to solve. Would this answer be any more helpful? Easily Move a WordPress Install from Development to Production? I know it’s not a perfect solution, but it is a start. P.S. I’m working with some others to solve the bigger problem with a plan to release as part of a GPL-licensed … Read more
Managing Backups: Space Issues [closed]
You can use a plugin like backwpup that lets you: Store backup to Folder Store backup to FTP Server Store backup to Amazon S3 Store backup to Google Storage Store backup to Microsoft Azure (Blob) Store backup to RackSpaceCloud Store backup to DropBox (free) Store backup to SugarSync (free) and manage the number of backup … Read more
How does the WXR file differ from the WPDB?
There’s not a one-to-one relationship between the WordPress database and the .wxr file. We can find this line in the exported .wxr file: <!– This file is not intended to serve as a complete backup of your site. –> Skimming through the export_wp() function, we can see what’s excluded, for example: The data stored in … Read more
What happens if I overwrite the current wp_options table with a backup from a week ago?
The wp_options table holds a lot of information, whether you deem it important or not really depends on what plugins and information you have set up on your website and how important your website is to you. For example as you’ve noticed it can hold the information for your active plugins, if you activate an … Read more
For WordPress is there content in the database which I can safely ignore?
The only things you could clear out like this are transients, temporary options in the database. WP already does this on a cron job, and it’s unlikely to have a big impact. If you don’t mind data loss, revisions might reduce the database size, but that’s highly dependent on what you’ve been doing with the … Read more
Updating to new 3.0.5
Updating is always important. They contain security fixes and other bug fixes. Generally update within the 3.0x considered safe. Moving between 3.x could require some changes and updates to your theme or plugins. I like to take the mantra, better safe than sorry. I would back up your database and anything your wp-content folder (plugins, … Read more