Hi, I didn't notice in the other e-mail, but the syntax of mysqlimport says everything.. :-) mysqlimport is like "LOAD DATA INFILE" and imports data to ONE table. To use your UM.txt you may use: # mysql test < UM.txt
For further explanation of mysqlimport: # mysqlimport --help .... Loads tables from text files in various formats. The base name of the text file must be the name of the table that should be used. .... OR http://www.mysql.com/doc/en/mysqlimport.html shell> mysqlimport [options] database textfile1 [textfile2 ...] For each text file named on the command-line, mysqlimport strips any extension from the filename and uses the result to determine which table to import the file's contents into. For example, files named `patient.txt', `patient.text', and `patient' would all be imported into a table named patient. ... On Fri, 2003-01-17 at 13:45, Shripal Shah wrote: > Hi, > > I am using version 3.23.47. > Yes, DROP TABLE COMMAND IS PERFECT. > > See, here I am mentioning my steps: > > 1> mysqldump --opt test patient > UM.txt > > 2> mysqlimport test UM.txt > > THEN IT GIVES ME FOLLOWING ERROR: > > mysqlimport: Error: Table 'test.UM' doesn't exist, when using table: UM > > So, this is my problem. > > Thanks for your immediate reply > > Thanks & Regards, > > Shripal. > > ----- Original Message ----- > From: "Diana Soares" <[EMAIL PROTECTED]> > To: "Shripal Shah" <[EMAIL PROTECTED]> > Sent: Friday, January 17, 2003 6:48 PM > Subject: Re: Problem with mysqlimport > > > > Hi, > > What version of MySQL do you use ? > > Check if the "DROP TABLE" command on file "UM.txt" looks like this: > > DROP TABLE IF EXISTS <table>; > > > > Also, is it a NOTE or mysqlimport really exits ? Does it create any > > table ? > > > > http://www.mysql.com/doc/en/DROP_TABLE.html > > > > > > On Fri, 2003-01-17 at 12:33, Shripal Shah wrote: > > > Dear Sir/Madam, > > > > > > I've one data file which is built with the help of mysqldump. This file > > > contains structure & data of 2 tables of test database. Like this.. > > > > > > mysqldump -C --add-drop-table -e test patient hospital > UM.txt > > > > > > then I am trying to import data using this statement.. > > > > > > mysqlimport test UM.txt > > > > > > It give me error for table not found... > > > > > > Please guide me regarding this matter.. > > > > > > Thanks & Regards, > > > > > > Shripal. > > > -- Diana Soares --------------------------------------------------------------------- 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
