MySQL Tables [message #7003] |
Thu, 31 October 2002 21:35 |
|
poggy
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 |
Ilia
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 |
Ilia
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
|
|
|
|