Database backup always truncated

  • fpwordpress

    (@flaviowordpress)


    2 years, 7 months ago

    Hello, I have just found out that your database backup (either saved at hosting level or sent by mail) are truncated before the end, when writing the wp_yoast_seo_meta table, making the backup useless.

    This is the last line which is written:
    INSERT INTO wp_yoast_seo_meta VALUES (“319″,”0″,”0”);

    It happens regardless of database size (.sql files also as small 1.5MB).

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • nlpro

    (@nlpro)

    2 years, 7 months ago

    Hi fpwordpress,

    Is that INSERT an actual copy/paste from the database backup file ?

    Just as a sidenote: It looks like the wp_yoast_seo_meta table was deprecated almost a year ago in the Yoast SEO 14.9 release. So simply deleting this table from your database is an option 😉

    +++++ To prevent any confusion, I’m not iThemes +++++

    Thread Starter fpwordpress

    (@flaviowordpress)

    2 years, 7 months ago

    Hello nlpro,

    Thank you for your reply.

    Yes, the SQL line above has been copied and pasted from the original .sql backup file. It was the last line, and after that only 4/5 empty lines.

    As per your sidenote: do you think that the wp_yoast_seo_meta table should be deleted, or can it remain where it is? Could it be the cause of the truncated code?

    nlpro

    (@nlpro)

    2 years, 7 months ago

    Hi fpwordpress,

    As per your sidenote: do you think that the wp_yoast_seo_meta table should be deleted, or can it remain where it is?

    I think it’s safe to delete the table, but it’s probably best to doublecheck this in the Yoast SEO plugin forum.

    Could it be the cause of the truncated code?

    It could be. Delete the table and find out in the next database backup that gets created 😉

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database backup always truncated’ is closed to new replies.