phpMyAdmin - PMA Database

Jeg har selv fundet dette, men behøver hjælp til "oversættelsen" da jeg er helt nybegynder inden for faget

RE: Creating a Relationship in phpMyAdmin

The bad news is you are out of luck if you dont have the innoDB engine. innoDB is the only one that enforces foreign key constratints.

Check this link for innoDB
http://dev.mysql.com/doc/refman/4.1/en/innodb.html  />
For the other storage engines.
http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html  />
check with your hosting company they might have an older version of mysql running.

creating the relationships should not be a problem if you see the "relation view". its a simple matter of choosing the right table with the key and save.

What versions of mysql, php, apache are you running?

sorry. I forgot to mention in phpmyadmin you have to run a script before you can define relationships.

1. go to /phpmyadmin/config.inc.php and open the file in wordpad.

2. look for this line and start entering the DEFAULT table names in the single quotes. The default table names are given across each line in form of comments.
$cfg['Servers'][$i]['pmadb'] = '';

3. Last line in which you have to enter the DEFAULT value
$cfg['Servers'][$i]['history'] = ''; 

4. once this is done we need to execute the sql script. make sure the user name in script file matches the one on your sql server. The "pma" should be changed to reflect the sql user you have on the server.
GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost;

this is the sql file you need to run
/phpmyadmin/scripts/create_tables_mysql_4_1_2+.sql

5. once this script executes you will see a new DB in phpmyadmin db list.

6.done.

good luck

p.s. please check the documentation on the phpmyadmin site. dont give up. took me a while to figure it out too.

Ingen svar - har oprettet nyt spørgsmål