DevNetwork Forums

The Developer's Network
It is currently Mon Feb 08, 2010 10:08 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: phpMyAdmin Tip - Display More Default Rows
PostPosted: Thu Oct 30, 2008 2:40 pm 
Offline
Forum Commoner

Joined: Fri Oct 19, 2007 2:02 am
Posts: 50
Location: Vancouver, WA, USA
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:
  1. $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.


Top
 Profile  
 
 Post subject: Re: phpMyAdmin Tip - Display More Default Rows
PostPosted: Tue Nov 04, 2008 5:01 pm 
Offline
Forum Contributor
User avatar

Joined: Sun Dec 29, 2002 6:40 pm
Posts: 368
Location: Va
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.

_________________
game programming & web design
design1online.com
----
GameFrenzi.com Needs Programmers From Northern Virginia. Interested?


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group