Thread: script files

  1. No Profile Picture
    PHP Programmer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Rep Power
    How do I run sql script files in MySQL? I've done it with interbase, and it is very simple, but I can't find out how to do it with MySQL. And, yes, I've checked

    thanks in advance!
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    mysql -u user -ppassword [databasename] < /path/to/schema.sql

    databasename is required unless the schema file contains a "use databasename;" command.

Similar Threads

  1. Replies: 6
    Last Post: February 1st, 2004, 10:39 PM
  2. Website Database Basics With PHP and MySQL
    By guest in forum Development Articles
    Replies: 302
    Last Post: November 12th, 2003, 07:22 PM
  3. using delimited script files in
    By Pain in forum .Net Development
    Replies: 0
    Last Post: November 3rd, 2003, 04:52 AM
  4. Replies: 5
    Last Post: May 21st, 2003, 11:35 AM
  5. Replies: 1
    Last Post: June 12th, 2001, 04:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo