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

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    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
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    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, 01:01 PM
  2. backup data to text file from mysql
    By justanew in forum MySQL Help
    Replies: 1
    Last Post: September 24th, 2003, 04:28 PM
  3. flat xml file to hierarchical using xsl
    By wastlinger in forum XML Programming
    Replies: 0
    Last Post: August 8th, 2003, 05:23 AM
  4. insertin , and " deliminated text file data in mysql
    By martincrumlish in forum PHP Development
    Replies: 0
    Last Post: September 16th, 2002, 09:37 AM
  5. Replies: 3
    Last Post: August 30th, 2001, 02:25 PM

IMN logo majestic logo threadwatch logo seochat tools logo