1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[help] install database on forum

Discussion in 'BlackHat Lounge' started by spenzo, Oct 28, 2009.

  1. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    hi folks.. i am in trouble
    i have database of many good warez+non-warez forum

    like vbulletin,phpbbm,smf forums or wordpress..

    i just wondering how to install these database to my forum ??

    anybody have any idea ?
     
  2. blogdev

    blogdev BANNED BANNED

    Joined:
    Sep 29, 2009
    Messages:
    128
    Likes Received:
    101
    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 ;)
     
  3. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    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 :)
     
  4. blogdev

    blogdev BANNED BANNED

    Joined:
    Sep 29, 2009
    Messages:
    128
    Likes Received:
    101
    Simply remove yours :p
     
  5. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    hahha.. thnx anyway dude :)
    is their anyway to find that database is for smf,vbulletin, or phpbb ??
     
  6. ukescuba

    ukescuba Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    994
    Likes Received:
    634
    Occupation:
    Mobile Marketer & QR Code Junkie
    Location:
    San Antonio, TX
    Home Page:
    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 :)
     
    Last edited: Oct 28, 2009
  7. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    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 ??
     
  8. blogdev

    blogdev BANNED BANNED

    Joined:
    Sep 29, 2009
    Messages:
    128
    Likes Received:
    101
    Yes, just make sure you keep the same Admin username and password ;)
     
  9. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    its giving an error while importing only 7 tables are imported but where to show that data ??
    i mean my forum is still empty :( :(
     
  10. blogdev

    blogdev BANNED BANNED

    Joined:
    Sep 29, 2009
    Messages:
    128
    Likes Received:
    101
    What kind of error bro ?
    Send me a pm i'll help you on this one :p
     
    • Thanks Thanks x 1
  11. ukescuba

    ukescuba Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    994
    Likes Received:
    634
    Occupation:
    Mobile Marketer & QR Code Junkie
    Location:
    San Antonio, TX
    Home Page:
    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
     
  12. ukescuba

    ukescuba Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    994
    Likes Received:
    634
    Occupation:
    Mobile Marketer & QR Code Junkie
    Location:
    San Antonio, TX
    Home Page:
    good point! lol

    you can always import this from your original database! lol done that before more than a few times! :)
     
  13. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    can anyone one of u do me favour i can give u my cpanel urname and pass.. i just wanna install database on my SMF forum...
     
  14. blogdev

    blogdev BANNED BANNED

    Joined:
    Sep 29, 2009
    Messages:
    128
    Likes Received:
    101
    Yeah send info to ukescuba :D
     
  15. ukescuba

    ukescuba Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    994
    Likes Received:
    634
    Occupation:
    Mobile Marketer & QR Code Junkie
    Location:
    San Antonio, TX
    Home Page:
    pm me the info - i wont be able to do it till this evening am actually heading out right now - yep its 4am! :(
     
    • Thanks Thanks x 1
  16. spenzo

    spenzo Senior Member

    Joined:
    Oct 20, 2009
    Messages:
    967
    Likes Received:
    553
    thnx for ur kind attention buddy.. just tell me when ever u r free to do this