1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Rep Power
    Is there a way that I can send all my commands to MySQL in a text file? How do I tell MySQL to go through the text file?

    Thanks! http://www.datera.com
  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 username -ppassword < path/to/text.txt

Similar Threads

  1. Get number of lines
    By gurrutello in forum ASP Programming
    Replies: 11
    Last Post: October 14th, 2003, 12:01 PM
  2. backup data to text file from mysql
    By justanew in forum MySQL Help
    Replies: 1
    Last Post: September 24th, 2003, 03:28 PM
  3. flat xml file to hierarchical using xsl
    By wastlinger in forum XML Programming
    Replies: 0
    Last Post: August 8th, 2003, 04:23 AM
  4. insertin , and " deliminated text file data in mysql
    By martincrumlish in forum PHP Development
    Replies: 0
    Last Post: September 16th, 2002, 08:37 AM
  5. Replies: 3
    Last Post: August 30th, 2001, 01:25 PM

IMN logo majestic logo threadwatch logo seochat tools logo