Database Access
  • November 2011
    OK, so now I have an online database. I asked for access to the cpanel and run up the MySQL Manager. but I can't see anything that resembles an Interspire database. I just get on called 'information_schema' (or something like that), which looks like the mysql system tables. Am I right in presuming that my login doesn't have the access rights? or have I missed something? 
     
  • GrantGGrantG
     
    November 2011
    The 'information_schema' database stores database column name, type, etc basically the structure of the database. All users should have access to this as default.

    Since you're talking cPanel, I assume you're using phpMyAdmin to access the database. In the top-left corner of phpMyAdmin, if your drop-down list only includes information_schema and not the database referenced in your (Interspire store) admin, you either do not have access for that user, or the database is hosted elsewhere, doubtful, but still possible.

    If you have cPanel access, go to MySQL Databases (below Databases header). It is entirely possible your database and cPanel usernames are different and so, have different access levels. Check the the users/databases under Current Databases to see who has access to your ISC database, click the Username to edit the Privileges. ISC requires ALL. You may neeed to add your cPanel username to the ISC database, or simply log-in to phpMyAdmin using the appropriate username/password which you will find in your ISC config.php file.
     
    Awarded Goat Points by 1acompton
  • November 2011
    Thanks, Grant; it was access rights and I've got it sorted now.
     
  • November 2011
    And last night, I ran a 6000-line SQL script on the database to import all the custom data fields from Actinic :D
     
    Awarded Goat Points by 1Gabriel Crowe
  • November 2011
    acompton said:

    And last night, I ran a 6000-line SQL script on the database to import all the custom data fields from Actinic :D



    Forgive me father for I have sinned. Last night I ran a 6000 line SQL script to get data from a heathen source into a clear richeous destination.
     
    Awarded Goat Points by 1GrantG