1
LifeMatrix
Re: Getting additional MySQL databases?
  • 2007/8/31 5:47

  • LifeMatrix

  • Just popping in

  • Posts: 8

  • Since: 2007/8/24


Those are some helpful answers and suggestions. This really helps clarify what I need. Thank you for your time.

There's just something else that has me concerned:

5) Is it possible to make a local (on my own PC) backup of the MySQL database(s) which reside on my web host?

6) If the above is true, then is it possible to upload your backup database to replace the contents of the existing one?

I have a feeling that this might depend on the web host and what kind of plan you have.



2
LifeMatrix
Getting additional MySQL databases?
  • 2007/8/30 11:21

  • LifeMatrix

  • Just popping in

  • Posts: 8

  • Since: 2007/8/24


I am a XOOPS newbie and I've been reading the Installation Instructions and I have a couple questions about the following:

Quote:
It assumes you already have a working environment, that is either LAMP or WAMP.


Quote:
...already have a place to run together the web server Apache, the database manager MySQL and the scripting language PHP, either on a Linux or a Windows platform, either on your local machine or on a hosted remote server.


There are still numerous hosting services with hosting plans that do not offer all of the above. (And even then, sometimes these programs are rather outdated.)

Questions:

1) On a host with free hosting plans (such as zendURL.com), is it possible to create and manage additional MySQL databases independently of using the Cpanel? I'm talking about something I could upload and install on my own. Couldn't I just install phpMyAdmin on a host to make additional databases?

Many free web hosts only provide 1 MySQL database and, even then, there is sometimes a strict size limit. If a particular plan comes with 2 GB of storage and only one 10 Mb MySQL database, I'd prefer to take better advantage of the storage space.

2) Does XOOPS use the MySQL database to store all or most of its data? Or, can it be set up so that it only uses MySQL to index the data and store most of the content outside of the database? (Sorry... perhaps I just don't grasp how MySQL works?)

3) About how many MB in size is the MySQL database for a typical small/medium (about 50 members) Invision Forum website? I'm asking for a guestimate...

4) Is it possible to set up MySQL, PHP and/or Apache on a free web host (such as Yahoo Geocities) when none of these services are provided in their free plan? Again, I'm talking about something you could install on your own.

One reason I'm asking these questions is because of something I read in the forums: Re: Has XOOPS lost its appeal?

Quote:
I have learned one important thing about all CMS. Keep your databases separate, and is you have to use a bridge make sure it's well supported. Rebuilding databases is a pain.


As I plan on using a variety of modules (including a forum, image gallery, guestbook, blog, and more) I worry that I will run out of MySQL databases and/or room. I may end up with a commercial hosting package, but I still need to know my needs/requirements.




TopTop



Login

Who's Online

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


Members: 0


Guests: 158


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits