HardwareHeaven.com

HardwareHeaven.com

Looking for the skin chooser?
 
 
  • Home

  • Hardware reviews

  • Articles

  • News

  • Tools

  • Gaming at HardwareHeaven

  • Forums

 

Go Back   HardwareHeaven.com > Forums > Software / Tools > Programming, Coding, (Web)Design


Programming, Coding, (Web)Design Discuss all your programming or design needs with likeminded people.

Reply
 
Thread Tools
Old Oct 10, 2002, 05:18 PM   #1
AKA *e-Seeker*
 
Join Date: Jul 2002
Location: Croatia, Zagreb
Posts: 943
Rep Power: 0
e-Seeker is on a distinguished road

Default Post SQL dB...

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!
__________________
e-Seeker is offline   Reply With Quote


Old Oct 11, 2002, 11:26 PM Threadstarter Thread Starter   #2
AKA *e-Seeker*
 
Join Date: Jul 2002
Location: Croatia, Zagreb
Posts: 943
Rep Power: 0
e-Seeker is on a distinguished road

Default Post

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...

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?
__________________
e-Seeker is offline   Reply With Quote
Old Oct 12, 2002, 07:04 AM   #3
BANNED
 
Join Date: Jul 2002
Location: Indiana , USA
Posts: 2,677
Rep Power: 0
Sourcer_2002 is on a distinguished road

Default Post

dude i would help u help out but as you can see by my frist site im n00b
Sourcer_2002 is offline   Reply With Quote
Old Oct 12, 2002, 08:36 AM   #4
HardwareHeaven Senior Member
 
Join Date: May 2002
Posts: 916
Rep Power: 0
Shaith is on a distinguished road

Default Post Re:

Quote:
Originally posted by dEykeé
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...

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?
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
Shaith is offline   Reply With Quote
Old Oct 13, 2002, 01:29 AM Threadstarter Thread Starter   #5
AKA *e-Seeker*
 
Join Date: Jul 2002
Location: Croatia, Zagreb
Posts: 943
Rep Power: 0
e-Seeker is on a distinguished road

Default Post Re:

Quote:
Originally posted by Shaith
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
RTFM...

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!
__________________
e-Seeker is offline   Reply With Quote
Old Oct 18, 2002, 08:20 AM   #6
DriverHeaven Lover
 
Join Date: Jul 2002
Location: The Kold North
Posts: 131
Rep Power: 0
One of the Twelve is on a distinguished road

Default Post

RTFM stands for "Read The F-Manual".
Section nine - go get some fresh, cool water instead of...
__________________
One of the Twelve is offline   Reply With Quote
Old Oct 18, 2002, 02:39 PM Threadstarter Thread Starter   #7
AKA *e-Seeker*
 
Join Date: Jul 2002
Location: Croatia, Zagreb
Posts: 943
Rep Power: 0
e-Seeker is on a distinguished road

Default Post Re:

Quote:
Originally posted by One of the Twelve
RTFM stands for "Read The F-Manual".
Section nine - go get some fresh, cool water instead of...
O.. tx!

Nah, I prefer good beer!
__________________
e-Seeker is offline   Reply With Quote
Reply

Thread Tools