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 will
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
Quoting Yoshio geanyos...@gmail.com:
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
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 a.sm...@ukgrid.net:
Quoting Yoshio geanyos...@gmail.com:
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm
Quoting Yoshio geanyos...@gmail.com:
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