|
Eduardo
|
 |
« on: March 19, 2003, 12:22:00 PM » |
|
I think I really got a problem here,
I want to put a forum, a chat room and a classifieds section on my page, but I think that each of them need a database. The problem is that my account only has one. What can I do? is it possible to just buy more databases? I really don't need to upgrade the whole account, latter hopefully I will need it, but right now it seems to much just for a couple of databases..
Once again, thanks in advance...
|
|
|
|
|
Logged
|
Lunarpages has the best forum and forum members on the net!! !["[dance]"]("graemlins/dance.gif" "\"\"") |
|
|
|
Max
|
|
« Reply #1 on: March 19, 2003, 12:49:00 PM » |
|
You can get more databases for just $1/mo All you need to do is to email billing@lunarpages.com !["[Smile]"]("smile.gif" "\"\"") |
|
|
|
|
Logged
|
|
|
|
|
Boris
|
|
« Reply #2 on: March 20, 2003, 12:56:00 AM » |
|
Will max kill me for that answer? You can always rename your database like eduardo_forum_(all the name of the tables) eduardo_chat_(tables) eduardo_classified_(tables) and change the settings in your configs for the name of the tables. Allows you to get more *databases* without paying more..? Please dont kill me for pointing that out! !["[Frown]"]("frown.gif" "\"\"") |
|
|
|
|
Logged
|
Questions on graphics? Visit the lunarpages Graphics forum!
Bugging Danielle daily since 2003.
Have a Lunar Day!
|
|
|
|
amy
|
|
« Reply #3 on: March 20, 2003, 02:09:00 AM » |
|
Not at all. It's a great way to utilise your DB. I use mine the same way |
|
|
|
|
Logged
|
--Amy Armitage
Lunarpages.com
|
|
|
|
Boris
|
|
« Reply #4 on: March 20, 2003, 11:06:00 AM » |
|
I would use it that way too..but i got enough database on the premium account thing !["[Razz]"]("tongue.gif" "\"\"") |
|
|
|
|
Logged
|
Questions on graphics? Visit the lunarpages Graphics forum!
Bugging Danielle daily since 2003.
Have a Lunar Day!
|
|
|
|
Eduardo
|
|
« Reply #5 on: March 20, 2003, 12:44:00 PM » |
|
Uhm, let me get this right. So you mean I can have all the tables (forum, chat and classifieds)in the same DB by just changing the DB name everytime I install each one of these things? That easy? or am I missing something? could there be a secondary problem with this way of managing tables? Still thinking this is the best message board I've ever been!!.... !["[headbang]"]("graemlins/headbang.gif" "\"\"") |
|
|
|
|
Logged
|
Lunarpages has the best forum and forum members on the net!! |
|
|
|
pgp_protector
|
|
« Reply #6 on: March 20, 2003, 08:21:00 PM » |
|
Your not changing the name of the database, your changing the name of the tables in the Single database
Database_name
Table_chatroom
Table_forums
Table_adds
Table_2ndchatroom
Table_2ndforums
ECT.....
|
|
|
|
|
Logged
|
|
|
|
|
CGameProgrammer
|
|
« Reply #7 on: March 20, 2003, 09:04:00 PM » |
|
One database is all you need for this, just use mutiple tables. My database has 13 tables in it -- the entire DB is 670KB.
|
|
|
|
|
Logged
|
~CGameProgrammer( );
|
|
|
|
KJones
|
|
« Reply #8 on: March 20, 2003, 09:28:00 PM » |
|
I only need one database right now, but if I ever need more I hope I'll remember this thread! Is modifying the database tables complicated? I don't know anything about MySQL. Can it be modified from the Control Panel? |
|
|
|
|
Logged
|
"I believe that this nation should commit itself to achieving the goal, before this decade is out, of landing a man on the moon and returning him safely to the earth." - John F. Kennedy
|
|
|
|
Boris
|
|
« Reply #9 on: March 21, 2003, 12:50:00 AM » |
|
It's fairly easy. If you want i could send you screenshot on how to upload your database in mysql But it would take something like opening your whole .sql file and moding it so it doesnt say : CREATE TABLE forum_user but it should say : CREATE TABLE lunarorbit_forum_user or something similar It's just a moment in changing all the forum_user with a prefix in front. Hope i made it clear |
|
|
|
|
Logged
|
Questions on graphics? Visit the lunarpages Graphics forum!
Bugging Danielle daily since 2003.
Have a Lunar Day!
|
|
|
|
Adrian
|
|
« Reply #10 on: March 21, 2003, 06:24:00 AM » |
|
Some premade scripts will just ask you to specify a table prefix when you install so it should just be simple case of not choosing the same prefix twice.
I have had multiple copies of phpBB installed on the same database in this way before for the purpose of making it easy to integrate users and PMs across the boards.
|
|
|
|
|
Logged
|
|
|
|
|
Eduardo
|
|
« Reply #11 on: March 21, 2003, 10:56:00 AM » |
|
Ok, this got too complicated for me, I just don't see where to start. I got my forum set up and running, now I want to add a chat, but I don't know what to do first if I'm going to follow ur advice. Is it too much work to do the things you say here? is it way easier to just buy one more db? (a buck a month I can afford, if this saves me from a lot of hours of work) by the way, do you know where can I get a nice and free classifieds script? !["[redface]"]("graemlins/redface.gif" "\"\"") |
|
|
|
|
Logged
|
Lunarpages has the best forum and forum members on the net!! |
|
|
|
stephan
Guest
|
|
« Reply #12 on: March 21, 2003, 08:24:00 PM » |
|
If you're not sure about it, I would just get the extra database!
It's just $1 a month, so it's not too much of an upgrade, and will save you a lot of stress!
It is possible to have more than one script on a database. Postnuke, phpbb and quite a lot of other scripts ask for a prefix.
|
|
|
|
|
Logged
|
|
|
|
|
Boris
|
|
« Reply #13 on: March 23, 2003, 01:28:00 AM » |
|
yeah. ordering another db might be simpler (or email me...we could try doing that by email? ) |
|
|
|
|
Logged
|
Questions on graphics? Visit the lunarpages Graphics forum!
Bugging Danielle daily since 2003.
Have a Lunar Day!
|
|
|
|
Eduardo
|
|
« Reply #14 on: March 23, 2003, 01:34:00 AM » |
|
nevermind, I already ordered 2 dbs.
wanna keep things simple, maybe latter when I understand more of this bd things I'll do it the hard but cheap way, hehe.
Thank you a lot!!
|
|
|
|
|
Logged
|
Lunarpages has the best forum and forum members on the net!! |
|
|
|
