Olá pessoal.
Tenho um banco com tabelas originalmente myisam e algumas outras eu
converti para innodb. Estou tentando converter outras tabelas maiores
porém gostaria de fazer um teste primeiro, estava pensando em fazer
uma cópia fiel da base, ctrl+c/v da base em outra máquina para fazer o
teste.
Hi,
if you want to copy from one server to another can't you just use
"mysqldump? This is then restored via the "mysql" command using a pipe
or STDIN redirection. If you can shutdown the database for the
duration of the copy then you can do cold backup of all data files.
Both options wi
lol sorry for send the email in portuguese, I did not realize that the
list were in english (a little mistake, I have many mailing lists).
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm think in a physical copy of the database.
But I have not found
Quoting Yoshio :
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm think in a physical copy of the database.
But I have not found the innodb files. Where are that files?
InnoDB is a bit tricky, without going into details (I couldn't
reliably d
I found the ibdata and logfiles, but outside from my database dir.
so basically I need copy everything in /var/lib/mysql/* ?
2011/5/27 :
>
> Quoting Yoshio :
>
>> I can use mysqldump but its take many hours to complete a restore. I
>> can stop the server, so i'm think in a physical copy of the
Quoting Yoshio :
I found the ibdata and logfiles, but outside from my database dir.
so basically I need copy everything in /var/lib/mysql/* ?
Yeah that's normal, they will be in the top level of your MySQL
datadir. Yep, copy everything. As I said, if you have any MyISAM only
databases t
