Free CMSB Plugin - MySQL Console (Beta)

By Dave - November 17, 2009

Hello All,

We've just released a free plugin called "MySQL Console". Basically what this does is gives you a console within CMSB where you can directly execute MySQL commands so you don't need to swap out to phpMyAdmin or some other program (which isn't always installed or is more hassle etc).

From within the console you can run queries to examine what's in the database, check settings, test queries and where statements, or even do search and replaces (using mysql code).

This is very powerful and intended for more advanced users. As long as you don't run any queries that start with DELETE, INSERT, or UPDATE you'll generally be ok, though.

This plugin is already a huge timesaver for us and will also allow us to provide simpler support for advanced users as we can just send you a query to run instead of having to write a PHP wrapper around it to make it run.

You can download the plugin here:
http://www.interactivetools.com/appstore/detail.php?MySQL-Console-Beta-1011

Please post any comments, feedback, successes, etc along with any suggestions of what you might like to see in the preset query dropdown.

Note: This plugin requires the latest CMSB Beta (v1.37).

Thanks!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Free CMSB Plugin - MySQL Console (Beta)

By Dave - November 17, 2009

Here's a neat query you can run to change your default record numbers so they start at 1000 instead of 1 (or whatever they currently are:

ALTER TABLE cms_tablename AUTO_INCREMENT = 1000

Sometimes this is desirable for aesthetic reasons so all the numbers are of the same length. Othertimes services such as google news require minimum of 3 digit numbers so it's useful there as well.

http://www.google.com/support/news_pub/bin/answer.py?hl=en&answer=68323
Dave Edis - Senior Developer
interactivetools.com