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

28209 posts

Uber Geek

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

28209 posts

Uber Geek

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





News and reviews »

Gen Threat Report Reveals Rise in Crypto, Sextortion and Tech Support Scams
Posted 7-Aug-2025 13:09

Logitech G and McLaren Racing Sign New, Expanded Multi-Year Partnership
Posted 7-Aug-2025 13:00

A Third of New Zealanders Fall for Online Scams Says Trend Micro
Posted 7-Aug-2025 12:43

OPPO Releases Its Most Stylish and Compact Smartwatch Yet, the Watch X2 Mini.
Posted 7-Aug-2025 12:37

Epson Launches New High-End EH-LS9000B Home Theatre Laser Projector
Posted 7-Aug-2025 12:34

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00

eero Pro 7 Review
Posted 23-Jul-2025 12:07

BeeStation Plus Review
Posted 21-Jul-2025 14:21

eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01

WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32

RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26

Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24

Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05

Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01

Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01








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-2025 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Affiliate links
Samsung
AliExpress
Wise
Sharesies
GoodSync
Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright