mysqldump -uusername -ppassword -hhostname dbname dbname.sql
That will dump the database 'dbname' into the file 'dbname.sql'
Tyler Longren
- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 9:40 AM
Thanks and
How DO I RESTORE IT ???
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:43 AM
To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: Re: NewBie Question; Backups?
mysqldump -uusername -ppassword -hhostname
- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
How do I make a Backup of a MYSQL database ,,,
At 9:42 AM -0600 11/29/01, Tyler Longren wrote:
mysqldump -uusername -ppassword -hhostname dbname dbname.sql
That will dump the database 'dbname' into the file
At 9:51 AM -0600 11/29/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote:
Thanks and
How DO I RESTORE IT ???
IF using at least version 3.23.25, then you can use RESTORE TABLE
(described just after BACKUP TABLE).
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
VASQUEZ MARTINEZ
Subject: Re: NewBie Question; Backups?
- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
How do I make a Backup of a MYSQL database ,,,
At 9:42 AM -0600 11/29/01, Tyler Longren wrote:
mysqldump -uusername -ppassword -hhostname dbname dbname.sql
; Backups?
Thanks and
How DO I RESTORE IT ???
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:43 AM
To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: Re: NewBie Question; Backups?
mysqldump -uusername -ppassword -hhostname
You can restore it by just doing:
$ mysql dbname dbnams.sql
ROGGER ALEXIS VASQUEZ MARTINEZ wrote:
:Thanks and
:How DO I RESTORE IT ???
:
:
:mysqldump -uusername -ppassword -hhostname dbname dbname.sql
:
:That will dump the database 'dbname' into the file