List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 14 1999 10:54pm
Subject:Re: moving database from one server to another
View as plain text  
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)
Thread
moving database from one server to anotherJohn Miller15 May
  • Re: moving database from one server to anotherSasha Pachev15 May
  • RE: moving database from one server to anothernkolb15 May
Re: moving database from one server to anotherChristopher R. Jones16 May
  • Re: moving database from one server to anotherSasha Pachev16 May
    • Re: moving database from one server to anotherPaul DuBois16 May