Wrong sql execution

  • maxidavis

    (@maxidavis)


    4 years, 7 months ago

    Hi there,
    I accidently executed a sql command in phpmyadmin.

    Instead of:
    UPDATE wp_posts SET guid = REPLACE(guid, ‘domainA’, ‘domainB’);

    I executed:

    UPDATE wp_posts SET guid = REPLACE(post_content, ‘domainA’, ‘domainB’);

    Now, I can’t edit or save posts/pages.
    How can I get this work out? I don’t have a backup.

    Hope you can help me,
    Best Max

Viewing 1 replies (of 1 total)
  • Moderator t-p

    (@t-p)

    4 years, 7 months ago

    Do youhave a backup of your DB taken before you executing the command?

    If so, try restoring it.

    If you don’t, then ask your hosting provider if they have one, if they do, ask them to restore it.

Viewing 1 replies (of 1 total)

The topic ‘Wrong sql execution’ is closed to new replies.