Need an offline sql editing tool

Discussion in 'MySQL' started by victorqd, Jun 26, 2009.

  1. #1
    I have a wrdp1.sql file saved at my pc,and i need to add some tables to this database while some tables are needed to be removed to reduce the size of the database. SO,CAN ANYONE SUGGEST a good offline tool to edit the sql file for this purpose ?
     
    victorqd, Jun 26, 2009 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    Social.Network, Jun 26, 2009 IP
  3. shaibibutt

    shaibibutt Member

    Messages:
    606
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    #3
    if u worked in MYSQL then use XAMPP tool.
    For oracle dabatase use oracle Software.
     
    shaibibutt, Jul 1, 2009 IP
  4. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #4
    Why would you recommend the poster use XAMPP to edit .SQL files? He does NOT need a LAMP stack to edit a TEXT file.
     
    Social.Network, Jul 1, 2009 IP
  5. MOG

    MOG Well-Known Member

    Messages:
    2,219
    Likes Received:
    163
    Best Answers:
    0
    Trophy Points:
    180
    #5
    because it comes with phpmyadmin, which is far easier than using text files.

    I would recommend the same, install XAMPP, thats what I do...
     
    MOG, Jul 1, 2009 IP
  6. shaibibutt

    shaibibutt Member

    Messages:
    606
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    #6
    XAMPP is good coz it comes with PHPMyAdmin n Apache server option. u dont need to install these things individually if u r using XAMPP.
     
    shaibibutt, Jul 1, 2009 IP
  7. shaibibutt

    shaibibutt Member

    Messages:
    606
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    35
    #7
    Yes u r rite MOG... :)
    hey VICTORQD , go for xampp its the best B)
     
    shaibibutt, Jul 1, 2009 IP
  8. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #8
    I am surrounded by ###. Install the COMPLETE stack to edit a .SQL file?

    Did the original poster ask how to setup a *AMP stack on Windows? No.

    Use a text editor such as notepad or install MySQL and the GUI tools.
     
    Social.Network, Jul 1, 2009 IP
  9. victorqd

    victorqd Well-Known Member

    Messages:
    521
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    105
    #9
    Thanks to all for their suggestions.

    As it was first suggested, i decided to go with text editor and the gui tool. But i feared that i can corrupt the data as i am not a pro at dealing these stuffs.

    My hosting support suggested me to use BIGDUMP php script to upload the 40mb .sql database.I tried an i worked !! And i am easy with phpmyadmin interface.

    Also thanks for suggesting the xampp tool,i must see this too sometimes. :)
     
    victorqd, Jul 1, 2009 IP