HOW TO Backup a mysql innodb on windows?

--001636e0b756c527de04738ab3a6
Content-Type: text/plain; charset=ISO-8859-1

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 work?


Thanks,

Nestor

--001636e0b756c527de04738ab3a6--

Re: HOW TO Backup a mysql innodb on windows?

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=E9stor wrote:
> Maybe one of you experts know the answer.
>
> I have a Innodb database that I want to back up. =A0 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 in=
to
> a myisam
> database and will it work?
>
>
> Thanks,
>
> Nestor
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: HOW TO Backup a mysql innodb on windows?

On Mon, Sep 14, 2009 at 7:44 AM, N=E9stor wrote:
> Maybe one of you experts know the answer.
>
> I have a Innodb database that I want to back up. =A0 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 Percona which can backup innodb
tables without having to shutdown or read lock the database (but it
does read lock the database while copying *.frm files for Innodb
tables and any MyISAM tables).

http://www.percona.com/docs/wiki/percona-xtrabackup:start

> If I do a mysqldump of the innodb databse, will I be avail to uploaded in=
to
> a myisam
> database and will it work?

Depends. If you use foreign keys in innodb, then you cannot import
that into myisam because myisam does not support foreign keys. If you
do not use foreign keys, it should work.
--=20
Regards... Todd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: HOW TO Backup a mysql innodb on windows?

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 wrote:
> On Mon, Sep 14, 2009 at 7:44 AM, N=E9stor wrote:
>> Maybe one of you experts know the answer.
>>
>> I have a Innodb database that I want to back up. =A0 Is there a free too=
l to
>> do this?
>> mysqlhotbackup is a paid tool, is that the only one available?
>
> You can also use the free tool from Percona which can backup innodb
> tables without having to shutdown or read lock the database (but it
> does read lock the database while copying *.frm files for Innodb
> tables and any MyISAM tables).
>
> http://www.percona.com/docs/wiki/percona-xtrabackup:start
>
>> If I do a mysqldump of the innodb databse, will I be avail to uploaded i=
nto
>> a myisam
>> database and will it work?
>
> Depends. =A0If you use foreign keys in innodb, then you cannot import
> that into myisam because myisam does not support foreign keys. =A0If you
> do not use foreign keys, it should work.
> --
> Regards... =A0 =A0 =A0Todd
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: HOW TO Backup a mysql innodb on windows?

On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman 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. =A0Otherwise, the data
> will load just fine.

Very good point. My comment was based on the possibly erroneous
assumption that if you were using foreign keys, when you switched to
MyISAM you wanted to continue to use foreign keys. Without the op
saying one way or the other, Michael's answer is more correct than
mine.

--=20
Regards... Todd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: HOW TO Backup a mysql innodb on windows?

--001636b2bf56a7a99904738bf10c
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I tried this but when I upload the backup it just does not look the same.

Thanks,

Nestor :-

On Mon, Sep 14, 2009 at 8:04 AM, wrote:

> Use sqlyog its a freeware
> Sent from my BlackBerry=AE on Reliance Mobile, India's No. 1 Network. Go =
for
> it!
>
> -----Original Message-----
> From: N=E9stor
> Date: Mon, 14 Sep 2009 07:44:25
> To:
> 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 t=
o
> 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 in=
to
> a myisam
> database and will it work?
>
>
> Thanks,
>
> Nestor
>
>

--001636b2bf56a7a99904738bf10c--

Re: HOW TO Backup a mysql innodb on windows?

--00504502afbad22ab204738bfc0a
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Sorry, I meant to say that the backup DB does not look the same as the
original DB.
Maybe it has to do with what Todd and Mychael mentioned.

The percona tool does not work on Windows OS. I could not find a windows
executable.

Thanks,

Nestor :-)

On Mon, Sep 14, 2009 at 9:13 AM, N=E9stor wrote:

> I tried this but when I upload the backup it just does not look the same.
>
> Thanks,
>
> Nestor :-
>
>
> On Mon, Sep 14, 2009 at 8:04 AM, wrote:
>
>> Use sqlyog its a freeware
>> Sent from my BlackBerry=AE on Reliance Mobile, India's No. 1 Network. Go=
for
>> it!
>>
>> -----Original Message-----
>> From: N=E9stor
>> Date: Mon, 14 Sep 2009 07:44:25
>> To:
>> 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?
>>
>> If I do a mysqldump of the innodb databse, will I be avail to uploaded
>> into
>> a myisam
>> database and will it work?
>>
>>
>> Thanks,
>>
>> Nestor
>>
>>
>

--00504502afbad22ab204738bfc0a--

Re: HOW TO Backup a mysql innodb on windows?

--001636e0ba03a128fe04738c6878
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I did it again and using sqlyog did work.

I also found out that the tool that comes with mysql admin 1.1 also has
a backup tool that works.

Thanks to all,

Nestor :-)

On Mon, Sep 14, 2009 at 9:16 AM, N=E9stor wrote:

> Sorry, I meant to say that the backup DB does not look the same as the
> original DB.
> Maybe it has to do with what Todd and Mychael mentioned.
>
> The percona tool does not work on Windows OS. I could not find a windows
> executable.
>
> Thanks,
>
> Nestor :-)
>
>
> On Mon, Sep 14, 2009 at 9:13 AM, N=E9stor wrote:
>
>> I tried this but when I upload the backup it just does not look the same=
..
>>
>> Thanks,
>>
>> Nestor :-
>>
>>
>> On Mon, Sep 14, 2009 at 8:04 AM, wrote:
>>
>>> Use sqlyog its a freeware
>>> Sent from my BlackBerry=AE on Reliance Mobile, India's No. 1 Network. G=
o
>>> for it!
>>>
>>> -----Original Message-----
>>> From: N=E9stor
>>> Date: Mon, 14 Sep 2009 07:44:25
>>> To:
>>> 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?
>>>
>>> If I do a mysqldump of the innodb databse, will I be avail to uploaded
>>> into
>>> a myisam
>>> database and will it work?
>>>
>>>
>>> Thanks,
>>>
>>> Nestor
>>>
>>>
>>
>

--001636e0ba03a128fe04738c6878--