|
|
Posted by Cerebral Believer on 09/15/06 19:35
"George" <george@msn.com> wrote in message
news:eeet7r0231m@drn.newsguy.com...
> On Fri, 15 Sep 2006 03:56:22 GMT, Cerebral Believer wrote...
>>
>>For some reason, the way my hosting provider has set up phpmyadmin &
>>mysql,
>>does not allow me to create relational databases. I have having real
>>trouble getting this point through to the support staff.
>>
>>I get the following response when I click on the name of my database (left
>>panel) and then on the "operations" sub-tab on the right panel - "Error =
>>The additional features for working with linked tables have been
>>deactiviated. To find out why click here". When I click I am presented
>>with the readout below, how would I go about correcting these perameters
>>to
>>enable relational features etc, and what variables should I consider?
>>
>>$cfg['Servers'][$i]['pmadb'] ... OK
>>
>>$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
>>General relation features: Disabled
>>
>>$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
>>Display Features: Disabled
>>
>>$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
>>$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
>>Creation of PDFs: Disabled
>>
>>$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
>>Displaying Column Comments: Disabled
>>Bookmarked SQL query: Disabled
>>
>>MIME ... not OK [ Documentation ]
>>$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
>>SQL history: Disabled
>>
>>Regards,
>>CB.
>>
>>
>
> If you're site is hosted somewhere maybe their service is limiting access
> to a
> specific database. They may be restricting what their customers can create
> to
> control how many databases and how large the databases are. you might want
> to
> check with them to see if there is already a MySQL database assigned to
> you, and
> can use that to create and populate your tables.
Hi George,
Well, I know I can create a number of databases, there has been no upper
limit specified by the hosting provider, so I am not sure if space is an
issue, resources & server load, security, perhaps?
Do you know anything about these configuration settings? I have asked the
hosting provider to update my "config.inc.php" & "scripts/create_tables.sql"
files. An ebook I purchased suggests these settings in these files need to
be modified to take advantage of the relational features of phpmyadmin and
should be:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
If I knew a way to change the settings I would change them myself, but it
seems like I need access to the installation directories for phpmyadmin,
and/or MySQL.
Regards,
C.B.
Navigation:
[Reply to this message]
|