Installation

How do you install this. I'm only able to unzip it.

You need to do a little digging... I struggled at first, as well. For starters, you need to make sure the entire zip file is unpacked in your server's document root. Access the folder/index.html file to see if it displays the grid and if you are able to create tables. Next, create a database and add the table located at "sqldesigner/backend/php-mysql/database.sql" After creating the database and table make adjustments to the first function in the index.php file located in the same directory.

I haven't played with the Import from DB option yet but I suspect you would need to make changes to the second function and possibly the fourth (by changing "information_schema" to the database you want to import) but you are on your own with that one.

By the way, ondrej.zara, excellent tool! Thanks for the time you've spent on this! Looking forward to seeing where you go with it!

If you want to use import feature, here is how I did it :

To make the save and load feature working follow this steps : 1. Open backend/php-mysql/index.php 2. In setup_saveloadlist function change SERVER, USER, PASSWORD and DB to fit your configuration 3. Import in DB the file backend/php-mysql/database.sql

To make the import from db feature working follow this step : 1. Open backend/php-mysql/index.php 2. In setup_import function change SERVER, USER, PASSWORD

Before any of this step, I suggest that you create through phpmyadmin or mysql client the sqldesigner mysql account.

The process for other server import should be similar.