Welcome to Geeklog, Anonymous Monday, May 20 2024 @ 08:41 am EDT

Geeklog Forums

why no forum for a web blog site?


clubmedia

Anonymous
i just came across this site and love it already and plan on setting up a site using it asap. first question: where is a real forum to discuss this on here? question two: i have a MySQL database that is already running to forums, although i really no nothing at all about MySQL. i want to to know what do i have to do to set up a site with geeklog running off the same database. i had someone set up the 2 boards for me, but i want to start trying to do this myself. if i just try to set it up using the installer file, will it over write my existing database or will it simple create a section for it to work and leave my existing "required" info as it is. i am afraid to set it up and erase my existing database.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany

In the Geeklog config.php configuration file, you can set a prefix for all the tables used by Geeklog. It defaults to 'gl_', but you can choose anything you want there. I'm running three Geeklog sites off of one database that way.

There's only one catch: The table for the static pages plugin (which comes bundled with Geeklog) does not use that prefix. If your database already contains a table named 'staticpage' you need to be careful. Otherwise, that shouldn't be a problem (and I keep nagging Tony to fix this for the next release ;-)

bye, Dirk

 Quote

Status: offline

efarmboy

Forum User
Moderator
Registered: 02/26/02
Posts: 147
MySQL is just the database engine. You can create multiple individual databases for your applications. By default Geeklog will create a database in MySQL called "geeklog" but you can specify the database name in the config.php file. Within the database, Geeklog install.php will create tables for the data. The prefix to the tables are by default gl_ . I run several installs of Geeklog for testing but always config the different installs to use different databases. This way, I don't have to worry about the table names - the databases are completly seperate. You can also backup and restore each database as individuals files easily. Cheers, Blaine
 Quote

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
Location:Urbandale, Iowa
Correction...Geeklog never creates the database for you (maybe it should). It expects the database to exist prior to running the install script.
The reason people blame things on previous generations is that there's only one other choice.
 Quote

Status: offline

MLimburg

Forum User
Chatty
Registered: 12/17/01
Posts: 35
Location:Adelaide, AU
yeah .. i can think of a few options with this also .. a) create new database b) drop old database and create new database (gulp) in addition, i'd like to see the install script moved to \public_html\admin
Friends help you move. Real friends help you move bodies.
 Quote

Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
you can always ask your question in the IRC forum, see the Support info.
http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com
 Quote

clubmedia

Anonymous
how do i find out if i have a table named "staticpage" in my database? i have installed 2 ikonboards only on the database. does anyone know if those installations create a "staticpage"? thanks for all the info!
 Quote

Anonymous

Anonymous
type: mysql -u <user> -p <database> íf you have a prompt like mysql> type: show tables; (with Control-D you exit)
 Quote

All times are EDT. The time is now 08:41 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content