Doing MySQL Changes outside of CMS Builder's UI

Hi Sid,

You can manually add tables to the mysql database, but those tables won't show up in CMS Builder. The reason for this is there won't be a schema file for the table you manually created. You can add fields to a pre-existing CMS Builder table, and those fields will show up as having no label and being of type "none". Doing this is generally not considered a good practice. If you want tables and fields to be usable inside CMS Builder, we strongly recommend that you use CMS Builder to create them.

As for using a 3rd Party App to modify/add/delete CMS Builder records, it is possible that this could harm your data. For example, if a 3rd Party script deleted all of the records in the accounts table, you wouldn't be able to log in. Basically, it circumvents all of our security and error-checking features. There is nothing that prevents you from using a 3rd Party script like this, but because we have no knowledge of what it is doing, we can't guarantee or support the results.

If you could let us know what situations you would need to do this in, we may be able to suggest some alternative methods that may be safer.

Hope this helps