News:

Click here for Toll-Free Service for your business starting at $2.00 per month

Main Menu

Mysterious Database in my MySQL!??!?!??

Started by sixthcrusifix, January 03, 2006, 08:22:52 AM

Previous topic - Next topic

sixthcrusifix

I have 2 dtabases, "MAIN" and "DATA". MAIN stores stuff for my Forum, DATA stores stuff for my own site... but I went to download a backup of my SQL stuff and... there's a mysterious database in there that I did NOT put there!!!

It's called "data" And it shows a (-) next to it (has no tables) But in fact it has 8 or so tables in it. Some weird Forum info I think, the tables are as follows:

EDIT: Now it does show a (10) (10 tables) and these are tth tables:

    wp_categories
    wp_comments
    wp_linkcategories
    wp_links
    wp_options
    wp_post2cat   
    wp_postmeta
    wp_posts
    wp_usermeta             -
    wp_users 

I dunno what these tables are for, I don't have ANYTHING else installed onto my sites besides WaltLabs Burning Board Lite, I made everything else and I don't know what wp is. This must be an error so I'm not goig to drop the table yet in case it's somone elses table.
Visite me website at http://www.sixthcrusifix.com

x


webzone (archived)

Quoteshows a (-) next to it (has no tables)

In phpMyAdmin, a minus doesn't mean that there are no tables, it means that the database is expanded in the left pane.

Quotewp_categories
   wp_comments
   wp_linkcategories
   wp_links

That is a database for a WordPress install, indeed (as x said).

Assuming you're not using Plesk, could you click here and check if the mysterious database is listed there? If you have not created it (and it is not listed in your control panel), it might be possible, though unlikely, that someone created a database with the same db user and db pass as you, which would explain why it shows up.

In any way, it is preferable to make your db user and db name unique by adding your username at the beginning (like sixthcrusifix instead of MAIN and sixthcrusifix_data instead of DATA). It isn't mandatory, but it is a better way to organize things as we all share the same MySQL server.

sixthcrusifix

oh okay. I found peoples posts in it too and it wasn't from any of my site either but now when I try to browse the "data" Database it gives me an errors "No DataBase selected".

I might change my Database names so that problems like this won't happen but I'll have to go through ALL of my pages in Dreamweaver and replace the names. It won't be had to do but it will take FOREVER to re-upload them. :(
Visite me website at http://www.sixthcrusifix.com

webzone (archived)

Could you try to run this SQL query?

SELECT option_value FROM (name-of-the-mysterious-db).wp_options WHERE option_name = 'siteurl' LIMIT 1

It should give you the address of the blog that uses the database.

sixthcrusifix

#5
by the way, I can't change the names of my Databases, is there a way to change your DB names??

Webzone: I tried that SQL you gave me and I got an error:

Error

SQL query: Edit

SHOW TABLE STATUS LIKE 'data';

MySQL said: Documentation
#1046 - No database selected

I DID put in the right name
Visite me website at http://www.sixthcrusifix.com

webzone (archived)

QuoteI can't change the names of my Databases, is there a way to change your DB names??

I don't think it is possible from the control panel. Maybe the admin can do it, but I have my own MySQL server at home and I've never been able to. Either I missed something and he will be able to do it, or it might not be possible.

That's why my post was only a suggestion.

webzone (archived)

QuoteWebzone: I tried that SQL you gave me and I got an error:

Wierd... It doesn't even show the same query.

sixthcrusifix

Quote from: webzone on January 03, 2006, 07:29:27 PM
QuoteWebzone: I tried that SQL you gave me and I got an error:

Wierd... It doesn't even show the same query.

YEah I don't know what it's about. But I GUESS I could just export my database, Drop it, and then change the name in the SPQ to put it back and run it... I might try that before I go and drop it.
Visite me website at http://www.sixthcrusifix.com

sixthcrusifix

okay I made 2 new databases called "sixthcrusifix_MAIN" and "sixthcrusifix_DATA"

um.. in the dropdown on PHPMyADMIN it don't say "sixthcrusifix_DATA" it has "sixthcrusifix" in BOLD and below it says "_DATA" and "_MAIN"...

So what's teh real names of teh databases?
Visite me website at http://www.sixthcrusifix.com

webzone (archived)

Quoteum.. in the dropdown on PHPMyADMIN it don't say "sixthcrusifix_DATA" it has "sixthcrusifix" in BOLD and below it says "_DATA" and "_MAIN"...

probably a new grouping feature of phpMyAdmin. the real name is always the one you enter on the "create a database" form.

sixthcrusifix

#11
oh yeah I figured it out.  It works with the sixthcrusifix_DATA database but my MAIN database is for my forum so I'm not sure how to change i in my forum settings yet. Thanks fo rteh good adviice. :D

After I got rid of my "DATA" Database the "data" Database doesn't show anymore. Must have been a name conflict or something. BUt I'm sure "data" is a fairly common name, I reccomend that user to change theirs too. Before I got mysteriously locked out of being able to brows teh "data" database's tables (All teh sudden I could see them but not browse them/edit them) I edited a users post asking the Admin to Email me so maybe I'll find out who it is.



Visite me website at http://www.sixthcrusifix.com