How do I know which data base a blog is using?

5 replies
I want to move a blog to another domain and I have downloaded the files, now I need to download the data base. But I can't figure out how to determine which data base this blog uses. Can someone tell me the best way to determine the name of the data base a blog is assigned to?
#base #blog #data
  • Profile picture of the author imkevintan
    Are you using WordPress? If you install some database related plugins in your original blog, say WP-DB-Backup, DB-Manager, or WP-Optimize, you'll be able to see your database name when you perform a backup or optimize your database.

    For me, the fastest way is to use WP-Optimize and optimize your database from its option page to see your database name.

    Hope this helps.
    {{ DiscussionBoard.errors[5182766].message }}
    • Profile picture of the author williamrose
      Have a look in your wp-config.php file. The database information will be defined there.
      {{ DiscussionBoard.errors[5183188].message }}
      • Profile picture of the author Mike Baker
        Originally Posted by williamrose View Post

        Have a look in your wp-config.php file. The database information will be defined there.
        This is one way, or you could use the WB-DB-Backup plugin which will backup the database the blog is running from.
        Signature

        {{ DiscussionBoard.errors[5190848].message }}
    • Profile picture of the author timpears
      Originally Posted by imkevintan View Post

      For me, the fastest way is to use WP-Optimize and optimize your database from its option page to see your database name.

      Hope this helps.
      That is an awesome plugin. I could have used that many times in the past. Thank you so much for pointing me to it. If I could hit the thanks button more than once I would do it.

      So much crap gets left in the data base when you make revisions, this probably cut it down by half. And sure enough, the data base is listed at the bottom of the page. I would have never found it with all the data bases I have, and this one is a low number. I was starting at the high number because this was one of the last blogs I set up, as I remember it.

      Thanks again.
      Signature

      Tim Pears

      {{ DiscussionBoard.errors[5187422].message }}
      • Profile picture of the author imkevintan
        Originally Posted by timpears View Post

        That is an awesome plugin. I could have used that many times in the past. Thank you so much for pointing me to it. If I could hit the thanks button more than once I would do it.

        So much crap gets left in the data base when you make revisions, this probably cut it down by half. And sure enough, the data base is listed at the bottom of the page. I would have never found it with all the data bases I have, and this one is a low number. I was starting at the high number because this was one of the last blogs I set up, as I remember it.

        Thanks again.
        Glad it helped. Yeah it stores those revisions in our database as we edit posts. And the more resources we have in our database, the slower our site loads...

        I always check and optimize my WordPress database at least once a month.
        {{ DiscussionBoard.errors[5190383].message }}

Trending Topics