FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » MySQL Tables
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
icon5.gif  MySQL Tables [message #7003] Thu, 31 October 2002 21:35 Go to next message
poggy is currently offline  poggy   United Kingdom
Messages: 11
Registered: October 2002
Location: Stockport, UK
Karma: 0
Junior Member
Just a quick question...I'm considering getting some quality web hosting to run my forum and web site but the problem is the provider I'm looking at only offers one MySQL database. Would it cause a problem if I installed the forum then added a few tables to run my main web site from? Would a future upgrade overwrite these tables or anything? And while I'm on the subject what would be the best method for transfering my forum to the new web space (custom theme and all!)? The database name will be different but the domain will stay the same.

--
Mark Ogden
mark(at)poggy(dot)net

[Updated on: Thu, 31 October 2002 21:50]

Report message to a moderator

Re: MySQL Tables [message #7004 is a reply to message #7003] Fri, 01 November 2002 01:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
1 database is more then enough, heck you could run many forums on a single database. For example, on my test server I have 15 forums runnings on a single database.
This is possible because FUDforum uses an SQL prefix, which you can specify during the install process. This prefix allows you to enter a unique text that will be prefixed to each table name. Thus ensuring the tables will not be confused with other tables you may have.


FUDforum Core Developer
Re: MySQL Tables [message #7005 is a reply to message #7004] Fri, 01 November 2002 01:20 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The best way to transfer a forum is to do a datadump on the original and then import the said datadump into the new forum.

FUDforum Core Developer
Re: MySQL Tables [message #7014 is a reply to message #7003] Fri, 01 November 2002 17:14 Go to previous message
poggy is currently offline  poggy   United Kingdom
Messages: 11
Registered: October 2002
Location: Stockport, UK
Karma: 0
Junior Member
Great! Thanks prottoss. Hopefully come next pay day I'll have some fast web space to run my forum on. WOOHOO! Very Happy Very Happy

--
Mark Ogden
mark(at)poggy(dot)net
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: NNTP.PHP without PHP-binary
Next Topic: signature-like text
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 20:03:47 GMT 2024

Total time taken to generate the page: 0.02382 seconds