DATA-SEED for MySQL Installation Guide

* ALWAYS PROTECT YOUR SEED WITH A PASSWORD!!!!

* ALWAYS USE HTTPS!!!!

Installation steps:

1. CREATE SEED FOLDER AND COPY FILES

Download seed-basic.zip, unzip it or copy sources from https://github.com/data-seed-tech/seed-basic/, and put the files into your public_html/seed folder (or another folder you decide to use).

How to identify your public_html folder [see here]

If you are not sure about public_html folder, create a php test page with the following content and place it in the root folder of your site (ironically it should be exactly the public_html):


        <?php

        header("Content-Type: text/plain;charset=UTF-8");

        print($_SERVER['DOCUMENT_ROOT']);

        ?>

Access this php page in order to check current web root folder. It will return something like /home/your_user_name/public_html, or something similar. You should consider the equivalent of public_html from this structure.

In the end your Seed folder should look like:


        /public_html/seed

            /api

            /database

            /images

            /appCode.inc

            /app_reports.inc

            /entityEdit.php

            ....

2. CREATE DATABASE TABLES

Open the database.sql file from https://github.com/data-seed-tech/seed-basic/tree/main/database and run the content in your mySQL instance in the database where you want to install DATA-SEED.

The database should look like:


    your_database

        your_tables

        ...

        seed_apps

        seed_menus

        seed_modules

        seed_nomenclatures

        ...

        other_tables_of_yours

DO NOT CHANGE seed_... TABLES! THIS WILL KILL THE SEED!

3. CONFIGURE ACCESS TO MySQL DATABASE

You need to define the connection to look like:


    $conn = new mysqli("host", "user", "password", "database");

Do it your way or follow these steps (recommended): [see here]

3.1. Identify your public_html folder. If you are not sure please check the "How to identify your public_html folder" section above.
It should be something like /home/your_user_name/public_html.

3.2. Create a folder 'config' outside of the public_html folder, so it cannot be accessed by public.

Inside the folder create a file for mySQL configuration (i.e. mysql_config.php).

Include here connection details:


        $conn = new mysqli("host", "user", "password", "database");

        $conn -> set_charset("utf8");

3.3. Call this page in your site php pages with: require_once '/home/your_user_name/config/mysql_config.php'

IMPORTANT! In order to let SEED work properly, you should use exactly the name $conn for connection, as shown above.

4. PROTECT YOUR FOLDER WITH PASSWORD

Of course, when it is possible you can do more to protect your Seed folder, like using a firewall, but at least we recommend to PROTECT YOUR FOLDER WITH PASSWORD.

5. THAT WAS IT! Go to your SEED address: https://your_domain/seed/

Next, find a 5 minutes tutorial here...

see our initialization example!

Home | Terms of use | Why DATA-SEED? | 🕮 The Story