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 'db
ion; 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 -hhostn
: ROGGER ALEXIS 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:
>mys
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 ||| mailto:[
>- 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' int
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
gt;
Sent: Thursday, November 29, 2001 9:40 AM
Subject: NewBie Question; Backups?
> How do I make a Backup of a MYSQL database ,,,
> It is simple as just copying the files of each table ?
> or exists a command to make backup ( including TEXT Fields ) ?
>
> Thanks
>
> -Origi
How do I make a Backup of a MYSQL database ,,,
It is simple as just copying the files of each table ?
or exists a command to make backup ( including TEXT Fields ) ?
Thanks
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:51 AM
To: