SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot boballoo's Avatar
    Join Date
    Dec 2001
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    The Perfect Job: How do I load the dump file?

    I am new at MySQL. (Just a warning) I would like to set up "The Perfect Job" from melon fire on my web site. The problem is the web host I have only allows one database and I have several applications using it already. I don't think that is a problem if I just use the name of the database I have already. The problem is in step 4 of the installation instructions it says:

    "Create the database tables using the dump file:

    $ mysql -u <username> -p <password> -D <database> < jobs.sql

    What exactly will this do? I am a little afraid to go ahead in case this will wipe out or interfere with the other tables I have in my database. Also how do I do this using the phpMyAdmin app on my web server?
    EditFast
    Any Document --> Any Time!
    Web Site Copy Editing & Proofreading


  2. #2
    Ribbit... Eric.Coleman's Avatar
    Join Date
    Jun 2001
    Location
    In your basement
    Posts
    1,268
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Get phpMyAdmin ( http://phpmyadmin.net ).

    Select your database, and choose SQL tab. Then you can hit browse and select a sql file from your computer to upload and execute.

    All this will do is add there tables/information for the application to your database.

    Eric
    Eric Coleman
    We're consentratin' on fallin' apart
    We were contenders, now throwin' the fight
    I just wanna believe, I just wanna believe in us

  3. #3
    SitePoint Zealot boballoo's Avatar
    Join Date
    Dec 2001
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Eric

    That makes it easy since I have already installed PHPMyAdmin
    EditFast
    Any Document --> Any Time!
    Web Site Copy Editing & Proofreading


  4. #4
    SitePoint Zealot boballoo's Avatar
    Join Date
    Dec 2001
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Success!!

    Thank again!
    EditFast
    Any Document --> Any Time!
    Web Site Copy Editing & Proofreading


  5. #5
    Ribbit... Eric.Coleman's Avatar
    Join Date
    Jun 2001
    Location
    In your basement
    Posts
    1,268
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by boballoo
    Success!!

    Thank again!
    Your very welcome. Glad I could help.
    Eric Coleman
    We're consentratin' on fallin' apart
    We were contenders, now throwin' the fight
    I just wanna believe, I just wanna believe in us


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
  •