Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: how to run an existing sql file

    I want to take some sql commands I have in a txt file and load them via the mysql monitor to populate some tables (rather than type it all again) but the command I have doesn't seem to work ... could someone advise me?
    I'm using :
    C:\mysql>mysql -h hostname -u username -D databasename -p > F:\Examples\chapter09\book_insert.sql
    but can't get it to work.
    If it helps I'm using mysql 3.23.58


  2. #2
    Join Date
    Aug 2004
    You should use "<" sign instead of ">" to post your file content to the mysql console.

Posting Permissions

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