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.
dave
> David Orlovich wrote on 10/26/2004:
> This is what I do (assuming your user is 'root'):
>
>
Sent: Monday, October 25, 2004 11:24 AM
To: Perry, Matthew (Fire Marshal's Office)
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] backing up database with mysqldump
MySQLdump is an executable program.
From the command line:
C:\>mysqldump databasename > ./path/to/backup/file.sql (or file.
s Research Hospital.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 2:10 PM
To: Perry, Matthew (Fire Marshal's Office)
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] backing up database with mysqldump
C:\>mysqldump -uadministrator -
n this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message-
From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 1:53 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] backing up database
C:\>mysqldump -uadministrator -p test > test.sql
Enter password: **
"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
10/25/2004 01:53 PM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] backing up database with mysqldump
Subject: Re: [PHP-DB] backing up database with mysqldump
MySQLdump is an executable program.
>From the command line:
C:\>mysqldump databasename > ./path/to/backup/file.sql (or file.txt )
C:\>mysqldump --help
gives all the options
dave
"Perry, Matthew (Fire M
:14 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] backing up database with mysqldump
I have attempted to follow the documentation for mysqldump both on
mysql.com
and previous emails to this list server. Unfortunately none of the advice
has helped me successfully backup my database.
I have attempted to follow the documentation for mysqldump both on mysql.com
and previous emails to this list server. Unfortunately none of the advice
has helped me successfully backup my database. I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a backup
