Portal Home > Knowledgebase > Articles Database > Debian & Phpmyadmin


Debian & Phpmyadmin




Posted by bonjurkes, 03-22-2012, 04:30 PM
Hello guys, I wanted to give a try to Debian, so far everything looks good. But I have a small question in mind. I am using apt-get update and upgrade to update software on the system like nginx, php etc. Right now I am using phpmyadmin 3.3 version, which I installed via apt-get also. But right now phpmyadmin 3.4 is available all around, but apt-get says everything is up to date. So am I missing something? Do I have to add any extra repo to my aptget list or should I just wait till repos update it? I am on Debian 6 vps server

Posted by MikeZavatta, 03-22-2012, 04:40 PM
bonjurkes, It looks like debian.org already has this available and has a list of mirrors you can download from: http://packages.debian.org/sid/all/phpmyadmin/download

Posted by bonjurkes, 03-22-2012, 05:08 PM
Thanks mike for the answer, but I came up along with another issue. I added to my sources list. Now it looks like I think I didn't add any new source to the list before. Now it says I have 102 upgraded, 0 newly installed, 0 to remove and 140 not upgraded packages. I am not quite sure it was a good idea to update that much stuff. I am using default debian 6 minimal as Hetzner installed. So do I really need that much stuff? Before I added that source to list, it was saying everything was up to date. For example nginx latest stable is 1.0.14 and I have same on server but now aptitude says there is update for it.

Posted by MikeZavatta, 03-22-2012, 05:26 PM
bonjurkes, It looks like you need to replace ftp.de.debian.org/debian with the mirror in question from the list below and not with "ftp.de.debian.org/debian" itself. For example, for a North American mirror you could use "ftp.us.debian.org/debian" or "ftp.mx.debian.org/debian". Once a mirror is added, you can get the phpMyAdmin download from the selected mirror at the subdirectory pool/main/p/phpmyadmin/. I suggest trying a mirror close to your server location and then checking that subdirectory. The repository you had originally set from your provider most likely provides the stablest releases they have vetted to work on the provided hardware. An added mirror would show all available packages, even ones that many not work well with your server configuration.

Posted by bonjurkes, 03-22-2012, 05:35 PM
hey Mike, I just use wget to get phpmyadmin package, dpkg -i to install it and now it's upgraded. Thanks a lot

Posted by MikeZavatta, 03-22-2012, 05:39 PM
bonjurkes, I am so happy you got that upgraded, glad I was able to help!

Posted by bonjurkes, 03-22-2012, 05:42 PM
One last question, Now that phpmyadmin is updated, it doesnt show table numbers of each database next to it like testdb(5) anotherdb(10) now it only show the names, is there a setting to bring back those table numbers? As it's important in case of db restore

Posted by MikeZavatta, 03-22-2012, 05:59 PM
A review of the change log for 3.4 looks like the interface changed to not count tables in the database by default. A review of http://wiki.phpmyadmin.net/pma/Config looks like you should be able to set this to true in your phpMyAdmin configuration file. You would need to change the option in config.inc.php to look like such: $cfg['Servers'][$i]['CountTables'] = true;

Posted by bonjurkes, 03-22-2012, 06:04 PM
thanks Mike, it worked like a charm

Posted by MikeZavatta, 03-22-2012, 06:05 PM
bonjurkes, Perfect! That is what I like to hear.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read