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
