Honesty Rocks! truth rules.

Information_schema

HOME      >>       Programming

khalilov

In PHPmyadmin where i see my databases i see information_schema. Is that considered a database? because in my website i use only 1 database, so if its not considered a database i don't have to choose 5 databases and have to pay an extra 0.99$ per month. If its a database, can i just delete it?


pyost

I don't think it counts as a database your account uses, because it is something concerning MySQL itself.


Running With Scissors1405241561

I don't think they count it because I have that also but when I look at the main page of cpanel it says I am only using one datebase (which is the one that my smf forum is on). I was wondering the same thing as you for a while but I think when they say one datebase it doesn't count the ones that are there already I think it means that you get to create one other than that.If I am wrong please correct me so khalilov doesn't screw up his hosting because I was wrong.


darasen

The Information schema is indeed a database. However, it is not one that counts as such as for as hosting is concerned. It is a system database used by MySQL Server. Everything you will need to know about it is in chapter 19 of the MySQL documentation.


TavoxPeru

In PHPmyadmin where i see my databases i see information_schema. Is that considered a database? because in my website i use only 1 database, so if its not considered a database i don't have to choose 5 databases and have to pay an extra 0.99$ per month. If its a database, can i just delete it?

Yes, the information_schema is considered a database because it is the MySql Server core database which stores every thing about all of your databases and you can't delete or even modify it or it's content.
Now regarding if it counts in your databases list, well I think that this database does not count because of what i say before.

Best regards,

khalilov

Hm.. well i can't be too careful i submited a ticket asking about it so when i get an anwser i'll let you guys know =)


Running With Scissors1405241561

Hm.. well i can't be too careful i submited a ticket asking about it so when i get an anwser i'll let you guys know =)

Ok thanks and you're right you can't be too careful. I'm glad you told out a ticket that way we can all be sure.

khalilov

Bah i sent two tickets and got

Thank you for contacting Xisto - Web Hosting.com. I apologize for the delay in responding to your inquiry. I apologize for any inconvenience that this may have caused you.

Please update us with the following details :-

Domain name :-
Control panel username :-
Control panel password :-

I checked your billing account and found that account exists but with no products/services. If you are hosted with us, then please update us with the details. So that we can add that product in your account. Please verify the same by logging to your client area.

Thank you for your time and understanding.

Sincerely,

and

Thank you for contacting Xisto - Web Hosting.com.

Please elaborate more on this question " is that considered a data base? " and also update with the following details :-

1. Domain name :-
2. Control panel username :-
3. Control panel password :-
4. Payment details :-

Thank you for your time and patience.

Sincerely,


i guess i have to be hosted their to get an anwser, can someone who transfered ask if information_schema in PHPmyadmin is a database?

yordan

It is a database, but it is not counted as a hosted database (you don't give money nor MyCents for it).You have a simple way of looking at this. As soon as you will be hosted, have a look at the number of databases you own in the left-side bar of your Xisto cpanel, you will see that you have no database (number 0/5, or something like that).However, you will probably be able to connect to phpMyadmin and you will see this information_schema database.And as you will have created your first database, you will still see it besides your newly created database.


khalilov

Ah, then no need for paying an extra 0.99cents per month thx =)