[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: moving database from one server to another
From:       nkolb () htl ! de
Date:       1999-05-15 17:46:54
[Download RAW message or body]


Try the following commandline in a shell

mysqldump --host=<old-server> <database> | mysql --host=<new-server> <database>

If you do so with your mysql-database you will get exactly the same permissoins.
(Remeber to create all databases  :)


Norbert



> 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?
> 


+------------------------------------------
| Kolb Norbert
| Systemadministration HTL Multimedi@
| 
| http://jester.htl.de                            \|/ ____ \|/
|                                                 "@'/ ,. \`@"
| send any critics to /dev/null                   /_| \__/ |_\
| Plees doont mind se spelink misstakss              \__U_/
+-------------------------------------------

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread3409@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]