SQL dB...

Discussion in 'General Software Discussion' started by e-Seeker, Oct 10, 2002.

  1. e-Seeker

    e-Seeker AKA *e-Seeker*

    Joined:
    Jul 25, 2002
    Messages:
    943
    Likes Received:
    0
    Trophy Points:
    0
    oK, I've 'received' access to a SQL server...
    Now, as I want to run PHP Nuke online, what is the best way/the easiest way to create my database, how do I do it? btw. I'm not able to connect to the server via this command: mysql -h 'server' -u 'username' -p [enter]... why? Anyway, I'm running it on XP, so what I also want to know is which proggy, if any, I can use...
    I've tried with phpMyAdmin, it connects to my base and when I try to dump it via that 'text' file 'nuke.sql' it just doesn't do anything...

    Hope I'm making sense and that someone can help...

    TIA!
     
  2. e-Seeker

    e-Seeker AKA *e-Seeker*

    Joined:
    Jul 25, 2002
    Messages:
    943
    Likes Received:
    0
    Trophy Points:
    0
    oK, I've reloaded everything on the server and managed to create my dB by manually adding tables via phpMyAdmin... I've managed to start the portal and went right on to the Admin section wanting to change several things related to the site... That didn't work so I thought I might CHMOD 666 config.php... oK, that worked and I was able to change what I wanted... I than had to move the root of the site to a diff. DIR and change the database and after that nothing works like it should anymore... :confused: :mad:

    I'm just too confused and on the edge with my nerves...

    ...am still looking for a good advice... Help, to be more precise...

    I know what I want (to do), but some things I've never encountered and I'm not satisfied with partially completed things...

    Is it a problem with mySQL server or in a config file, or what?
     
  3. Sourcer_2002

    Sourcer_2002 BANNED

    Joined:
    Jul 8, 2002
    Messages:
    2,677
    Likes Received:
    0
    Trophy Points:
    0
    dude i would help u help out but as you can see by my frist site im n00b
     
  4. Shaith

    Shaith New Member

    Joined:
    May 6, 2002
    Messages:
    916
    Likes Received:
    0
    Trophy Points:
    0
    Re:

    When you moved the root of the site you failed to tell it you moved the root of the site - it's looking for it in a directory that it doesn't exist in.

    Steps to set up portals:

    1) RTFM!
    2) Create database with phpmyadmin
    3) use mysql to import the nuke.sql file
    4) RTFM AGAIN!
    5) Follow admin startup instructions
    6) RTFM AGAIN!
    7) Back up EVERYTHING
    8) Begin customizing
    9) Cuss at bad code and go get a beer
    10) Try again
     
  5. e-Seeker

    e-Seeker AKA *e-Seeker*

    Joined:
    Jul 25, 2002
    Messages:
    943
    Likes Received:
    0
    Trophy Points:
    0
    Re:

    RTFM... :confused:

    Ehmmm... pointing to the nuke.sql file doesn't read the dump, says there's no SQL query present, but copy pasting it in the dialog window solves it right... |I'm trying to see if it's a problem in the database or somethin' else|

    From what I've seen, I've done everything right... Actually, most problems I'm having are 'user registration' related... Which, of course, leads down to the database...

    I'll see what else I can do, but thanx for your input! :)
     
  6. One of the Twelve

    One of the Twelve New Member

    Joined:
    Jul 28, 2002
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    0
    RTFM stands for "Read The F-Manual".
    Section nine - go get some fresh, cool water instead of... ;)
     
  7. e-Seeker

    e-Seeker AKA *e-Seeker*

    Joined:
    Jul 25, 2002
    Messages:
    943
    Likes Received:
    0
    Trophy Points:
    0
    Re:

    O.. tx! :)

    Nah, I prefer good beer!
     

Share This Page

visited