WordPress.org

1. ravenna1
   Member
   Posted 2 years ago #

   I backed up a db using PHPMyadmin from one host, and had the DROP Table box checked per the support tutorial.

   When I logged into the new host and imported the backup using PHPMYADMIN, it just adds tables. IT doesn't load the data into the existing tables. Now I have wp_comments and wp_is2vox_comments.

   The versions of WordPress are different but that hasn't seemed to matter a ton. the new host just has a one click installer so I used that. Do I need to delete the new blog and db, then reinstall it without a db, and create a db then import?

   thanks for the help.

2. s_ha_dum (was apljdi)
   Member
   Posted 2 years ago #

   The versions of WordPress are different but that hasn't seemed to matter a ton.

   It could matter actually. Open your backup files in a text editor, not a word processor like MSWord, and see if there is any post content in there and not just the command to create the tables. .sql files are readable just a bit weird looking. You should be able to find your posts and comments without too much trouble. Do not edit the file and do not re-save it. Just open it, look around, and then close it.

3. ravenna1
   Member
   Posted 2 years ago #

   Ya the posts are there. I know a little about this stuff. Just not much.

   Does that help you know what I need to do next?

   thanks

4. s_ha_dum (was apljdi)
   Member
   Posted 2 years ago #

   Do you have one file or a bunch of files? I'd think that either 1) there is weird character messing things up or 2) maybe you need to break the file up to get it under a server file size limit.

5. ravenna1
   Member
   Posted 2 years ago #

   NOt sure I get it.

   The issue as I understand it is that I did a one-click install for a wp-blog. So it setup a db for me. So when I went to the new db in PHPMyadmin there is already tables in there.

   Then I did an import and I have similar tables.

   I only have one .sql backup file that I exported from PHPMYADMIN on the old host.

   My question is, should I delete the blog, and the db, install the blog without a db, using the one-click install, and then create a db manually, with no tables, then import the tables.

   The Oneclick install setup the tables when I did it. and they have those prefixed names, so its going to look in those names anyway...

   The other option in my mind would be to find the table names in my backup sql file and rename them to what the one-click install created.

   thoughts?

6. esmi
   Theme Diva & Forum Moderator
   Posted 2 years ago #

   Try creating a new, empty, db. Import your backup into the new db and then edit your wp-config.php file to point to the new db.

7. ravenna1
   Member
   Posted 2 years ago #

   Did that and I am getting the: The page isn't redirecting properly, Error. There was no redirect on the old server blog. In fact the urls are exactly the same.

   I can access the admin login, but the login doesn't work. I also can't do a lost password lockup.

   this thing is so frustrating.

   Would one option be to put the dns back to the old server, upgrade all the wordpress stuff, re-backup the blog and then turn it back to the new server, load up the new backup?

   thanks

8. esmi
   Theme Diva & Forum Moderator
   Posted 2 years ago #

   That might be easiest. I think that the version difference is complicating things here.

Topic Closed

This topic has been closed to new replies.