removing sample data after installation?

Need help with the Administration of your Joomla! 1.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
danrop
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Feb 22, 2008 7:25 pm

removing sample data after installation?

Post by danrop » Fri Feb 22, 2008 7:28 pm

Hi all,

I just installed Joomla 1.5, and checked the option for installing sample data. But now I'd like to get rid of the sample data... would it be sufficient to drop all tables from the database from the control panel for my web host?

Thanks!

herb200mph
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3592
Joined: Sun Jun 25, 2006 12:12 am
Location: Salisbury, NC/USA (N. of Charlotte)
Contact:

Re: removing sample data after installation?

Post by herb200mph » Fri Feb 22, 2008 7:59 pm

Delete all articles, empty trash.

Delete all Categories.

Delete all Sections.
Author: Joomla! 5: Boots on the Ground, Volume 1 @ Amazon.com
Author: Joomla! 4: BASIC TRAINING - Boots on the Ground @ Amazon.com
Joomla! Magazine - https://magazine.joomla.org/all-issues/ ... c-training

User avatar
PhilOSparta
Joomla! Guru
Joomla! Guru
Posts: 534
Joined: Sun Feb 25, 2007 10:44 pm
Location: New Jersey, USA
Contact:

Re: removing sample data after installation?

Post by PhilOSparta » Sun Aug 31, 2008 6:07 pm

herb200mph wrote:Delete all articles, empty trash.
Delete all Categories.
Delete all Sections.
There are also menus to clean out and possibly delete. Given the number of iterations that you go through, it takes about a half hour on a local development platform to get down to the bare bones Joomla with all the core modules intact.
Now you want to do it on the internet. The time starts to get exorbitant, and when you have a number of sites that you want to build, you start looking for a way to save time. That's where I am right now.

As a point of interest, if you install Joomla without the sample data, you end up with a system that doesn't have most of the core modules. You only get the main menu.

Is there a way to take a site that has been stripped of all its sample data and save the mysql DB and use it as the sample data for the next new install?

User avatar
2ninerniner2
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3231
Joined: Sun May 25, 2008 8:05 am
Location: Calgary, Alberta, Canada
Contact:

Re: removing sample data after installation?

Post by 2ninerniner2 » Sun Aug 31, 2008 6:55 pm

Bonjour,

I have done this with a few variations of the type of sites that I set up the most: basic, with Community Builder, with Virtue Mart, etc. You can do it locally, but I have put together my own "default" installs on-line - once! :) Added all the various extensions that I normally use first and make sure they work properly in a live environment. When all is well and good, then I create a ZIP of the complete site and an export of the database WITH the 'structure'. Then, on the new site, I upload and un-ZIP the archive, create the database and do the import and finally, edit the configuration.php file with the new parameters. Done :) Saves a whole lot of time :)

Cheers!
Lyle
@snifflevalve

User avatar
PhilOSparta
Joomla! Guru
Joomla! Guru
Posts: 534
Joined: Sun Feb 25, 2007 10:44 pm
Location: New Jersey, USA
Contact:

Re: removing sample data after installation?

Post by PhilOSparta » Tue Sep 02, 2008 1:23 am

Lyle,
Thanks for your info. I followed your example and it worked fine. It was my intention to basically start from a fresh load of Joomla and work from there. I provide the following information for anyone that has followed this thread and would like to see the whole process. ( As always, use caution when working on a live site. Backup everything prior to starting. )

Load Joomla to your site with all the sample data. This is the sequence of steps to remove most of the sample data.
Article Manager - Trash All
Trash Manager - Delete All
Category Manager - Delete All
Section Manager - Delete All
Menu Manager - Delete those not wanted. I keep the Main and Top ( Joomla requires one )
Menu Trash Manager - Delete All
The next are Optional if you don't want them:
Banner Manager - Delete all Banners, Clients and Categories
News Feed Manager - Delete all feeds and categories
Poll Manager - Delete all
Web Link Manager - Delete all links and categories
Module Manager - Delete Admin Welcome and turn off ones you don't want running. Example: banners etc.
Template Manager
At this point, you have a bare bones Joomla without the sample data but with the core modules intact. ( less the optional ones you may have uninstalled.)

Now, if you want to duplicate this bare bones site to other sites without having to go through all the above steps:
1. Export the database (from the above site) and save it. It's used to provide the new site's DB.
2. Load Joomla to a new site, but don't go through the install procedures.
3. Create an empty mysql database on the new site.
4. Import the database created in step 1 into the new DB created in step 3..
5. Copy the configuration.php file from the original site to the new site and make changes to reflect the new site's info. e.g. host name, password, site name etc.
6. Rename the installation directory to something else or delete it.
That's it. You should be able to access the new "cloned" site with the same admin name and password.

ChickenBall
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Sep 08, 2008 7:03 pm

Re: removing sample data after installation?

Post by ChickenBall » Wed Sep 10, 2008 4:10 pm

Thanks for the guide - I wish there was a simpler way to do it, but I'm just nitpicking.

You missed a couple extra things that should be done to keep things as clean as possible.

In the Menu Manager, if you decide to keep Main Menu and Top Menu, you will need to delete all links pertaining to the articles you deleted, otherwise you will get Error 404's if you or a user attempts to click them. :)

For Main Menu, these are:
- Joomla! Overview
- What's New in 1.5?
- Joomla! License
- More About Joomla!
- FAQ
- The News

You can delete all menu items in Top Menu, but it would be recommended to have at least one valid menu item, as it may break your template design to have no items listed. I put in the Administrator link, which I find handy to have during the testing phase - it gets removed if you delete the Resources menu, so you can either copy it to the Top Menu or create a new external link menu item pointing to "administrator/" without the quotes. You can just keep the Resources menu if you wish, but if you want to keep the Top Menu as well, you need to put a link in there regardless.

Finally, when done, don't forget to empty the menu trash.

tstevenson
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Mon Aug 03, 2009 12:04 am

Re: removing sample data after installation?

Post by tstevenson » Sat Aug 08, 2009 2:05 pm

I just installed joomla with the sample data. Question: instead of deleting it, can I simply change the titles and information as I go (replace) everything?

User avatar
PhilOSparta
Joomla! Guru
Joomla! Guru
Posts: 534
Joined: Sun Feb 25, 2007 10:44 pm
Location: New Jersey, USA
Contact:

Re: removing sample data after installation?

Post by PhilOSparta » Sun Aug 09, 2009 7:49 pm

tstevenson wrote:I just installed joomla with the sample data. Question: instead of deleting it, can I simply change the titles and information as I go (replace) everything?
There's a lot of info contained in the sample data. The decision is your's to make. For someone just getting started it may be a detailed learning experience.

After having built 20 or more sites, I find it much better to start out with a clean system and build only what you want.

Good luck with your site, and I hope you have fun no matter which way you decide.

Regards,

Phil

tstevenson
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Mon Aug 03, 2009 12:04 am

Re: removing sample data after installation?

Post by tstevenson » Sun Aug 09, 2009 11:25 pm

Thank you!

tstevenson
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Mon Aug 03, 2009 12:04 am

Re: removing sample data after installation?

Post by tstevenson » Sun Aug 09, 2009 11:27 pm

I was afraid to do that because I was reading some of the threads and they said by doing that you may not get (or delete) some of the tables and other things that go with it....

User avatar
PhilOSparta
Joomla! Guru
Joomla! Guru
Posts: 534
Joined: Sun Feb 25, 2007 10:44 pm
Location: New Jersey, USA
Contact:

Re: removing sample data after installation?

Post by PhilOSparta » Sun Aug 09, 2009 11:54 pm

You actually don't lose any tables etc., but you really start with a clean slate. All the modules, components and plugins are there, but you need to create your own copies if you need them. For instance, if you want a poll, you have to create one. That's all easily done in the module manager. When you start out clean, you don't have all the baggage of the sample structures. Each to his own.


Phil

tstevenson
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Mon Aug 03, 2009 12:04 am

Re: removing sample data after installation?

Post by tstevenson » Mon Aug 10, 2009 12:41 am

Thanks Phil, I may try that then.

Varsys
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Sep 18, 2008 3:31 pm
Location: Chicago, IL
Contact:

Re: removing sample data after installation?

Post by Varsys » Sat Oct 24, 2009 11:25 pm

PhilOSparta wrote:Lyle,
Thanks for your info. I followed your example and it worked fine. It was my intention to basically start from a fresh load of Joomla and work from there. I provide the following information for anyone that has followed this thread and would like to see the whole process. ( As always, use caution when working on a live site. Backup everything prior to starting. )

Load Joomla to your site with all the sample data. This is the sequence of steps to remove most of the sample data.
Article Manager - Trash All
Trash Manager - Delete All
Category Manager - Delete All
Section Manager - Delete All
Menu Manager - Delete those not wanted. I keep the Main and Top ( Joomla requires one )
Menu Trash Manager - Delete All
The next are Optional if you don't want them:
Banner Manager - Delete all Banners, Clients and Categories
News Feed Manager - Delete all feeds and categories
Poll Manager - Delete all
Web Link Manager - Delete all links and categories
Module Manager - Delete Admin Welcome and turn off ones you don't want running. Example: banners etc.
Template Manager
At this point, you have a bare bones Joomla without the sample data but with the core modules intact. ( less the optional ones you may have uninstalled.)

Now, if you want to duplicate this bare bones site to other sites without having to go through all the above steps:
1. Export the database (from the above site) and save it. It's used to provide the new site's DB.
2. Load Joomla to a new site, but don't go through the install procedures.
3. Create an empty mysql database on the new site.
4. Import the database created in step 1 into the new DB created in step 3..
5. Copy the configuration.php file from the original site to the new site and make changes to reflect the new site's info. e.g. host name, password, site name etc.
6. Rename the installation directory to something else or delete it.
That's it. You should be able to access the new "cloned" site with the same admin name and password.
Thanks PhilOSparta. Cloning a database is a great idea and saves a lot of time!

User avatar
2ninerniner2
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3231
Joined: Sun May 25, 2008 8:05 am
Location: Calgary, Alberta, Canada
Contact:

Re: removing sample data after installation?

Post by 2ninerniner2 » Sun Oct 25, 2009 6:46 pm

One of the MAIN reasons that I use a "clean" install (that is, NO sample data) to build my "starter" sites is that the Sample Data installation that comes with the default Joomla! install has a number of menu item "overrides" for the "Article Manager" parameters. This is one, if not THE main reason why one sees so many posts here on the subject of "how come I set the article parameters to not show author name" or the like and then "it shows up anyways". This is because the Sample Data has overridden this in the Menu Item parameters, and if you just delete the content from the Sample Data, you are NOT resetting the Menu Item defaults. This is especially crucial if one uses the "copy menu item" (like I do) to save time when creating a number of them with similar parameters. Start "from scratch", build your default install as required and set all the parameters as you will usually use them. Saves SO much time and effort :)
@snifflevalve

fortnox007
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Jan 19, 2010 12:20 pm

Re: removing sample data after installation?

Post by fortnox007 » Tue Jan 19, 2010 12:40 pm

Dear Danrop,

In a nutshell this is what i did and its more time efficient!!

+Delete: configuration.php
+Upload: your 'installation folder'
+Browse to your website and follow the installation steps as if nothing happend
----------
=A clean slate*

*Make sure you dont do this if you allready added templates modules etc. It could cause unpredictable troubles, sincethe files are on your server but the database is fresh

---------------------------
If you found this usefull let me know

Russ_Kauk
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon May 04, 2009 8:49 pm

Re: removing sample data after installation?

Post by Russ_Kauk » Wed Jan 20, 2010 6:53 am

I've got a question that is similar to the initial one asked here.

I've followed along with this thread and wonder if there isn't possibly a different approach.

I have a "fresh" initial install of Joomla with the demo data. I've installed and modified a template so that I have a good starting point with the overall site look and feel.

Now I'd like to create a new empty set of db tables, point the site to those tables via the prefix setting and start creating new content.

Can it be this simple to switch from the demo data to a set of live data? What tables need to be created and is there any sort of process available that will create a new empty set of tables?

Thanks in advance.

pansab
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Apr 27, 2010 2:23 pm

Re: removing sample data after installation?

Post by pansab » Wed May 05, 2010 4:09 pm

I had the same question and thought that deleting all items was cumbersome..

One was already mentioned.. if you have controll over your own server you could do this.

Right after install move the install folder to something else, rather than deleting

mv installation installation.old

Once you want to drop, backup the config file

mv configuration.php configuration.php.site1

and put the install dir back:

mv installation.old installation

and run the installer.... now if you want to keep both sites, make sure to give the dB a new name, there will just be 2 dB's in the mysql db.. no biggie

Once you installed it, move the installation file again

and you are up and running..

You can now also easily switch between sites..

in this case:

mv configuration.php configuration.php.site2
mv configuration.php.site1 configuration.php

will bring back your original site, just hit refresh!

iisguru
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Oct 23, 2007 3:04 am

Re: removing sample data after installation?

Post by iisguru » Sun Jul 25, 2010 11:10 pm

Varsys, thanks for the excellent steps. I am new to Joomla. Could you please explain what you meant by "Load Joomla to a new site, but don't go through the install procedures" as the 2nd step in cloning a cleaned site?

On my web hosting server, I get only the option to install and not copy the installation folder to the root of the site. Maybe I can do that through ftp. Can you please help with the step 2. Thanks a lot.

samconley
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Nov 25, 2010 3:20 am

Re: removing sample data after installation?

Post by samconley » Thu Nov 25, 2010 5:12 am

Phil,

Thank you for sharing your "clean slate" method. One question. You mentioned earlier that you save this database for future installations. How do I do that exactly? I'm a complete beginner and have never done this before.

Also, every time I refresh my site, I get a message saying the URL is not valid and can not be loaded. I then press OK and it the clean install appears.

Please take a look and tell me what you think.

www.jerseyenglish.com/joomla

Thank you very Much

Sam

modhumiah
Joomla! Intern
Joomla! Intern
Posts: 56
Joined: Wed Feb 24, 2010 2:14 am

Re: removing sample data after installation?

Post by modhumiah » Wed Dec 01, 2010 5:50 am

samconley,

There is a wrapper menu published and I guess the wrapper menu is set as default menu. But in the wrapper menu setting the url option is left blank hence joomla is trying to open "http://" which is not a valid url. You need to make the home page a default or try giving the wrapper menu setting a url to temporarily fix the problem.

eduan
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Dec 10, 2010 9:33 am

Re: removing sample data after installation?

Post by eduan » Fri Dec 10, 2010 9:48 am

Hi I know that this is an old thread but I have found a solution.
There is a free component that does all these things for you without a problem. Create the perfect template website locally and back it up using Akeeba Backup. I prefer it if you set the settings to export a ZIP file. Then upload the ZIP file to the new website url. Extract the ZIP file and then go to the frontend. Finish the install and there you have it. Moved a whole sit in a flash.

http://extensions.joomla.org/extensions ... ackup/1606

User avatar
tmsajin
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Dec 29, 2008 9:21 am
Contact:

Re: removing sample data after installation?

Post by tmsajin » Mon Dec 13, 2010 10:30 am

I have prepared a sql script for removing the sample data after joomla installation,

i have posted it here. Please copy and paste the code.

http://tmsajin.[URL banned].com/2010/12/del ... g-sql.html

Danno61
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Jan 10, 2011 3:32 am

Re: removing sample data after installation?

Post by Danno61 » Mon Jan 10, 2011 3:40 am

Thank you for this... It seemed to work like a charm...

I am brand new to Joomla and it cleaned my Joomla completely. I just hope it diddn't mess anything up. :)

Note: to run these queries in Cpanel use myphp5




tmsajin wrote:I have prepared a sql script for removing the sample data after joomla installation,

i have posted it here. Please copy and paste the code.

http://tmsajin.[URL banned].com/2010/12/del ... g-sql.html
Thanks again

LSc
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Sun Nov 07, 2010 3:28 pm
Location: Tønder, Denmark

Re: removing sample data after installation?

Post by LSc » Tue Aug 07, 2012 8:22 am

2ninerniner2 wrote:Bonjour,

I have done this with a few variations of the type of sites that I set up the most: basic, with Community Builder, with Virtue Mart, etc. You can do it locally, but I have put together my own "default" installs on-line - once! :) Added all the various extensions that I normally use first and make sure they work properly in a live environment. When all is well and good, then I create a ZIP of the complete site and an export of the database WITH the 'structure'. Then, on the new site, I upload and un-ZIP the archive, create the database and do the import and finally, edit the configuration.php file with the new parameters. Done :) Saves a whole lot of time :)

Cheers!
Lyle
Hi
I have, with great interest, followed this thread and I thank you for sharing your experience :)
But I still have a question to Lyle, when you make the zip of the complete site - after having installed the different extensions, do you make that within the Joomla! site (how??) or do you download the whole site and then zip it locally. If you do it locally, doesn't Joomla! get completely confused, when uploading a Joomla! site into a Joomla! site?

:0)
Lisbeth

User avatar
2ninerniner2
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3231
Joined: Sun May 25, 2008 8:05 am
Location: Calgary, Alberta, Canada
Contact:

Re: removing sample data after installation?

Post by 2ninerniner2 » Wed Aug 08, 2012 7:30 am

Lisbeth,

The ZIP of the Joomla! installation is not done from within Joomla!

If I am doing this on a local installation, I use 7-Zip (or Win Zip, or whichever ZIP utility you wish ... I prefer 7-Zip :) )

If I am doing this on a remote, hosted site, then I use the ZIP utility (archive / compress utility) that the hosting control panel provides; for any hosting account that uses "cPaneL", this is a breeze! :)

With either method, just to clarify, Joomla! won't get "confused" because this IS the Joomla! that you will be using! ... one does NOT install Joomla! first! :) ... that is what you are doing with this process :)

To summarize then; using this method is "installing" Joomla! without using the Joomla! installer :) ... this is what is what I call a "manual" installation. Also keep in mind, that this will be a brand-new Joomla! site; it is not meant to "replace" or "update" and existing one.

And don't forget the database! That's just as important :)

Cheers!
Lyle
@snifflevalve

LSc
Joomla! Intern
Joomla! Intern
Posts: 76
Joined: Sun Nov 07, 2010 3:28 pm
Location: Tønder, Denmark

Re: removing sample data after installation?

Post by LSc » Wed Aug 08, 2012 7:48 am

Ahh - OK, now I get it :)
I'll try it out right away.
Thanks a lot!
:)
Lisbeth

vikirulz09
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Sep 29, 2010 10:52 am

Re: removing sample data after installation?

Post by vikirulz09 » Tue Jan 08, 2013 1:54 pm

Hello every body done as noted...

but shows the error 404...
any help....how to restore back :-[

fuscha
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jan 27, 2013 4:02 am

Re: removing sample data after installation?

Post by fuscha » Wed Aug 07, 2013 2:23 pm

I just got this awesome template but i have done a lot of work on the site and it says that my entire site will be deleted once i install sample data. Would copying my site and adding it back to the server stop the template from destroying my e-commerce site? Any suggestions appreciated.


Locked

Return to “Administration 1.5”