phpMyAdmin Tip - Display More Default Rows

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mpetrovich
Forum Commoner
Posts: 55
Joined: Fri Oct 19, 2007 2:02 am
Location: Vancouver, WA, USA

phpMyAdmin Tip - Display More Default Rows

Post by mpetrovich »

For me, one of the annoying things with phpMyAdmin was the default to only display 30 rows at a time. In development, I always needed to display more rows. And to do that, you have to change the starting record and the number of rows.

Here is how to configure phpMyAdmin to display more rows:

In the phpMyAdmin directory, edit "config.inc.php"

To change from the default of 30 rows to 1000 rows, Add the following line:

Code: Select all

$cfg['MaxRows'] = 1000;
After a few weeks with this change, it has been wonderful. 1000 seems to be a pretty good number for local work.
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: phpMyAdmin Tip - Display More Default Rows

Post by Jade »

Lol, that would slow EVERYTHING down for me. No thanks, my servers have enough problems as it is without displaying even more rows. Nice tip though.
User avatar
mosymuis
Forum Newbie
Posts: 1
Joined: Sat Oct 14, 2006 2:22 pm
Location: Netherlands
Contact:

Re: phpMyAdmin Tip - Display More Default Rows

Post by mosymuis »

Just what I was looking for! :idea:
Post Reply