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.
google tells me it's wordpress (http://codex.wordpress.org/Database_Description)
thats as bout as much as i can help
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 (http://system.freepgs.com/options.php?sec=viewdbs) 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.
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. :(
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.
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
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.
QuoteWebzone: I tried that SQL you gave me and I got an error:
Wierd... It doesn't even show the same query.
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.
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?
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.
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.