Hi Maciej,
When you say copying binary Innodb data.
Can you please elobrate on this.

regards
anandkl


On 3/28/07, Maciej Dobrzanski <reg.mysql@posterus.com> wrote:
>
> On Wed, 28 Mar 2007, Ananda Kumar wrote:
>
> > Hi Maciej,
> >
> > Thanks a lot for this info, so the best may to move tables from one db
> to
> > another db on a different machine is to use mysqldump, right?
> >
>
> Not necessarily, especially if you are moving to a fresh, empty server.
> Each solution has its advantages. For example, copying binary InnoDB data
> files may be much faster if your database is large as export to and import
> from text files may take a very long time. Importing from text files
> however results in optimized data which can be highly fragmented in the
> old server's datafiles, and the import is not affected by any
> (incompatible) file format changes which can happen from time to time
> between two different versions of MySQL. etc.
>
> You have to decide what is good for your data, what you can and can't do.
> I'd say using dump&import method is the simplest and the safest way to
> go.
>
> Maciek
>
>
> > On 3/28/07, Maciej Dobrzanski <reg.mysql@posterus.com> wrote:
> >>
> >> In news:829b199c0703280335p6147599bt9188439964f46d51@ mail.gmail.com,
> >> "Ananda Kumar" <anandkl@gmail.com> wrote:
> >>
> >> > Is it possible for me to move all these files to a new db on a new
> >> > machine. If you can you please let know how it can be done or guide
> >> > to any url, it would be of great help.
> >>
> >> You cannot do this with copying .ibd files alone, but in most cases
> you
> >> can
> >> move to a different server all the InnoDB information (.idb files,
> shared
> >> tablespace(s), log files, database parameters regarding InnoDB log
> files
> >> and
> >> tablespaces (count, sizes, filenames)), with appropriate .frm files.
> This
> >> would of course require the new server not to contain any earlier
> InnoDB
> >> data or it will be lost.
> >>
> >> I don't know if there are any guides covering this particular
> operation.
> >> Perhaps some InnoDB backup&resotre guides will be helpful as this is
> >> virtually what you want to do.
> >>
> >> Maciek
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
> >>
> >>
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
>
>