... showing all entries tagged phpmyadmin
Here you will find all posts tagged phpmyadmin ↓
h4x3d.com does not host any illegal content. Links/Files referred to are for educational purposes only.
Optimize your SQL-Database
Dated: January 18th, 2008
Tags: 2008, optimize, phpmyadmin, sql, Wordpress
It does what it says – it optimizes your sql-database (really hard!).
From time to time it makes sense to log into phpMyAdmin, click the desired database, select all tables and select “optimize” from the drop-down.
My Wordpress Database went down 4MB (from 20MB to 16MB), here are some figures after the optimization:
16 tables total
47.081 entries
MyISAM type
language: [...]
Duplicate entry ?0′ for key 1
Dated: April 23rd, 2006
Wordpress, code | No Comments »
1. Go into your phpMyAdmin panel.
2. For each tables structure, edit the first entry (which should be a primary key such as ID).
3. Delete the 0 in the default value and select “auto_increment” in the drop-down menu next to it (on the right).
4. Save.
5. Go to the next table and do the same.
