SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Thread: PHP Nuke

  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello All,
    I have just downloaded php nuke and would like to install it on a Win2k server. I have setup the sql database as nuke, but Im lost on how to add the tables. php nuke come with a file called nuke.sql. This file contains all the tables within it. Its appears to be a SQL dump file. Is there anyway to import this table file to Mysql. I think the file was intended for Linux only. I would hate to add each table one at a time. I'm really new to Mysql and php nuke. Thanks

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    You can feed the .sql file into your MySQL database, but first you need to create the database to store the tables.

    Using the 'mysql' program from the Command Line, log into your MySQL server and enter the following command:

    mysql> CREATE DATABASE phpnuke;

    You're free to choose another name for the database if you wish. Exit MySQL to return to the Command Line. Now you can feed the nuke.sql file into your newly-created database by entering the following command:

    mysql -uuser -ppassword phpnuke < nuke.sql

    This command assumes that the MySQL 'bin' directory is on your path (if it isn't you'll have to type the full path to the 'mysql' program), and that nuke.sql can be found in the current directory. 'user' and 'password' should be your MySQL username and password.

    That should do it!
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  3. #3
    SitePoint Enthusiast vsantola's Avatar
    Join Date
    Jan 2001
    Location
    Portugal
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello!!!

    Import a dump file to your database is simple and easy (in Windows too ...
    Just open an command prompt window and go to your mysql\bin folder:

    e.g., cd c:\mysql\bin

    then type

    mysql db << sqlfile

    where db is the database where you want the dump data and sqlfile is the file where do you have the dump data.

    As an example,

    mysql nuke << c:\nuke\nuke.sql

    where the database is named "nuke" and the file where you have the dump is in "c:\nuke\nuke.sql"... just change the path to file to match your requirements...

    enjoy

  4. #4
    SitePoint Enthusiast dzeja's Avatar
    Join Date
    Mar 2000
    Location
    Your Imagination
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would use PHPMyAdmin to do it. It is very easy with it.
    ALL YOUR BASE ARE BELONG TO US!

  5. #5
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Guys,
    I have it working great now. You guys are amazing how well you help me. Hey I have one more questions on SQL. Im currently using root with a password for nuke to access my database, How do I add another login account account with a new password?

    Thanks again guys,

  6. #6
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Check out the MySQL Administration chapter of my article, Building a Database Driven Web Site Using PHP and MYSQL.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •