Joomla: Installing Sample Data After The Installation, Installing the included sample data after installing Joomla

[Richardus]

If you get errors when installing the sample data, you can skip that step and do it after you finish your installation.

Here's how:

1. Open the file /installation/sql/mysql/sample_data.sql with a text editor
2. Find and replace every #__ with the prefix you used in your database when installing Joomla. It is jos__ by default [without quotation marks]. If unsure, check your sql database manager.

The entries would look like:

CODE

#__banner --> jos__banner

3. Save the file and open your dababase manager (SQL Buddy in this case), and enter to the "Import" section.
4. Select the file and import it.

If everything goes well, the next time you open your website you'll find a sample page.

IF AFTER THESE STEPS YOU DON'T SEE A SAMPLE PAGE, OR IF YOU GET ERRORS, FOLLOW THE NEXT STEPS:
I had problems installing the data using the standard procedure, so I had to follow the next steps:

A. Open the sample_data.sql file you just modified
B. Copy every section that starts with INSERT or UPDATE:


COPY THE HIGHLIGHTED CODE

C. In SQL Buddy, open the "Query" section, and paste the code. You can copy all the code or block by block.
D. Execute the query

If you see no error message, copy all the rest of the sections and you're done. If you get errors saying to check your syntax, verify you have copied all the commas, semicolons, etc. If you get an error saying you have a duplicate key, delete that key from the code and continue with the rest.

[brettbrielle]

To understand the Joomla is so easy as compare to the installation of the Joomla because lots of tricky step are there while installing the Joomla.But after seen installation tutorial where actually where i am making the mistake i known that awesome tutorial.

[aleabby]

I am new to this forum and experiencing Joomla first time. I am thankful to you that you have share such a great info.

[malkolaly]

Thank you very much

[YAKKO]

nice curse
for configuration joomla

nice!
thanks

[Millie5]

I am new in development field, So it is so useful and helpful for me. I'm greatly appreciated this forum's posts to explain the all techniques separately for initials.. I'll get help from the post while making Joomla Configuration..