Re: powered by xoops
  • 2004/5/29 22:04

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11

Charging for freely availabel Open Source Software = Foolish

Charging for installing, customizing, and maintaining said software = Good Business ;)

I've started a small side business installing and customizing XOOPS based sites. All copyright notices are left intact in the code and due credit is given on my site.

If this side business ever grows to the point that I can afford it, I will be making donations to the XOOPS project. However, at this point, it only provides enough to cover my hosting and misc. expenses for other ventures; therefore, all I can offer is my time and experiences.

Re: Sharing one mySQL database between multiple xoops sites
  • 2004/5/29 19:09

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11

From what I gathered from your post, the two installs are default. Is this correct? If so.....

1. Drop the tables for the second site
2. Dump the schema
3. Do a find and replace and replace (using an ASCII text editor [Notepad]) the default prefix with something other than xoops_
4. Import the edited schema
5. Reinstall the second site with a prefix other than xoops_

I seem to recall having a similar problem once, and, if I remember correctly, the above steps fixed it.

If not, let me know and I'll look into it further.

Re: Installng Xoops ofline
  • 2004/4/13 3:54

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11



You can find a complete tutorial on how to install multiple sites on your local driver here:


The process is basically the same if you are working with one, or one hundred sites.

Good Luck.

Re: Using Xoops Locally - XSAS
  • 2004/4/12 19:51

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11

No problem.

The steps make the process seem longer than it actually is. Once you've done it a couple times, it will become second nature.


Re: Using Xoops Locally - XSAS
  • 2004/4/11 18:48

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11

First of all, I'd like to commend the XOOPS community for putting together a fantastic CMS. I've used several different CMSs and none can compare with the overal flexibility, security and extensibility of XOOPS. My hat's off to you.

Also, to the developers of XSAS, top job! That is one handy little program!

Now, about using XSAS to develop multiple sites locally.....

1. Create a folder on your hard drive called Localhost

2. Run the XSAS Setup program in that folder

3. Create your folders in the www root of XSAS to represent the different sites you will be developing (i.e.: Clients, Personal, etc.)

4. Extract a fresh distro of XOOPS in a temp folder

5. Copy the html folder from your XOOPS package into the various folders you created in step 3.

6. Rename the html folder to represent the particular site to be developed (i.e.: Client1, Site2, etc.)

7. Start the XSAS server on your local machine

8. Open PHPMyAdmin from the advanced tab of the XSAS GUI

9. Create a database that has the same name as the database used for your published website (the site on the Internet)

10. Open a browser and navigate tohttp://localhost and select the folder of the site you want to install (ex:http://localhost/clients/somecoweb/). This will begin the installation of XOOPS as usual.

11. Setup XOOPS as you normally would

12. Put the database name of the site you want to develop in the appropriate field, but put root as the database username with no password

13. Make sure you change the prefix for the tables to match the database you will import later (if applicable)

14. Complete your installation as usual

15. Export the database from your site that is on the Internet into a text file. (Be sure you export it with complete inserts and add 'drop table'. This will insure a proper import later.)

16. Open the text file in a text editor and do a find and replace for the url

(i.e.: Find the Internet url that the site would use online and replace it with the local url.
ex: Find: http://yourdomain.com/
Replace with: http://localhost/the_directory_where_you_installed_xoops/) Save your file.

**The copy and paste method works best for the aformentioned step.**

17. Open PHPMyAdmin in XSAS and import the database you just edited.

18. Now test your site out.

**If you will be developing multiple sites, I've found it quite convenient to keep a bookmark ofhttp://localhost and I add a bookmark for each additional site when I begin development (i.e.:http://localhost/clients/client1,http://localhost/clients/client2, etc.)**

Now, after you've made all the changes you want to your site locally, you only have a few steps to follow to publish your work online.

19. You essentially repeat steps 15-18, but instead, you export from localhost's database, edit the sql file to change the url to the Internet url, and you import the database into the online SQL server.

**It's also important to note that, if you have added any additional files to your website while developing it locally (i.e.: themes, modules, hacks, etc.), you'll want to upload those files to your web server prior to updating your database.**

On another note. If you want to work on your website away from home, if you've setup your local server as I've outlined, you can just copy the entire Localhost folder onto a USB Pen Drive and take it with you. Then all you have to do is just execute XSAS directly from the pen drive on any Windows 98 and above system. Since XSAS always creates a virtual w: drive, this method works quite well for portable development and demonstration.

Phew! That was a lot of typing! Well, I hope this is helpful for someone. I know I find it quite useful on a daily basis.

Now, if I could only figure out how to add site names to the XSAS GUI like they did xoops2, I'd be set.

« 1 ... 175 176 177 (178)


Who's Online

224 user(s) are online (158 user(s) are browsing Support Forums)

Members: 0

Guests: 224



Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits