Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › IT Pro and developers › phpmyadmin, shared hosting and getting relations working.
richms

29098 posts

Uber Geek
+1 received by user: 10208

Trusted
Lifetime subscriber

#61962 26-May-2010 18:39
Send private message

I really need relations to work so I am not constantly looking at other tables to find what number to put into tables.

Reading the sparse documentation it seems I need to make another database, which I am not able to do being that it is a shared host.

Anyone know if there is a way to get it to work some other way. The documentation on it is dreadful to be honest.

Its 3.0.1.1 on the server. I am guessing I could upload another copy of it and edit things to make it go into the database I have rather than the default one, but I would rather not do that if possible.




Richard rich.ms

Create new topic
goodie
39 posts

Geek


  #335193 26-May-2010 19:01
Send private message

You'll need to be able to edit the config file, quite probably by uploading your own version of phpmyadmin.

While PMA recomends by default that you should make a new database, you can place those tables in a exsisting database, things can just get messy.

In the config file you'll want to look for the following lines:
/* User for advanced features */
 $cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
 $cfg['Servers'][$i]['controlpass'] = 'X';
/* Advanced phpMyAdmin features */
$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';
$cfg['Servers'][$i]['designer_coords']    = 'pma_designer_coords';

Or something similar (lines 47-59 in my config file), I recomend leaving these table names as is, but you will probably need to uncomment them or some such, I can't remember, change pmadb (database) to your current database.

You'll then want to go to the scripts folder and look for the files create_tables.sql or create_tables_mysql_4_1_2+.sql, you'll need to pick the right version for your SQL version (your exsisting PMA install should tell you on its home screen, left side), and then edit it.

Lines 21-23
CREATE DATABASE IF NOT EXISTS `phpmyadmin`
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

Remove them, and run the SQL commands on your database, this should result in several new tables matching up with your PMA config file.

And from memory that should leave PMA with its new features enabled

Failing all else post here again. :)




~



richms

29098 posts

Uber Geek
+1 received by user: 10208

Trusted
Lifetime subscriber

  #335302 26-May-2010 22:45
Send private message

Got it working with my own install of 3.3.3 which is newer than whats installed.

Still not ideal but a hell of a lot better than remembering what number is what shipping method etc ;)

Trying to remember my introduction to databases stuff from close to 12 years ago makes this slow going. Is there an easy php based package to chuck together a web front end for a database?




Richard rich.ms

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.








RSS feeds
Main feed
Forums feed
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright