EMAIL PROTECTED]
Sent: Thursday, November 27, 2003 12:26 PM
To: Victoria Reznichenko
Cc: MySQL List
Subject: Re: table backup
The problem is that I wnt to use this remotely on
another server. Is there a SQL command for doing this
(exporting the table with data into a SQL script)?
--- Victoria Reznic
Zenzo <[EMAIL PROTECTED]> wrote:
> The problem is that I wnt to use this remotely on
> another server.
You can use --host option of mysqldump.
> Is there a SQL command for doing this
> (exporting the table with data into a SQL script)?
No.
>
>
> --- Victoria Reznichenko
> <[EMAIL PROTECTED]>
The problem is that I wnt to use this remotely on
another server. Is there a SQL command for doing this
(exporting the table with data into a SQL script)?
--- Victoria Reznichenko
<[EMAIL PROTECTED]> wrote:
> Zenzo <[EMAIL PROTECTED]> wrote:
> > how can I backup the table but not with BACKUP
> TA
Zenzo <[EMAIL PROTECTED]> wrote:
> how can I backup the table but not with BACKUP TABLE
> because it Backups the .frm and another files. I want
> that it backups in SQL with data. How can i do it?
>
Take a look at mysqldump program:
http://www.mysql.com/doc/en/mysqldump.html
--
For tec
how can I backup the table but not with BACKUP TABLE
because it Backups the .frm and another files. I want
that it backups in SQL with data. How can i do it?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Ma
hi,
We can take backup for the subject above by two ways, One way is by
mysqldump ( Which I am using ..)
Now, I the second method
1. Shut down your MySQL database and make sure it shuts
down without errors.
2. Copy all your data files into a safe place.
