I am pretty new and the plugin for backing up works great. But I was trying to make changes and now there is html weird code in the few posts I have written which replaced the apostrophes and quote marks. I want to only replace the table with the posts in it. It's so easy to back up. But I don't understand how to restore and the instructions seem to be for the whole thing. I have these daily sql.gz files in my email. I just don't get how to use them to restore. Thanks. Susan
The "*sql.gz" files are just zipped text files. If you want to restore the entire database, it's simple to use PHPMyAdmin to upload the zipped file.
If you want to restore just one table, then you'll need to unzip the file. Windows usually can't do this by default, but you can download free programs that will do so.
Once you have the unzipped *sql file, you can edit it with a text editor like Notepad (make sure you back up the file first). If the wp_posts table is the one you want to restore, look for
# --------------------------------------------------------
# Table: 'wp_posts'
# --------------------------------------------------------
#
# Delete any existing table 'wp_posts'
#
DROP TABLE IF EXISTS 'wp_posts';
#
# Table structure of table 'wp_posts'
#
CREATE TABLE 'wp_posts' (
and copy it and everything until
#
# End of data contents of table wp_posts'
# --------------------------------------------------------
Save that copied part as a file ending in ".sql", and then follow the PHPMyAdmin instructions, except using your newly created file with just the wp_posts table.
Well, I sort of did it. I deleted the contents of just that one table and then used the SQL to put each one back. But the reason I had to do this is that there is crazy code in place of things like apostrophes and quote marks. And they are there in the reverted version. It wasn't like this a few days ago. I know this isn't technically about backing up, but it's a mess. Thanks for your help. The site is http://www.theuneasyrider.com
Susan
I am pretty new and the plugin for backing up works great. But I was trying to make changes and now there is html weird code in the few posts I have written which replaced the apostrophes and quote marks. I want to only replace the table with the posts in it. It's so easy to back up. But I don't understand how to restore and the instructions seem to be for the whole thing. I have these daily sql.gz files in my email. I just don't get how to use them to restore. Thanks. Susan
The "*sql.gz" files are just zipped text files. If you want to restore the entire database, it's simple to use PHPMyAdmin to upload the zipped file.
If you want to restore just one table, then you'll need to unzip the file. Windows usually can't do this by default, but you can download free programs that will do so.
Once you have the unzipped *sql file, you can edit it with a text editor like Notepad (make sure you back up the file first). If the wp_posts table is the one you want to restore, look for
and copy it and everything until
Save that copied part as a file ending in ".sql", and then follow the PHPMyAdmin instructions, except using your newly created file with just the wp_posts table.
Well, I sort of did it. I deleted the contents of just that one table and then used the SQL to put each one back. But the reason I had to do this is that there is crazy code in place of things like apostrophes and quote marks. And they are there in the reverted version. It wasn't like this a few days ago. I know this isn't technically about backing up, but it's a mess. Thanks for your help. The site is http://www.theuneasyrider.com
Susan
Under Options > Reading, what does it say your character encoding is?
UTF-8
RSS feed for this topic
Reply
You must log in to post.