Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Question about Database: what is "information_schema" ?

    When I look at my database isomg phpMyAdmin, I see two of them listed, "information_schema (17)" and "mystore (97)"

    I'm not sure what the "information_schema" is. I did have someone help me recover from a corrupted database six months ago or so... is this some sort of remnant from a database recovery operation or something?

  2. #2
    Join Date
    Jan 2004
    Posts
    65,399
    Blog Entries
    7
    Plugin Contributions
    232

    Default Re: Question about Database: what is "information_schema" ?

    information_schema is a system database, created and managed by MySQL automatically.

    Leave it alone. You don't need to be concerned about it.
    Last edited by DrByte; 10 Feb 2008 at 04:46 AM. Reason: content clarified
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Re: Question about Database: what is "information_schema" ?

    So it is created by Zen Cart during the installation?

    If I ever had to restore my store database from a backup then I would actually need to restore both databases?

  4. #4
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Re: Question about Database: what is "information_schema" ?

    I have found more information on the information_schema here...
    http://dev.mysql.com/doc/refman/5.0/...on-schema.html

    But what I'm still not clear about is when does this database get created and is it of critical importance when trying to restore the store database from a backup?

    For several years I have been diligently backing up my store database (mystore) and didn't even realize that this information_schema was there.

    In the event I have some sort of catastrophic loss of my entire database, am I able to restore only the mystore databaseand have a functioning store if I am lacking the information_schema? In other words, does the information_schema get created -from- the mystore database?

    I find this all quite confusing.

  5. #5
    Join Date
    Jul 2006
    Location
    SF Bay Area
    Posts
    879
    Plugin Contributions
    1

    Default Re: Question about Database: what is "information_schema" ?

    It's not installed by, or a part of Zen Cart.

  6. #6
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Re: Question about Database: what is "information_schema" ?

    So I guess you are saying that it has nothing to do with restoring a cart database then? I need not worry about it al all since it has nothing to do with Zen-Cart, per se?

    Michael

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,471
    Plugin Contributions
    6

    Default Re: Question about Database: what is "information_schema" ?

    IF you need to know more about the information_schema, which has nothing to do with Zen Cart, you should contact your hosting site and they can explain it better for you ...

    Again, as DrByte has suggested, it is not something you should have to ever touch ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Re: Question about Database: what is "information_schema" ?

    Gosh, I've asked my question several different ways and I've gotten several responses but all of them dance around the topic instead of directly answering my question. Sorry for the inconvenience. I -will- ask my web host and then I will post the reply so that perhaps when someone else asks the same question... and someone surely will... there will be a better answer for them to read.

  9. #9
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,606
    Plugin Contributions
    1

    Default Re: Question about Database: what is "information_schema" ?

    Not sure why you are still confused?

    It was already mentioned that "It's not installed by, or a part of Zen Cart."

    You, yourself, provided a link that explains it nicely.

    INFORMATION_SCHEMA provides access to database metadata.

    Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.

    INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.

    In effect, we have a database named INFORMATION_SCHEMA, although the server does not create a database directory with that name. It is possible to select INFORMATION_SCHEMA as the default database with a USE statement, but it is possible only to read the contents of tables. You cannot insert into them, update them, or delete from them.


    Now we know that INFORMATION_SCHEMA is information about the various databases on the Server. It is not created by anyone through their Hosting account nor by any script used within a Hosting account.


    In other words, don't worry about it. Worry instead about maintaining and backing up "your" databases, created by yourself or by a script you are using.
    The learning is in the doing.

    Potent Products

  10. #10
    Join Date
    Mar 2004
    Posts
    136
    Plugin Contributions
    0

    Default Re: Question about Database: what is "information_schema" ?

    Understanding technical writing is not my forté. Your explanation did clear it up though, so thank you.

    We're not all braniacs here :-)

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Display "Best Sellers" like "What's New" or "Specials" lists.
    By jsmooth in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 22 Jun 2010, 12:06 AM
  2. "No products have been defined" message means? and what do I do about it?
    By genlancaster in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 13 May 2009, 11:56 PM
  3. Status: Processing -> Delivered? What about "Shipped"?
    By prock in forum General Questions
    Replies: 2
    Last Post: 17 Oct 2008, 07:36 PM
  4. For images, does "base" = "small"? And a question about alternates.
    By molywerks in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 29 Feb 2008, 02:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR