Creating the Database Tables

At the moment it is necessary to create the ecosystem database tables manually. A future update may add the facility for a new installation of ecosystem to create the database tables that it required.

If you have reached this page, it is assumed that you have already created your database (using the Wizard or phpMyAdmin) and your database username/password and permissions are set.

Using phpMyAdmin

Creating the database tables are done from within the phpMyAdmin package. Find it on your CPanel homepage and click it.

For those that used the Wizard

If you used the MySQLWizard to create your database, the following image shows an example of the phpMyAdmin screen.

Entering the SQL Script

Notepad

To help set up the database, the ecosystem GitHub repository has a file named zylum_plain.sql in the root of the project. Download this file and open it in Windows Notepad or any other text editor your system supports.

In Notepad, click Edit -> Select All then Edit -> Copy to copy the entire SQL script to the clipboard.

phpMyAdmin SQL Tab

Now switch back to your web browser showing the phpMyAdmin homepage.

IMPORTANT: You must now click the name of the database that you created. It is listed in the left-hand column. In this example I have clicked admin_ecosystem.

After clicking your database name, click the SQL tab in the menu bar ...

... notice that the caption tells you the name of your database in which it will run the SQL query.

Click inside the script window and paste the copied SQL script into it ...

... now click Go.

If all goes well, you should see an empty result set message ...

Click on the Structure tab and (assuming all went well) you will see all the database tables that the SQL script created ...

All Done

You now have your ecosystem database set up, with all the necessary database tables and user permissions.

You can now Configure Ecosystem PHP