Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
If I do a mysqldump of the innodb databse, will I be avail to uploaded into
a myisam
database and will it
for
it!
-Original Message-
From: Néstor rot...@gmail.com
Date: Mon, 14 Sep 2009 07:44:25
To: mysql@lists.mysql.com
Subject: HOW TO Backup a mysql innodb on windows?
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
- michael dykman
On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons tly...@ivenue.com wrote:
On Mon, Sep 14, 2009 at 7:44 AM, Néstor
: Mon, 14 Sep 2009 07:44:25
To: mysql@lists.mysql.com
Subject: HOW TO Backup a mysql innodb on windows?
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool
to
do this?
mysqlhotbackup is a paid tool, is that the only one available
-
From: Néstor rot...@gmail.com
Date: Mon, 14 Sep 2009 07:44:25
To: mysql@lists.mysql.com
Subject: HOW TO Backup a mysql innodb on windows?
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool
On Mon, Sep 14, 2009 at 7:44 AM, Néstor rot...@gmail.com wrote:
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
You can also use the free tool from
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman mdyk...@gmail.com wrote:
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
Very good point. My comment was based on the possibly
A mysqldump will work just fine. By default, that dump is going to
explicitly specify the table type .. you will have to edit it if you
want to import to MyISAM.
- michael dykman
On Mon, Sep 14, 2009 at 10:44 AM, Néstor rot...@gmail.com wrote:
Maybe one of you experts know the answer.
I
On 1/23/07, Alex Arul [EMAIL PROTECTED] wrote:
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are using innodb. If you are using innodb tables only
you can run
://www.nabble.com/Backup%3A-Copy-MYSQL-Directory-or-use-MysqlDump-tf3061490.html#a8522321
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I want to create a backup for my MySQL database every single night.
I am currently running on a linux box. I have a backup drive located as
/backup
Would it be more effecient to use mysqldump tool, or use the unix command
dump or cp
Andrew
--
View this message in context:
http
' command.
Thanks
Visolve DB Team.
- Original Message -
From: altendew [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 23, 2007 6:10 AM
Subject: Backup: Copy MYSQL Directory or use MysqlDump
I want to create a backup for my MySQL database every single night.
I am
@lists.mysql.com
Sent: Tuesday, January 23, 2007 6:10 AM
Subject: Backup: Copy MYSQL Directory or use MysqlDump
I want to create a backup for my MySQL database every single night.
I am currently running on a linux box. I have a backup drive located as
/backup
Would it be more effecient to use
Hi
I have a mySQL database running on linux. Can anyone recommend the best
method to backup this data from a Windows XP machine on a scheduled basis ?
My database server version at the moment is 3.23.
Thanks
Neil
Neil Tompkins
--
MySQL General Mailing List
For list archives:
Neil Tompkins wrote:
I have a mySQL database running on linux. Can anyone recommend the
best method to backup this data from a Windows XP machine on a
scheduled basis ? My database server version at the moment is 3.23.
Generally information about backups you could find at
At the moment I'm using mysql version 3.23. Can you recommend any free
software that can automate the backup process
From: Mladen Adamovic [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: best method to backup this mysql data
Date: Sat, 11 Mar 2006
Subject: best method to backup this mysql data
Hi
I have a mySQL database running on linux. Can anyone recommend the best
method to backup this data from a Windows XP machine on a scheduled
basis ?
My database server version at the moment is 3.23.
Thanks
Neil
Neil Tompkins
--
MySQL
We have a mysql cluster. I know we can make backup in the management server of
the mysql cluster with the command start backup.
But how we can automate it ?
Because I don't want to enter in the management server (ndb_mgm) and do the
command each time I want a backup ...
Thanks !
David
How to install Mysql 4.1, I always failed to do that ? pls help me
and how to backup database in mysql ?
thank you
-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Timotius Alfa [EMAIL PROTECTED] wrote:
How to install Mysql 4.1, I always failed to do that ? pls help me
If you have any problem with installation, describe it more detailed.
and how to backup database in mysql ?
You can use mysqldump, mysqlhotcopy programs, BACKUP TABLE and SELECT
Hi all
I'm new to this part of mysql. I've never done somme kind of backup/dump
with mysql
I read that for myIsam I can Just copy the frm, idx form the database
directory
But
I've to manage hot backup with a database mixed with InnoDB tables and
MyIsam. I searched for a tutorial / a software
you tables in
MySQL. It's easy b/c it works with both major table types. The issue is
that it's much slower then mysqlhotcopy (and presumably InnoDB Hot Backup).
--Ware
alx wrote:
Hi all
I'm new to this part of mysql. I've never done somme kind of backup/dump
with mysql
I read that for myIsam I
There is a script for RH Linux for each day automatic full backup of mysql
databases?
(the results may be like: backup_mmdd.sql, so it can be easily imported)
tx in adv for any help
-
Before posting, please check:
http
PROTECTED]]
Sent: Wednesday, July 10, 2002 5:34 AM
To: [EMAIL PROTECTED]
Subject: script - full backup of mysql databases
There is a script for RH Linux for each day automatic full
backup of mysql databases? (the results may be like:
backup_mmdd.sql, so it can be easily imported
Pada Sun, 7 Jul 2002 17:53:08 +0500
Impex Holidays Maldives / Hasan [EMAIL PROTECTED] menulis :
Hi,
This may be out of topic,but still I'm working on a mysql back up file.
Does any one have a shell script to ftp a file to another location, so that I can
schedule to run this file with cron.
Hi,
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
Jack Daniel's Law of Motion: 'You can't fall off the floor'!
Try using Task Scheduler.
KHC I am using MySql version 4.0.0-alpha in Windows 2000.
KHC Everytime when I want to backup the database,i do it in MS-DOS.
KHC Using this command:
mysqldump --opt mydatabasename mybackup.sql
KHC
Dear Sir/Madam:
I'd like to know how I can have regular backup in
mysql database that is carried out by the system
itself, instead of typing in the backup command in the
DOS mode everytime.
Thanks for your attention looking forwards to your
reply.
Regards,
Polly
If you are on a Windows box, you can create a batch job for it.
If you are on Linux/Unix run a cron job
-Original Message-
From: Che WaiSam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:19 AM
To: [EMAIL PROTECTED]
Subject: Re: About Regular Backup on MySQL
Dear Sir
: 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 MySQL
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
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
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 with:
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
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
: 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 MySQL
36 matches
Mail list logo