Delete database or drop tables

  • I am redesigning a website from scratch. The redesigned website is currently in a different location. Once it is finished I will transfer it to another host replacing the current website there.

    My question is: do I delete the database in phpmyadmin and create a new one and then import the redesigned website’s database – or do I drop all the tables in the current website’s database and then import the redesigned wensite’s database into the empty current database?

    I would prefer to just drop all the tables but would like to make sure that it would be safe to do so.

    Thank you.

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

  • I’d just use the same database unless there is a performance issue with it. Use a different prefix for the new ‘rendition’ and install in a sub-directory of the old site.

    This way you don’t lose any posts, pages, or user data. Some of that content was possibly ‘hard won’ and I’d not treat it lightly.

    When you are done and have the site setup to your satisfaction you can follow these directions to make that new WordPress run as the site… https://codex.www.ads-software.com/Giving_WordPress_Its_Own_Directory

    Later on you can move stuff around in the two subsets of that database as needed or do a second subdirectory install if you need to get at that info via WordPress. And of course you can delete all those extra tables via PHPmyAdmin at that time.

    Thread Starter mica123

    (@mica123)

    Thanks, I’ll keep the database but drop all the tables and then import the database from the redesigned one.

    Thanks again.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete database or drop tables’ is closed to new replies.