Greetings If you are on Windows then you can try out SQLyog at http://www.webyog.com/sqlyog . It has GUI interface for many ways to import data in MySQL whether CSV, SQL Batch file etc.
Karam --- JeRRy <[EMAIL PROTECTED]> wrote: > Hi, > > I have a text file with all my database information > to > create databases to setting up tables. I have > looked > throught the mysql docs onto how to load these on > from > the mysql prompt. But all I can find is: > > load data infile "filename.txt" into table whatever > > But this is not what I am looking for. :( As the > tables are already defined in the text file and the > appropiate database name to enter them into. > > Is there a way to load these into the database > directly instead of doing each table seperately from > the mysql prompt? (not web admin) > > Thanks in advance. > > Kind Regards, > Jerry > > > > http://mobile.yahoo.com.au - Yahoo! Mobile > - Check & compose your email via SMS on your Telstra > or Vodafone mobile. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
