OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: [newbie] moving mysql db to new server

From: Pooly (pooly7gmail.com)
Date: Thu Sep 15 2005 - 10:26:21 CDT


2005/9/15, Julien vander Straeten <mysql-listgroup-vs.com>:
> hi all,
>
> my machine crashed and i'd would like to restore my mysql databases
> on my new system.
> i'm having a backup of the entire drive, but no dump.
>
> my system is mac os x.3 server.
> is there a way to drag&drop some folders to my new system?

If you use MyISAM Table format, you could do that indeed.
shutdown server
Look for your MySQL Folder and just drag/drop the folders (the ones
containing .frm, .MYD and .MYI files) in this directory (except mysql
and test) into you new destination.
restart server
If it's InnoDB, I have no idea...

>
> thanks for your help :-)
>
> julien
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=pooly7gmail.com
>
>

--
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql