• Resolved femacourses

    (@femacourses)


    Hello, in my title while trying to fix an error in wordpress I accidently deleted the entire table. I can’t currently find a back up, so I downloaded a new wordpress table from a new installation and ported it over. Now it says “sorry you can’t access this page and I really need help”

Viewing 15 replies - 1 through 15 (of 56 total)
  • Did you replace the entire database, or just that one table with the new port?

    Thread Starter femacourses

    (@femacourses)

    I just replaced that one table.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Yeah, you really hosed yourself. All the site’s settings are gone.

    Edit wp-config.php so the site knows what its URLs are: https://codex.wordpress.org/Editing_wp-config.php#WP_SITEURL

    That should let you get into WP. You’ll have to go through all the settings stuff carefully to create new settings in the database.

    Going forward, install the plugin “backwpup” and set it to do automatic site backups at some regular interval.

    Thread Starter femacourses

    (@femacourses)

    Thank you for the prompt help! What code am I inserting into the file again?

    define( ‘WP_SITEURL’, ‘http://example.com/wordpress’ );

    This one?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    yes

    Thread Starter femacourses

    (@femacourses)

    It’s showing an x when I try to insert my the code with my website. Do I have to use the base http or https if I have an ssl certificate installed

    Such as

    define( ‘WP_SITEURL’, ‘https://femacourses.com/’ );

    Thread Starter femacourses

    (@femacourses)

    http://prntscr.com/nq05ld Here’s a screenshot.

    Thread Starter femacourses

    (@femacourses)

    Is there a way to get in without editing the wp-config file? How do I add an admin to wp options?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    No. You really messed up. You need to work through everything on the “settings” menu.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    1. You’re using the wrong “prime” character. Do not copy/paste — type it in.

    2. You put that *after* where it says “stop editing here”. You might rethink that.

    autotutorial

    (@autotutorial)

    define( 'WP_SITEURL', 'https://femacourses.com' );
    define( 'WP_HOME', 'https://femacourses.com' );

    without end slash.
    you are not currently using the correct single quotes.
    Then you have to change the keys as those must remain secret (one step at a time before setting the site and home url).
    After your key.

    Thread Starter femacourses

    (@femacourses)

    http://prntscr.com/nq0w9v

    Ok I’ve entered it correctly as it’s not showing ao syntax error, could you double check in the screenshot above?

    Thread Starter femacourses

    (@femacourses)

    Do I have to include wordpress? My site is installed directly at femacourses.com

    autotutorial

    (@autotutorial)

    you don’t have to include other folder at your https://example.domain.com
    Your sintax is OK now.

    Thread Starter femacourses

    (@femacourses)

    Ok, now you mentioned keyas. are you talking about the ‘Auth key’ “SECURE_AUTH KEY’

    directly above? What do I need to change those to?

Viewing 15 replies - 1 through 15 (of 56 total)

The topic ‘Deleted wp_options table accidently.’ is closed to new replies.