Re: sql or import file

2003-03-21 Thread Stefan Hinz
Andrew, > In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql > statement does this have to be a txt file or can it be a .sql file? > Or if it is a .sql can I just rename the file so it is a txt file? The file extension doesn't matter. The .sql files PhpMyAdmin wants i

RE: sql or import file

2003-03-21 Thread Paul Larue
The following should do the trick mysql> LOAD DATA file_name.ext INFILE INTO TABLE table_name Paul -Original Message- From: Andrew [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 3:58 AM To: [EMAIL PROTECTED] Subject: RE: sql or import file Hi Paul Its a backup of phpbb so

sql or import file

2003-03-21 Thread Andrew
In phpMyAdmin 2.3.0 the 'Or Location of the textfile ' instead of running a sql statement does this have to be a txt file or can it be a .sql file? Or if it is a .sql can I just rename the file so it is a txt file? Why is importing a large file inot MySQL so damn difficult. It would be so easy f