Need help with this please ASAP

Discussion in 'MySQL' started by UKmember, Jun 14, 2008.

  1. #1
    Hi,

    I am just installing something and it says

    4. Dump this 'kootali-dump.sql' file into mysql database.

    How do i do that??

    Help much appreciated

    Steve
     
    UKmember, Jun 14, 2008 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    Hey Steve,

    Since you explicitly stated that you are installing ... I am going to make an assumption, but need your help. The .SQL file contains MySQL statements, which I assume are going to create the table and possibly insert records (i.e. data) for the application you are installing.

    Here is where you can help me ... open the .SQL file in notepad or some text editor and send me 10+ lines, second are you installing locally or remotely (hosted web application), and what tool do you use to manage MySQL. For Example, I use MySQL Browser locally and phpMyAdmin for web administration.

    Let me know and I can help you out.

    Social.Network
     
    Social.Network, Jun 15, 2008 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    You can choose any of the MySQL GUI. Most preferable is phpMyAdmin if you are importing database on a remote webhost.
     
    mwasif, Jun 15, 2008 IP
  4. MayurGondaliya

    MayurGondaliya Well-Known Member

    Messages:
    1,233
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    170
    #4
    Does your system have mysql installed? If not use wampserver to install php, mysql and apache server all at once. then use phpmyadmin to execute that sql file.
     
    MayurGondaliya, Jun 15, 2008 IP
  5. centsi

    centsi Active Member

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    56
    #5
    mysql -u USERNAME -p databasename < template.sql
     
    centsi, Jun 17, 2008 IP