Don't you have to specify the databases on the command line when using the 
mysql client to load the data as in the second example?  I think you have 
to have also created them on the backup server.


> David Orlovich wrote on 10/26/2004:
> This is what I do (assuming your user is 'root'):
> /path-to-/mysqldump -uroot -pYOURPASSWORD --opt --all-databases > 
> backup.sql
> Alternatively you can pipe it into another database like so:

> /path-to-/mysqldump -uroot -pYOURPASSWORD --opt --all-databases | 
> /path-to-/mysql -hIPADDRESS -uroot -pYOURPASSWORD

> Cheers, David Orlovich

>On 26/10/2004, at 7:53 AM, Perry, Matthew (Fire Marshal's Office) wrote:
>> How do I provide a password?
>> I have been trying -p password[mypass] mysqldump sampledb >
>> ./backup/file.txt
>> -Matt

Reply via email to