Populate The Database
Now that we've created a database, it's time to fill the database with tables and information to make it an Article Friendly database!
Creating tables with phpmyadmin.
Once you've found the "phpMyAdmin" link at the bottom of your cpanel's database creation page (older versions of cpanel) or the homepage of your cpanel page, you should now have phpmyadmin open on your computer. Make sure it's showing in a maximized window for easy viewing.
The very first thing to do is locate the part of your phpmyadmin as shown in the image above. See where it says "bling_database" in the images? The username_database you created should be showing in your phpmyadmin, along with a little 0 (zero) behind it. Click on that link.
You should now see some tabs in top middle part of phpmyadmin that look similar to the image above. Click on the "SQL" tab, and the image below is what you should be seeing...
Put phpmyadmin on hold for a sec.
Now is the time to go back to your file manager (on your local computer) where you unzipped the Article Friendly files, and find the : "articlefriendly_pro/SQL_new_database/AFPro.sql" file and open it in either notepad or PsPad. Then select all the AFPro.sql file contents, and copy to your computer's memory! We are going to paste the entire contents of the AFPro.sql file into that open SQL window back in your phpmyadmin. Please note that the path to the Article Friendly standard edition's sql file would be "articlefriendly/SQL/AF.sql".
Once you've copy/pasted the contents of the AF.sql into your phpmyadmin window, it should look similar to the image above. Click on the "Go" button, and all the tables will be created for you automagically!
If you did everything correctly, you should be able to see the username_database name that used to say no tables found in the database you created (first image at the top of this page), now shows about 9 tables in a list and the number nine after the username_database name!
Watch The Movie!
We can now close phpmyadmin and your cpanel, and return to Filezilla to add the database information you saved previously in notepad to the configuration files for Article Friendly. Then we can set your admin options.
