Thread: script files

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

    Join Date
    Mar 2000
    Posts
    31
    Rep Power
    15
    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 mysql.com...

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

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    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, 11:39 PM
  2. Website Database Basics With PHP and MySQL
    By guest in forum Development Articles
    Replies: 302
    Last Post: November 12th, 2003, 08:22 PM
  3. using delimited script files in vb.net
    By Pain in forum .Net Development
    Replies: 0
    Last Post: November 3rd, 2003, 05:52 AM
  4. Replies: 5
    Last Post: May 21st, 2003, 12:35 PM
  5. Replies: 1
    Last Post: June 12th, 2001, 05:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo