Manual Installation of Database Files

Dimbal Software attempts to install the necessary MySQL tables on your behalf during the Setup routine.  Depending on the security settings of your MySQL server, it may be necessary to install these tables manually.  This is because some webhosts may have tight security settings that prevent website scripts from modifying your database schema.

This article will help walk you through manually installing your Database.

With your software package there should be a ZIP file that ends with a “_sql.zip”.  This is the required MySQL scripts that need to be run.  Unzip this file to a location on your computer.  NOTE: For security of your application, please do not upload this ZIP file or the included SQL files.

Once this package is unziped you should see a MySQL file within it.  There are many different ways to run the SQL commands contained within this script on your database.  While we cannot cover all of them, we will provide instructions for two common approaches.  

NOTE:  The exact steps may vary slightly on your individual websites setup.

Option 1 – Copy and Paste the SQL Statements.

One option is to copy and paste the SQL statements into a MySQL administration tool such as PHPMyAdmin.

  • Open the PhpMyAdmin tool (or other MySQL Administration tool) provided by your webhost.

  • Navigate to the Database you want to use.  You will need to select the database in order to use it.

    • If a Database does not exist then you may need to create one first.  if you need assistance creating a database, you may need to contact your webhost for proper support. 

  • Once you are in the Database you want to use there should be a SQL command box that you can enter SQL commands into.  The image below provides an example of this command box within a Database called “localhost”:

 

SQL Demo

 

  • Open the SQL file mentioned earlier that is contained in the archive.

  • Copy the entire block of code found within that SQL file.  The SQL block of code will look something similar to the following:

 

Example SQL

 

  • Paste the entire block of code into the PhpMyAdmin SQL command box

  • Press “enter” or “execute” (or whatever submit button is present) to run the SQL commands against your Database

  • A Status message should appear indicating that the SQL commands were either successful or failed.

 

Option 2 – Running the SQL File

An alternate method to setting up the Database tables manually is to have your MySQL Admin tool execute the SQL file directly.  This is very similar to the above process, we will explain it below.

 

  • Open the PhpMyAdmin tool (or other MySQL Administration tool) provided by your webhost.

  • Navigate to the Database you want to use.  You will need to select the database in order to use it.

    • If a Database does not exist then you may need to create it.  Instructions for this will vary depending on the MySQL Administration tool being used.

  • Once you are in the Database you want to use there should be an option to run an external SQL file.  This is often considered an “IMPORT”.  Select this option.  The image below shows an example of the Import options.

 SQL Import Method 

  • Using the File selector, navigate to the SQL file provided with the application and choose it.

  • Validate any other options that may be present, such as ensuring that the file is interpreted as a SQL file, if that option exists.

  • Hit “submit” or “enter” or whatever submit button is present.

  • A Status message should appear indicating that the SQL commands were either successful or failed.

 

Option 3 – Web Administrator Assistance

If the options above have all failed, then please do not hesitate to get in contact with us for support.  It may be necessary that we ask your web host for assistance if there are in fact permission issues or other restrictions in place.

If you want to contact your webhost for assistance you can provide them with the SQL file that came with the application.  If you start a support ticket with them you can use the following verbiage to help them understand the request.

To: < My Web Host >,

I would like to ask for assistance setting up a new PHP/MySQL application on my web server.  The url to the installed application is:  http:// << Enter-Your-Install-URL >>

Specifically, I would like to ask for assistance setting up the Database for this application.  Attached to this message I have provided the SQL file that contains the sql statements to create the database tables.  Please run it against my database.  

Also, can you please confirm for me what the Database Server Address, the Database Name, the MySQL Login Username and the associated Login Password is.  

Thank you.

Your web host should have no trouble running the associated SQL file.  If they do for whatever reason, please contact our support team.

Posted in Articles.
Click on a tab to select how you'd like to leave your comment

Leave a Reply