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 the innodb files. Where are that files?


2011/5/27 <a.smith@ukgrid.net>:
> 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 be as
> fast as your database is small ;)
>
> Andy.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=geanyoshio@gmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com