PDA

View Full Version : Optimizing DB


NickC
10-31-2002, 02:21 PM
Hey, I was wondering how do you optimize the databases in phpmyadmin?

thanks.
Nick

don5408
11-01-2002, 02:09 PM
"I was wondering how do you optimize the databases in phpmyadmin?"

Hi, Nick. I'm only learning my way around PHPMyAdmin myself so I can't swear that there aren't other/better methods of doing this however try the following to optimize individual databases:

- Open PHPMyAdmin and select the database you wish to optimize
- Click on the "Check All" link to select all of the tables in the database
- Pull down the "With Selected" drop down menu and choose "Optimize Table"

Hope that helps!
Don