By kobestarr on

Hey guys,

Its been over a year and i'm trying to spring clean my site so i made my way over to phpmy admin to find i had three databases (I only have one site). I vagulely remember doing this a year ago when i first started but i cant remember/determine which one is actually being used.

How do I find out which one is being used by my site so that i can delete the other ones?

Cheers

K

⋅ Categories: Drupal 6.x

Comments

amrit_b’s picture

amrit_b commented

hey just save a node with the content in body like "my name is .......... "

Then go to phpmyadmin and search for the content in all the three databases. It will be present in only one and that is the actual one you are using.

Its a very bad solution, but it will work ;)

Thanks

kobestarr’s picture

kobestarr commented

Ohh!

How do i actually search for content in the databases?

Sorry my knowledge is that low?

Thanks for your help!
K*

amrit_b’s picture

amrit_b commented

select any database from phpmyadmin.. then you will see a search tab on top.. with structure, sql, search, etc.

Thanks

kobestarr’s picture

kobestarr commented

Thanks! That worked

that was almost too simple!

Do you know of a php my admin 101/tutorial that deals with the basics like that so i dont have to bother people like yourself on this forum?

K*

amrit_b’s picture

amrit_b commented

Ha ha!!

Use google :)

There is nothing to learn in phpmyadmin. Whatever we do in mysql command line, its just the graphical UI.. I have not learned about it from anywhere. Just use it as much as u can..

thanks

Drupalace-1’s picture

Drupalace-1 commented

Simple way to see what database your site is using, without touching phpMyAdmin (or other database tools):

Peek inside your site's settings.php folder. The database host, database name, and password are all spelled out.