Resetting SQL

  • Resolved pigmoose

    (@pigmoose)


    18 years, 1 month ago

    last week I put wordpress into a folder (my url/wordpress) off my www folder.

    Then after testing it running from there I was delighted with how it was performing, so I shifted it to my www folder but of course the database was still pionting to the old folder (my url/wordpress).

    So I tryed clearing the database and reinstalling wordpress this failing to create new tables. I tryed puting the original folder back which did create tables but that didn’t quite work.

    What should I do to start from stratch?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Delete any wordpress files and folders, drop the database tables, then start over.

    Assuming you used wp_ for your $table_prefix here’s the DROP commands to use in phpMyAdmin

    DROP TABLE     wp_categories;
    DROP TABLE     wp_comments;
    DROP TABLE     wp_linkcategories;
    DROP TABLE     wp_links;
    DROP TABLE     wp_options;
    DROP TABLE     wp_post2cat;
    DROP TABLE     wp_postmeta;
    DROP TABLE     wp_posts;
    DROP TABLE     wp_usermeta;
    DROP TABLE     wp_users;

    Thread Starter pigmoose

    (@pigmoose)

    Thanks for the help MichaelH. Before I got your post I went into phpMyAdmin and dropped all the tables by simply clicking the drop icon (perhaps I shouldn’t have done that) then I totally deleted all the files in my www folder and started again. Now I keep getting the ulError establishing a database connection/ul message. Have I destroyed my SQL?

    I believe I’ve seen somewhere that dropping the last table ended up also deleting the database.

    If the database still shows in phpMyAdmin then remember you may need to set the correct values in your wp-config.php file.

    If the database doesn’t showup in phpMyAdmin then recreate the database.

    Additional info:
    Installing_WordPress#Step_2:_Create_the_Database_and_a_User

    Thread Starter pigmoose

    (@pigmoose)

    I think it must be the first one as I have check the wp-confing.php file so many times it’s not funny. I have emailed the host to ask if they can return my database to a blank slate so I geuss I will wait and hope. cheers

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Resetting SQL’ is closed to new replies.