brining back to life a blog – database backup

  • A few months ago, I had some unfortunate events in my life.So, I didn’t pay my host anymore – my ftp files are gone but I do have database backups. I used 2.3.3 even if 2.5 was available at that time, the 2.3.3 version was a sentimenal one for me, sort of…
    OK, now, I install a fresh 2.6.3 wordpress – the database is being filled with tables, I delete them, I import my old database and… SURPRISE: whenever I test my blog in the address bar it automatically redirects me to another subdomain of mine even though I don’t remember ever been doing any changes to my blog to another subdomain. I edited the database sql file, I looked for the subdomain URL and I found these lines:
    INSERT INTOwp_optionsVALUES (1, 0, 'siteurl', 'https://subdomain.example.net', 'yes') ;
    and
    INSERT INTOwp_optionsVALUES (39, 0, 'home', 'https://subdomain.example.net', 'yes') ;

    What do I do? If I correct those lines with the actual subdomain which used to be my blog, it only shows me the “nothing found” themes’ page.

    Again, how can I solve this?

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter ziont

    (@ziont)

    Anyone?

    you cannot import a 2.3.3 dump into a 2.6.3 database. they do NOT use the same database schema

    you need to install the version that matches the dump, and then UPGRADE.

    thats why youre getting the ‘”nothing found’

    ignore the other stuff until youve taken care of what I have just described.

    install 2.3.3, import the db, change those 2 settings (who cares why theyre there, (maybe you dont remember))… then UPGRADE.

    Thread Starter ziont

    (@ziont)

    OK. After I hit the UPGRADE button, my homepage is still “NOT FOUND” and when I try to log in, it tells me “invalid user”. So I went to my wp_users table and ran a query through which I’ve created an wordpress admin user (something like “insert into wp_users values (‘1’, ‘admin’,’pass’, ”, ”, ‘etc’…).

    Now, my home page is still the “NOT FOUND” one and when I try to log in, I get this error page about permissions: “You do not have sufficient permissions to access this page.”. I’ve done some research and still couldn’t find a straight answer. What can I do now?

    Thread Starter ziont

    (@ziont)

    I feel like I’m going insane… I’ve searched through this forum and got 81 results and none of them fixed my problem…

    Thread Starter ziont

    (@ziont)

    … I get the same problem with 2.7. What can I do now?

    OK. Let’s start over.
    1. My subdomain blog is empty. I restored my old database backup.
    2. I’ve uploaded the 2.7 wp admin files.
    3. I have replaced the new wp-config file with my old one.
    4. I still get an error on my homepage “NOT FOUND” and it seems like my user admin does not exist.
    WHAT CAN I DO NOW?

    See if this helps.

    1. Use the latest 2.5 source code from the following download site to start with.

    https://www.ads-software.com/download/release-archive/

    2. View the following video about upgrading to 2.7…knowing you are going to upgrade to 2.5.1

    https://educhalk.org/blog/?p=17

    3. Once you have done that upgrade, then do it again and go to 2.6.5

    4. Then do it one last time and go to 2.7.

    Thread Starter ziont

    (@ziont)

    Thanks figaro but it’s not helping.
    I have changed my server, ok? But I do have my blog database backp (generated by the plugin database backup).

    Now, I don’t know how to bring to life my blog since I’ve tried every combination i could think of…

    What else can I do? Please, It would mean a lot to me!

    If you want me to take a look at it, upload your backup somewhere and send me a link so I can download it. I’ll take a look at it and see if I can bring it back to life…if so, then I’ll let you know how to do it. You can send the link to 234figaro432[at] gmail [dot] com

    Thread Starter ziont

    (@ziont)

    That’s not so confortable figaro. I can think for one reason: I don’t know you…

    No problem…it was just an offer of help…good luck.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘brining back to life a blog – database backup’ is closed to new replies.