pma database

2 risposte [Ultimo contenuto]
Ritratto di ramsex
ramsex
(Geek)
Offline
Geek
Iscritto: 13/12/2004
Messaggi: 89

ciao a tutti.

ho un sito basato su xoops che gira su php 5.0.4 e mysql 4.1.12. quando accedo al database in remoto (il sito è sul server del mio provider) tramite phpmyadmin in basso appare l'errore

PMA Database ... non OK[ Documentazione ]
Caratteristiche Generali di Relazione Disabilitata

cosa comporta questo? come posso risolvere?

grazie a tutti in anticipo

Ritratto di franz
franz
(Collaboratore)
Offline
Collaboratore
Iscritto: 21/12/2005
Messaggi: 424

Quote:

...

PMA Database ... non OK[ Documentazione ]
Caratteristiche Generali di Relazione Disabilitata

...

Hai provato a leggere quello che dice il link [Documentazione]?!?!?!?!?!

There are only 10 types of people in the world: those who understand binary and those who don't.

Ritratto di ramsex
ramsex
(Geek)
Offline
Geek
Iscritto: 13/12/2004
Messaggi: 89

la documentazione rimanda a questo:

$cfg['Servers'][$i]['pmadb'] string
The name of the database containing the linked-tables infrastructure.

See the Linked-tables infrastructure section in this document to see the benefits of this infrastructure, and for a quick way of creating this database and the needed tables.

If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. For a multi-user installation, set this parameter to the name of your central database containing the linked-tables infrastructure.

$cfg['Servers'][$i]['bookmarktable'] string
Since release 2.2.0 phpMyAdmin allows to bookmark queries. This can be useful for queries you often run.

To allow the usage of this functionality:

* set up pmadb and the linked-tables infrastructure
* enter the table name in $cfg['Servers'][$i]['bookmarktable']

$cfg['Servers'][$i]['relation'] string
Since release 2.2.4 you can describe, in a special 'relation' table, which field is a key in another table (a foreign key). phpMyAdmin currently uses this to

* make clickable, when you browse the master table, the data values that point to the foreign table;
* display in an optional tool-tip the "display field" when browsing the master table, if you move the mouse to a column containing a foreign key (use also the 'table_info' table);
(see FAQ 6.7)
* in edit/insert mode, display a drop-down list of possible foreign keys (key value and "display field" are shown)
(see FAQ 6.21)
* display links on the table properties page, to check referential integrity (display missing foreign keys) for each described key;
* in query-by-example, create automatic joins (see FAQ 6.6)
* enable you to get a PDF schema of your database (also uses the table_coords table).

The keys can be numeric or character.

To allow the usage of this functionality:

* set up pmadb and the linked-tables infrastructure
* put the relation table name in $cfg['Servers'][$i]['relation']
* now as normal user open phpMyAdmin and for each one of your tables where you want to use this feature, click "Structure/Relation view/" and choose foreign fields.

Please note that in the current version, master_db must be the same as foreign_db. Those fields have been put in future development of the cross-db relations.

chiedo scusa ma sono un po' a digiuno di database...