Hello
Hello
I have troubles with 'BACKUP DATABASE', I thought it was problem of syntax,
but have tried even the samples in
http://dev.mysql.com/doc/refman/6.0/en/backup-database.html and the command
is not recognized
$ mysql --version
mysql Ver 14.14 Distrib 6.0.4-alpha, for pc-linux
Hello.
Among other suggestions think about such way.
If you MyISAM and InnoDB tables are used by different applications or
consistent state between them doesn't play big value, and the size
of MyISAM tables is low enough, you could perform the dump in two steps
listing the tables of the s
ucture.
Our table defintitions are relatively stable so we don't do it every
night. You could put it in the cron job to do it with the backup.
-Original Message-
From: Scott Plumlee [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 12:36 PM
To: mysql@lists.mysql.com
Subject: Re: Ba
>
> -Original Message-
> From: Scott Plumlee [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 17, 2005 10:21 AM
> To: mysql@lists.mysql.com
> Subject: Backup database with MyISAM and InnoDB tables together
>
> I'm not clear on best practice to use on a database
cuted
-Original Message-
From: Scott Plumlee [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 10:21 AM
To: mysql@lists.mysql.com
Subject: Backup database with MyISAM and InnoDB tables together
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB ta
I'm not clear on best practice to use on a database containing both
MyISAM and InnoDB tables. For the MyISAM tables, it seems better to use
mysqldump --opt, thus getting the --lock-tables option, but for the
InnoDB the --single-transaction is preferred. Since they are mutually
exclusive, is t
Thank you Michael for your very thoughtful reply. I know that it takes
time and effort to answer at the level you did.
Michael Stassen Michael.Stassen-at-verizon.net |Lists| wrote:
> You seem to have a fundamental misunderstanding of the TIMESTAMP type.
> No timezone or DST information is stored
Peter Valdemar Mørch wrote:
From the lack of responses I take it that nobody disagrees that the
handling of the timestamp type is fundamentally broken in every version
of MySQL.
Silence does not necessarily indicate assent. You asked a complicated
question (when the U.S. list members were on h
From the lack of responses I take it that nobody disagrees that the
handling of the timestamp type is fundamentally broken in every version
of MySQL.
I'll go ahead and file several bugs, and start changing our code to
avoid the timestamp type altogther. I'm quite surprised!
Peter
Peter Valdema
***
Claim
***
I seem to have discovered that MySQL cannot handle the hour where DST
becomes non-DST reliably (on Oct 31st in CET):
2am 3am
| problem |
| time|
--->---DST>--
I need to move one database with 5 tables to another box. What files I
should copy?
I use MYSQL 3.23.58.
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mikael Fridh wrote:
Martin,
Shut down your 3.23 server.
Make a binary copy of the data.
Install 4.0
Upgrade your privileges with the 4.0 script.
Start 4.0 server.
That's it, right?
Worked for me...
When doing backups I always do a full recursive backup of the entire mysql
data directory. This way
m: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Martín Lahittette" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, October 18, 2003 11:59 PM
Subject: Re: Backup database with foreign keys
At 21:45 + 10/18/03, Martín Lahittette wrote:
>Yes, you are right
At 21:45 + 10/18/03, Martín Lahittette wrote:
Yes, you are right. I am upgrading to MySQL 4.0,
but I can not do it if I do not have a backup of
my current database. If something goes wrong, I
need to be sure that I am able to restore the
database to its current state. Maybe I need two
type
Yes, you are right. I am upgrading to MySQL 4.0, but I can not do it if I do
not have a backup of my current database. If something goes wrong, I need to
be sure that I am able to restore the database to its current state. Maybe I
need two types of backup, one to move my databases to version 4.0
At 16:13 + 10/18/03, MartÌn Lahittette wrote:
Thank you very much Paul, that is exactly what I
need, but FOREIGN_KEY_CHECKS = 0 is a feature of
MySQL/InnoDB-3.23.52 and unfortunatelly my
current version is 3.23.51. I can not upgrade to
version 4.0 if I do not have a reliable backup
of my c
Thank you very much Paul, that is exactly what I need, but
FOREIGN_KEY_CHECKS = 0 is a feature of MySQL/InnoDB-3.23.52 and
unfortunatelly my current version is 3.23.51. I can not upgrade to version
4.0 if I do not have a reliable backup of my current version.
Do you have any other sugestion?
Mar
At 0:15 + 10/18/03, MartÌn Lahittette wrote:
Hi,
I want to backup a MySQL 3.23 database to
upgrade it to MySQL 4.0. My tables are InnoDB
and they have foreign keys. I would like to know
how to backup it, because it seems that neither
mysqldump nor mysqlhotcopy can be easily used.
The resto
Hi,
I want to backup a MySQL 3.23 database to upgrade it to MySQL 4.0. My tables
are InnoDB and they have foreign keys. I would like to know how to backup
it, because it seems that neither mysqldump nor mysqlhotcopy can be easily
used.
The restore script created by mysqldump contains the 'creat
lt;[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 8:14 AM
Subject: regular backup database in mysql
> I am using MySql version 4.0.0-alpha in Windows 2000.
> Everytime when I want to backup the database,i do it in MS-DOS.
> Using this command:
> >mysqldump --opt mydatabasename
ter that let Windows manage your database backups.
Enjoy,
Roberto Ramírez
-Mensaje original-
De: lorenzo.kh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 08 de Abril de 2002 12:15 a.m.
Para: [EMAIL PROTECTED]
Asunto: regular backup database in mysql
I am using MySql version 4.0.0-alpha in
I am using MySql version 4.0.0-alpha in Windows 2000.
Everytime when I want to backup the database,i do it in MS-DOS.
Using this command:
>mysqldump --opt mydatabasename > mybackup.sql
Now,lets say i never shut down my pc and the MySql is running all the time.
How can i do a regular backup (ie.eve
: Re: Backup Database MySQL to a Tape Backup
Quer ter seu próprio endereço na Internet?
Garanta já o seu e ainda ganhe cinco e-mails personalizados.
DomíniosBOL - http://dominios.bol.com.br
mysqldump [options] | tar cvf /dev/nrst0 -
Andre Sartori wrote:
> Howto backup databases My
Andre,
Thursday, February 07, 2002, 1:55:26 PM, you wrote:
AS> Howto backup databases MySQL direct to a Tape Backup.
You can directly copy files whitch contain tables from mysql data dir.
You can also use mysqldump to dump your database and then you can
backup result file to a tape. But I think
Howto backup databases MySQL direct to a Tape Backup.
André Sartori
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Andre,
Thursday, February 07, 2002, 8:57:51 PM, you wrote:
AS> Ok.
AS> My hardware hangup and i installing a new server.
AS> Howto i restore from tape to a new instalation.
If you did backup using mysqldump, you should use mysql client.
If you did direct backup of data files, you should go wit
Andre,
Thursday, February 07, 2002, 8:57:51 PM, you wrote:
AS> Ok.
AS> My hardware hangup and i installing a new server.
AS> Howto i restore from tape to a new instalation.
If you did backup using mysqldump, you should use mysql client.
If you did direct backup of data files, you should go wit
: Re: Backup Database MySQL to a Tape Backup
Quer ter seu próprio endereço na Internet?
Garanta já o seu e ainda ganhe cinco e-mails personalizados.
DomíniosBOL - http://dominios.bol.com.br
mysqldump [options] | tar cvf /dev/nrst0 -
Andre Sartori wrote:
> Howto backup databases My
Andre,
Thursday, February 07, 2002, 1:55:26 PM, you wrote:
AS> Howto backup databases MySQL direct to a Tape Backup.
You can directly copy files whitch contain tables from mysql data dir.
You can also use mysqldump to dump your database and then you can
backup result file to a tape. But I think
Howto backup databases MySQL direct to a Tape Backup.
André Sartori
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
On Tue, Jun 05, 2001 at 05:16:37PM +0800, Alice wrote:
>
> Hi, besides using mysqldump, can i just copy the database in the
> data directory straight away in windows explorer ?? is this a
> correct way to do that ?? thanx
It's probably only "safe" if you do a
FLUSH TABLES WITH READ LOCK;
be
Hi, besides using mysqldump, can i just copy the
database in the data directory straight away in windows explorer
??
is this a correct way to do that ??
thanx
/---\
Confidential and/ or privileged information may be co
Hola alguien habla español. que pueda ayudarme como se hace copia de
seguridad a tablas exageradamente grande.
He consultado el comando backup table tablas, to 'ruta' .
hay otra forma?.
Gracias.
Roger Retamoza
ICQ 102090754
Barranquilla Colombia
--
33 matches
Mail list logo
