MySQL Setup

Default Options

• Detailed Configuration
• Developer Machine
• Multifunctional Database
• Installation Path
• Decision Support
• Enable TCP/IP Networking / Enable Strict Mode
• Standard Character Set
• Install as Windows Service
• (Password)

Some useful MySQL commands

MaxWiki - Find pages with lots of revisions then delete extra revisions:

• SELECT DISTINCT page_id, count(page_id) AS sum FROM revisions GROUP BY page_id HAVING sum > 100 ORDER BY sum;
• DELETE FROM revisions WHERE page_id = 1369 AND updated_at < (CURDATE() - INTERVAL 1 YEAR);

Edit Page Add Page