1. This Board Rocks has been moved to a new domain: CarolinaPanthersForum.com

    All member accounts remain the same.

    Most of the content is here, as well. Except that the Preps Forum has been split off to its own board at: http://www.prepsforum.com

    Welcome to the new Carolina Panthers Forum!

    Dismiss Notice

MySQL help

Discussion in 'Technology Forum' started by Savio, Oct 31, 2003.

  1. Oct 31, 2003 at 7:56 AM #1
    Savio

    Savio Freelance Pimp

    Age:
    46
    Posts:
    8,221
    Likes Received:
    0
    Joined:
    Jan 7, 2003
    Location:
    Redondo Beach
    Is there a program out there that will convert a regular .sql text file into tables of usuable form?

    I have a .sql written in word pad that I want to convert.

    Any ideas?
     
  2. Oct 31, 2003 at 9:27 AM #2
    Bootay

    Bootay Poppycock

    Age:
    55
    Posts:
    2,246
    Likes Received:
    0
    Joined:
    Jan 9, 2003
    Location:
    Rangoon
    Use SQL Server.
     
  3. Oct 31, 2003 at 4:31 PM #3
    Toll Booth Willie

    Toll Booth Willie Welcome to Wusta!

    Age:
    48
    Posts:
    3,441
    Likes Received:
    0
    Joined:
    Jan 8, 2003
    Location:
    Des Moines, IA
     
  4. Nov 1, 2003 at 9:02 PM #4
    Savio

    Savio Freelance Pimp

    Age:
    46
    Posts:
    8,221
    Likes Received:
    0
    Joined:
    Jan 7, 2003
    Location:
    Redondo Beach
    phpMyAdmin is a great open source software :cool:
     
  5. Nov 2, 2003 at 5:05 AM #5
    Toll Booth Willie

    Toll Booth Willie Welcome to Wusta!

    Age:
    48
    Posts:
    3,441
    Likes Received:
    0
    Joined:
    Jan 8, 2003
    Location:
    Des Moines, IA
    is that a snap in for MySQL or something? And don't say the O-word. It's dirty.
     
  6. Nov 6, 2003 at 9:51 PM #6
    Meow

    Meow Who me?

    Posts:
    1,231
    Likes Received:
    0
    Joined:
    Jan 8, 2003
    What's in the .sql file?

    If it's create table statements then you can copy and past them into the console window of my sql and create the tables.

    If it's the data from tables then assuming that you have column information you would have to parse the text files and dynamically build your own create table statements.

    Of course if you have mySQL ODBC drivers you could import the text files into access. Then build your table structure in my SQL and transfer the data from Access to my SQL. Might have to play with it a bit and MySql doesn't have the best ODBC drivers yet.
     
  7. Nov 11, 2003 at 6:45 PM #7
    Savio

    Savio Freelance Pimp

    Age:
    46
    Posts:
    8,221
    Likes Received:
    0
    Joined:
    Jan 7, 2003
    Location:
    Redondo Beach

    yeah...I figured it out but phpMyAdmin is a great tool for this. I found that SQL server is too...
     

Share This Page