Enhanced SQL Portal Bridge

ESP is a database management systme that extends the capabilities of MySQL, giving anyone the ability to manage a database. Using the system's Table Manager, tables can easily be created, modified, including adding indexes and foreign keys. The system's Query Browser will allow you to create custom queries. You can create forms using various built-in field types such as drop-downs, number fields, text fields,date and date-time fields, google location and direction fields, and code fields (for editing code like HTML, javascript, etc.). You can change the layout of the forms using a built-in HTML editor. The Query Browser allows you to execute and command or query on your databases, and will save your queries for you as well as allow you to turn any query into a MySQL view, which can then be used in the Table Manager. That Admin Manager allows you to export single or multiple databases or single or multiple tables within a database using mysqldump. Beyond that, ESP has several other apps that can be added to your system to add functionality.

Go to the Admin Manager App in ESP. In the 'Database Setup' tab, there is a 'Dump Current Database' option. Clicking on this will pop up a page with dumping options. Choose any/all tables that you want to dump and hit submit. This will download a zip file with the mysql dump in it.

The Enhanced SQL Portal is well tested on linux servers with MySQL 5.x, and PHP 5.x (greater than 5.3). IT requires PHP PDO_MySQL or PHP MySQLi. While not well tested, it should work with Windows-type servers such as WAMP. To export your database or database tables, the server must have mysqldump installed and available from the command line.

On the ESP Bridge page there is a button labeled 'Login into Other Database'. Clicking that will take you to the ESP login page, where you can specify database and user.

There are two ways to create a new database. The first is to click the 'Login into WP Database button'. Once there, you can use the Admin Manager, click on the Database Setup section, and click on Create New Database. You can also click the 'Login into Other Database button.' When you are at the login page, you can type the name of your new database into the database box. If the database doesn't exist, upon login, it will ask you if you want to create the database.

Go the Table Manager app and click 'File', then 'New', and then 'Table.' This will pop up a form where you can choose the table name and enter other information, and the table will be created.

Find the table in the table manager in the tree on the left. Click on it. A tab that says "Format" will appear when the table is selected. You can manage the columns from that tab. Click on "Add" at the bottom to create a new column. By changing the validation, you can choose what kind of field that column will be represented by; there are various other options there for column definitions as well.

Find the table in the table manager in the tree on the left. Click on it. A tab that says "Foreign Keys" will appear when the table is selected. You can manage the foreign keys from that tab. Click on "Add" at the bottom to create a new foreign key.

Find the table in the table manager in the tree on the left. Click on it. A tab that says "Indexes" will appear when the table is selected. You can manage the indexes from that tab. Click on "Add" at the bottom to create a new index.