Support » Fixing WordPress » How to clear database to try re-install if you can’t phpmyadmin

  • Hi,

    Anybody known how to clear the database (originally created, but corrupt) to try re-install WordPress?

    In my Hosting Site doesn’t have phpmyadmin and i don’t known how to clear databases….

    Any TIP ?

    Thans!!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mark (podz)

    (@podz)

    Support Maven

    Don’t 🙂

    Change the ‘table_prefix’ in wp-config.php to something else.
    It’s ‘wp_’ by default, so try ‘blog2_’ ?

    If you do want to start with a clean slate, you can connect to the database server (however you originally did to create the database) then the command to wipe out the database completely is:

    drop database [database name]; (That’s a semi-colon at the end)

    (Be sure you have it right! It’s not reversible and will ask for no confirmation when you hit enter.)

    Then just create the database like you did originally:

    create database [database name];

    Great!!
    I only change in the wp-config.php the prefix from wp_ to b2 and rocks!!

    Thanks a lot!!

    digitalcowboy : Thanks a lot but i’ve got a really sucks firewall to connect way ssh or mysql client.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to clear database to try re-install if you can’t phpmyadmin’ is closed to new replies.