John Miller wrote:
>
> i am new to this, and that's probably the reason i am in the situation i'm
> in.
>
> I need to move a MySQL database from one server to another.
> (users/permissions/ everything!)
> is this possible. both servers are running the same version of linux, and
> are basically idential in every way, if this makes a difference. Is it
> possible to just copy the database files over to the new machine, if so,
> what files need to be copied? or do i have to export/import the data and set
> up the users again? if i have to export and import the data, how do i do
> that?
>
> thanks for any help you can give me.
>
> john
>
Just tar.gz the $MYSQL/data/db_name move it over and
untar.gz it, that's all, uness you have some privilige
issues. In the latter case, update mysql tables
accordingly.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
