MySQL queries for db maintenance

Add a new configuration for an IPL or SIDL website in phpMyAdmin:

Operations: First, copy the entire table #__ipl_brackets to a new table bracket_backup
Make changes to the brackets in bracket_backup, and assign a new config id <cid>
SQL: INSERT INTO #__ipl_brackets (config_id, division_id, bracket, games, legs, players, title)
  SELECT config_id, division_id, bracket, games, legs, players, title FROM bracket_backup WHERE config_id=<cid> ORDER BY id
Add a new row to table #__ipl_config