Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Exclamation Unanswered: Running .SQL Files

    I am having problems running a .sql file using mysql.

    I have the mysql prompt open and I am running this command per the mySQL manaul


    mysql> source deletes.sql
    mysql> source .\deletes.sql

    The file is in the c:\apache\mysql\data\dcmpare Directory which is where the dcmpare tables are located.

    what am I doing wrong?

    my .SQL file looks like this

    Delete from system_new;
    Delete from system_Old;

    I keep getting a failed to open file error. Please let me know what I am doing wrong here. Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    FDR India
    Posts
    24
    Hi

    Try putting deletes.sql in the mysql/bin directory (or) give the full path "c:\apache\mysql\data\dcmpare\deletes.sql".

    hth
    theN
    ps: not sure about the double-quotes. Please check the manual.

  3. #3
    Join Date
    Jul 2003
    Posts
    11

    Cool Re: Running .SQL Files

    Forget the MySQL command line. Try a user-friendly GUI based
    client tool like dbWidget. You can download it and use it for free
    for 30 days at http://www.yazoosoft.com

    You can download a free MySQL JDBC Driver at URL
    http://mysql.mirror.anlx.net/downloa...bc-stable.html

Posting Permissions

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