[help] install database on forum
- Thread starter spenzo
- Start date
blogdev
BANNED
- Sep 29, 2009
- 128
- 104
First you need to make sure the DB is compatible with the script you use for your forum, you can easily import a DB using phpmyadmin in your cpanel
blogdev
BANNED
- Sep 29, 2009
- 128
- 104
but buddy suppose i have hosgator pan when i create smf ,or vbulletin forum the database is automatically created then how how integrate database i have with their default database
Simply remove yours
ukescuba
Senior Member
- Feb 24, 2008
- 994
- 640
at a guess normally a scripts database table names are prefixed for example joomla user table in the database is prefixed with jos_ making it jos_users
possibly phpbb user table would be something like phpbb_users
vbulletin vb_users
smf smf_users
just guessing they may not be
hth
additionally i would create a new db and simply change your config files to your forum to read from the new database before deleting your existing one, you may have issues if you are using a script that is out of date with the script your database came from... you may have to convert the database, at the least i think your gonna have some fun and games with it!
but it will be a great way to learn more about databases and scripts! lol
again hope that helps
possibly phpbb user table would be something like phpbb_users
vbulletin vb_users
smf smf_users
just guessing they may not be
hth
additionally i would create a new db and simply change your config files to your forum to read from the new database before deleting your existing one, you may have issues if you are using a script that is out of date with the script your database came from... you may have to convert the database, at the least i think your gonna have some fun and games with it!
but it will be a great way to learn more about databases and scripts! lol
again hope that helps
Last edited:
spenzo
Senior Member
- Oct 20, 2009
- 967
- 557
at a guess normally a scripts database table names are prefixed for example joomla user table in the database is prefixed with jos_ making it jos_users
possibly phpbb user table would be something like phpbb_users
vbulletin vb_users
smf smf_users
just guessing they may not be
hth
buddy i have created i new SMF on hostgator.. so a database with 41 table also created with it
but i have database of very good forum which is also in SMF..
so i imported that database to one that is created with SMF...
so my question is .. can i get same thing as tat of database on my forum or not ??
i mean same postes,threads,sections, etc ??
blogdev
BANNED
- Sep 29, 2009
- 128
- 104
buddy i have created i new SMF on hostgator.. so a database with 41 table also created with it
but i have database of very good forum which is also in SMF..
so i imported that database to one that is created with SMF...
so my question is .. can i get same thing as tat of database on my forum or not ??
i mean same postes,threads,sections, etc ??
Yes, just make sure you keep the same Admin username and password
blogdev
BANNED
- Sep 29, 2009
- 128
- 104
its giving an error while importing only 7 tables are imported but where to show that data ??
i mean my forum is still empty
What kind of error bro ?
Send me a pm i'll help you on this one
ukescuba
Senior Member
- Feb 24, 2008
- 994
- 640
theoretically i dont see why not
this is what i would do...
login to your hostgator cpanel
look for database wizard
this will create a new database for you and assign a new user to it... make note of the password, username and database name
then get ftp access to your site, and find your config file for your forum, download it and rename the current one ie orig-config.php or whatever the config file is called
open up your config file in notepad, or whatever you feel comfortable with and you should see how the file connects to your current database most instances scripts use comment tags to identify this...
simply swap out the existing details with that of your new database, user, password - save and reupload...
all being well, that should be it... your forum should pull all that data from that new database
hth
if it doesnt two most likely things are... the config settings you changed arent correct or the database got screwed up or is not compatible
keep us posted how you got on
this is what i would do...
login to your hostgator cpanel
look for database wizard
this will create a new database for you and assign a new user to it... make note of the password, username and database name
then get ftp access to your site, and find your config file for your forum, download it and rename the current one ie orig-config.php or whatever the config file is called
open up your config file in notepad, or whatever you feel comfortable with and you should see how the file connects to your current database most instances scripts use comment tags to identify this...
simply swap out the existing details with that of your new database, user, password - save and reupload...
all being well, that should be it... your forum should pull all that data from that new database
hth
if it doesnt two most likely things are... the config settings you changed arent correct or the database got screwed up or is not compatible
keep us posted how you got on
ukescuba
Senior Member
- Feb 24, 2008
- 994
- 640
Yes, just make sure you keep the same Admin username and password
good point! lol
you can always import this from your original database! lol done that before more than a few times!
blogdev
BANNED
- Sep 29, 2009
- 128
- 104
spenzo
Senior Member
- Oct 20, 2009
- 967
- 557
pm me the info - i wont be able to do it till this evening am actually heading out right now - yep its 4am!
thnx for ur kind attention buddy.. just tell me when ever u r free to do this