backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Lentes, Bernd
Hi, i've been already reading the documentation the whole day, but still confused and unsure what to do. We have two databases which are important for our work. So both are stored hourly. Now I recognized that each database has a mixture of MyISAM- and InnoDB-tables. A backup of this mix does

Re: backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Reindl Harald
Am 22.08.2014 um 19:40 schrieb Lentes, Bernd: i've been already reading the documentation the whole day, but still confused and unsure what to do. We have two databases which are important for our work. So both are stored hourly. Now I recognized that each database has a mixture of

Re: backup of databases which have a mix of MyISAM- and InnoDB-tables

2014-08-22 Thread Hartmut Holzgraefe
XTrabackup can handle both InnoDB and MyISAM in a consistent way while minimizing lock time on MyISAM tables ... http://www.percona.com/doc/percona-xtrabackup/2.1/ -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General

Backup of databases.

2001-07-19 Thread Tomas Norre
Hello there. I have a problem.. i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you

Re: Backup of databases.

2001-07-19 Thread Werner Stuerenburg
i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you mysqldump because of the