List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 8 2000 10:53pm
Subject:RE: Backing up database
View as plain text  
>>>>> "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/
Thread
Backing up databasetoxalot7 Jan
  • Re: Backing up databaseUday Kumar Khatua7 Jan
    • Re: Backing up databasetoxalot7 Jan
      • Re: Backing up databaseperl7 Jan
        • RE: Backing up databaseJohn Zook7 Jan
          • RE: Backing up databasetoxalot7 Jan
            • RE: Backing up databaseJamie Le Tual7 Jan
            • RE: Backing up databasePaul DuBois7 Jan
              • RE: Backing up databasetoxalot8 Jan
                • RE: Backing up databasePaul DuBois8 Jan
                  • RE: Backing up databaseMichael Widenius9 Jan
                • RE: Backing up databaseperl8 Jan
            • Re: Backing up databaseStephen Johnson8 Jan
              • Re: Backing up databaseVivek Khera10 Jan
        • Re: Backing up databasemanos7 Jan
        • Re: Backing up databaseUday Kumar Khatua7 Jan
          • Re: Backing up databasetoxalot8 Jan
    • Re: Backing up databasetoxalot7 Jan
  • Re: Backing up databasemanos7 Jan