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 its a flat file with the ext .sql I just didn't want to spend the next 8 hours cutting and pasting :) Andrew >-----Original Message----- >From: Paul Larue [mailto:[EMAIL PROTECTED] >Sent: 21 March 2003 23:46 >To: [EMAIL PROTECTED] >Subject: RE: sql or import file > > >Andrew, >Any extension you like will do it. >How do you do the import? Are you importing a MySQL db or data from a flat >file? >Paul > >-----Original Message----- >From: Andrew [mailto:[EMAIL PROTECTED] >Sent: Friday, March 21, 2003 3:41 AM >To: MySQL-Lista >Subject: sql or import file > > >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 >for the backup not to happen as opposed to easily backing up a DB that >cannot be >restored. Its like having a nice pair of shoes you cant wear! > >Andrew > >********************************************************************** >Information in this email is confidential and may be privileged. >It is intended for the addressee only. If you have received it in error, >please notify the sender immediately and delete it from your system. >You should not otherwise copy it, retransmit it or use or disclose its >contents to anyone. >Thank you for your co-operation. >********************************************************************** > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.463 / Virus Database: 262 - Release Date: 17/03/2003 > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
