>>>>> "Paul" == Paul DuBois <paul@stripped> writes:
Paul> At 11:48 PM -0500 2000-01-07, toxalot@stripped wrote:
>> >>>> mysqladmin -uusername -ppassword database < foo.db
>>>>>>
>>>>> This will recreate and populate the tables and data that were
> dumped to
>>>> >> said 'foo.db' (example db name)
>>>
>>>
>>> Correct, except that it's mysql, not mysqladmin that will do this.
>>>
>>> --
>>> Paul DuBois, paul@stripped
>>
>>
>> Then what is mysqlimport for?
Paul> Reading in raw data files. mysqlimport isn't the opposite of mysqldump,
Paul> though you might think so from the program names.
Paul> mysqlimport is a command line interface to the LOAD DATA statement.
Almost mysqlimport is the opposite of 'mysqldump --tab'
(as mysqldump --tab uses SELECT INTO OUTFILE)
Yours,
Monty
*************** Warning commercial signature follows **********
If you like TCX's concept of a 'mostly free' database and free
advice, you should at least CONSIDER supporting us, so that we can
afford to continue this service. http://www.mysql.com/
