wp_options Table crashed any way to backup posts only via phpMyAdmin?

  • uipoka

    (@uipoka)


    8 years, 4 months ago

    Hello,

    One of my site was giving error today “Error establishing a database connection” then I checked everything changing the sql user password, creating new user but nothing worked then I manually browsing my sites sql tables via phpMyAdmin then when I tried to check wp_otions it was giving me an error
    ” #144 – Table ‘./my_database/wp_options’ is marked as crashed and last (automatic?) repair failed”

    In that case what can I do? I can only think of doing a backup of my posts as my last backup was taken at 12-Nov-2015 and after that I published new posts daily. How do I export all newly published post ( or all post) and then import those new or all posts safely from my crashed database to my backup database? Which table contains all my post? I know everyone is busy at this time of the year but I need help so any help would be appreciated. Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Marios Alexandrou

    (@marios-alexandrou)

    8 years, 4 months ago

    Posts may have related records in other tables so you would need to restore more than just the wp_posts table.

    I think you’d have a better chance of success restoring the backup database (to a temporary location) and copying the data from wp_options.

    You’re in a tricky spot here so be sure to have current backups in case you have to go through the process a couple of times to get it right.

    Thread Starter uipoka

    (@uipoka)

    8 years, 4 months ago

    Marios Alexandrou Thank you so much for replying to my post. After a lot of search and your advise I think that will be the most efficient way to recover it. Now I have created a new database and uploading the backup sql there then I will export only wp_options table, then will delete the main wp_options table from the current corrupted database then will import the wp_options table which was exported from backup. Lets see if it works or not.
    There was a way to update wordpress with mysql I can’t remember how to do it. Marios Alexandrou do you know buddy how can I do that? Thanks again.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_options Table crashed any way to backup posts only via phpMyAdmin?’ is closed to new replies.