Nov 25, 2009

Information_schema

free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Programming > Scripting > PHP

Information_schema

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?

Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)

Running With Scissors
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.

Comment/Reply (w/o sign-up)

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.

Comment/Reply (w/o sign-up)

TavoxPeru
QUOTE(khalilov @ Oct 28 2008, 11:51 AM) *
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,

Comment/Reply (w/o sign-up)

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 =)

Comment/Reply (w/o sign-up)

Running With Scissors
QUOTE(khalilov @ Oct 29 2008, 10:48 AM) *
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.

Comment/Reply (w/o sign-up)

khalilov
Bah i sent two tickets and got
QUOTE


Thank you for contacting ComputingHost.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
QUOTE


Thank you for contacting ComputingHost.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?

 

 

 


Comment/Reply (w/o sign-up)

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 astahost 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.

Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : Information Schema

  1. Requesting Information (php/mysq/jscript Etc). - (4)



Looking for information, schema

See Also,

*SIMILAR VIDEOS*
Searching Video's for information, schema
advertisement



Information_schema

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com