WordPress.org

Ready to get started?Download WordPress

Forums

Data base backup and restor on new one help (23 posts)

  1. xctechs
    Member
    Posted 2 years ago #

    My database while updating got Fatal Error, i tried every way didn't help, now if i install a new database with latest versoin of WP, is there a way to bring the old database to new one i created without loosing all my blog??

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    Do you have a pre-upgrade database backup?

  3. xctechs
    Member
    Posted 2 years ago #

    no that i don't have :(

  4. xctechs
    Member
    Posted 2 years ago #

    I can view my blog no problem only thing is when i login as admin it giving me Fatal Error

  5. esmi
    Forum Moderator
    Posted 2 years ago #

    Ask your hosts if they have a database backup that you can use.

  6. xctechs
    Member
    Posted 2 years ago #

    good idea

  7. xctechs
    Member
    Posted 2 years ago #

    they don't, so that means i have to start from scratch

  8. esmi
    Forum Moderator
    Posted 2 years ago #

    Can you examine your database - specifically the wp-options table?

  9. xctechs
    Member
    Posted 2 years ago #

    how do i do that please?

  10. esmi
    Forum Moderator
    Posted 2 years ago #

    Using Phpmyadmin or whatever database management tool your host provides.

  11. xctechs
    Member
    Posted 2 years ago #

    I try to login i am getting fatal error but going back to blog i can see blog and the banner coming on the top that i have so many comments and all but when i click on them i getting fatal error again,

    but when i click on plugins i can see the dashboard

    almost all of them giving me error msg except plugins

  12. xctechs
    Member
    Posted 2 years ago #

    I am in my phpAdmin

  13. xctechs
    Member
    Posted 2 years ago #

    I can see my wp-options it says

    wp_options 309 MyISAM latin1_general_ci 392.7 KiB 12.8 KiB

  14. esmi
    Forum Moderator
    Posted 2 years ago #

    Look in the wp-options table for the option name db_version and tell us the option value number.

  15. xctechs
    Member
    Posted 2 years ago #

    db_version is on page 2 and value is 17056

  16. esmi
    Forum Moderator
    Posted 2 years ago #

    Are you sure that it isn't actually 17516?

  17. xctechs
    Member
    Posted 2 years ago #

    That is the value i have cut and paste it its 17056

  18. esmi
    Forum Moderator
    Posted 2 years ago #

    There's no such database version number. If that is the value in your database, then I'm afraid that the database appears to have been trashed. And without a backup copy, there's no way to restore it. :-(

  19. xctechs
    Member
    Posted 2 years ago #

    crap, that only thing i tried to do was update :(

  20. esmi
    Forum Moderator
    Posted 2 years ago #

    I am sorry :-(

    But this is why the upgrade notice recommends that you backup your database before you begin.

  21. xctechs
    Member
    Posted 2 years ago #

    damn i have to build it again :( good thing is i can't carry on but i can still just copy page by page to new board :( is there a way to change date on submission ?? on new board?

  22. fonglh
    Member
    Posted 2 years ago #

    Yes just edit the date above the Publish button.

  23. xctechs
    Member
    Posted 2 years ago #

    cool thank you my friend now i will fix my data base just matter of time ;)

Topic Closed

This topic has been closed to new replies.

About this Topic