Step 4 – Create the database and import the joomla.sql data

Access your database server using your preferred MySQL control system, we are going to use PHPMyAdmin and create the database with the name you entered in the configuration.php file at Step 1 . If you are on a shared hosting, remote server you will probably have been given a specific Database name and do not therefore need to take this action.

Create a new database

Select the Import tab in PHPMyAdmin and then browse to the correct directory from the joomla_root/installation/sql/mysql directory and select the edited joomla.sql file. Click Go and the data is imported into the database to create the table structure of the installation. Replace joomla_root/installation with the correct path to the file on your local disk.

Importing joomla.sql file into prepared database

After the data is successfully installed you will notice that the Tables are now displayed in the left hand pane of the PHPMyAdmin interface.

Successful Import of joomla.sql into the database displaying newly created Tables

Congratulations, you have now successfully manually created your Joomla! Web site. To verify this open your browser and enter the address (in our demonstration examples' case) localhost/joomla (replace localhost/joomla with the full URL if the installation is on a remote server) and you will see your new Web site, although it will look pretty bare. You will not be able to access the site to log in and the Administrator Back-end will not be accessible as you do not yet have an admin user.

Basic Joomla! Web site view after completion of database and Table creation

By default Joomla! creates the Main Menu with the associated Home Menu Item, but that is all that is available. Proceed to the next Step to Create an administrator User account Step 5