Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    127.0.0.1
    Posts
    1

    Cool Unanswered: Import *.sql Data

    Hello,

    I'm using MySQL on Windows.

    How do I import a *.sql data into a database? I tryed many ways, but none worked. What's the correct method? In this *.sql file I have many SQL instructions to CREATE some tables and INSERT some data; it has a bit more than 80 MB.

    Thank you, Palatino.
    Last edited by Palatino; 05-01-04 at 00:22.

  2. #2
    Join Date
    Apr 2004
    Location
    Europe->Sweden->Stockholm
    Posts
    71
    Try connecting with mysql and run "source c:\path\to\file.sql" (can't see any reason to why that command shouldn't work on Windows). That will make the mysql client execute the commands in the file.

Posting Permissions

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