How to Install a MySQL Database using a MySQL Injection Script

Whenever you purchase or acquire a MySQL database (such as from a website like WebContents.org), chances are it will come as a MySQL injection script. An injection script is simply a SQL script that, when executed, creates the appropriate database tables and inserts the data using INSERT statements (one statement per record of data). Because of this, a SQL injection script is usually very large, but this is the easiest way to export and import a database so this is how it is usually done.

Once you have the injection script, installing it is usually very easy. Of course, you must already have MySQL Server (mysql.org) installed on your server, so if you haven't done that yet (such as if this is a new server), do it first, then put the script file in an easily accessible location (like the root folder of the server's main hard drive, usually drive C, or in the temp folder).

The process for installing a MySQL database using a MySQL injection script is fairly trivial, but there are a couple of snags you might run into along the way. The only way to find out if these apply to you, however, is to attempt to install the database using the script normally, and deal with exceptions as they occur. To execute the injection script, you first need to create a database to hold the data. Open a command prompt and type in the following command to start the MySQL command-line interface: "mysql -u root -p" (without the quotes). It will prompt you for the root password, then you will be logged into the MySQL instance.

To create the database, use the command "create database imported;" (without the quotes). Substitute the word imported for whatever database name you would like to use, and make sure you put in the semicolon at the end. If successful it should say "Query OK, 1 row affected". Now you are ready to run the injection script itself.

To execute the injection script, use the command "source c:\temp\vegrecipes.sql;" (without the quotes). Use whatever path and filename points to your injection script, and don't forget the semicolon at the end! It may take a while to run depending on how large the script is, but it should say "Query OK, 1 row affected" for each record that it inserts into the database.