I am using WordPress based web development. I am a beginner, somewhere on YouTube I learned that, to change domain name, install plugin "Better search and replace", and using it replaced my domain name with the desired domain name. But after that, the domain stopped responding. I replaced the whole WordPress file from the ftp server, but in the installation process, it shows the message, "Already Installed, You appear to have already installed WordPress. To reinstall please clear your old database tables first". I have searched ways to do that, but everywhere it's saying to use plugins, which I can't do due to above mentioned issue.

  • 2
    Most web hosts provide access like phpMyAdmin. Check with your host and see what's available. You can either delete your database entirely or often restore a backup of your database from before you made the changes. It's always safer before doing major changes like domain replacement to back up the database manually, in case something like this happens. :)
    – WebElaine
    Oct 6 '17 at 15:14
  • Actually this domain is given by the instructor to me, for practice purpose. All I have is, Filezilla Confidentials and WordPress Database Confidentials and the domain name. Oct 6 '17 at 15:58
  • 1
    then go back with your Better seach and replace and reverse the changes?
    – rudtek
    Oct 6 '17 at 16:33

If the database server is available publicly you should be able to use a MySQL client to interact with it.

Sequel Pro is a good one for mac, check this list if you need something for windows or linux.

If the database is only available locally on your web server, you might be able to upload a DB admin script like adminer via filezilla and use that to interact with the database.

If all else fails you will likely have to go back to your instructor and ask him/her to reset the DB for you.


Another option that doesn't require installing anything: clear the database with PHP. Possibly a little easier. See this answer, just replace host, username, password, and database_name with your own from wp-config.php. Save the file, upload it to your root folder, and access it in a web browser to run it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.