[newbie] moving mysql db to new server
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 dragdrop some folders to my new system? thanks for your help :-) julien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [newbie] moving mysql db to new server
2005/9/15, Julien vander Straeten [EMAIL PROTECTED]: 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 dragdrop 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/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [newbie] moving mysql db to new server
Hello. i'm having a backup of the entire drive, but no dump. In what way have you done the backup of the drive? Do you have an archive with files from the corrupted drive or a raw image (snapshot) of the file system? If you have an archive you can just copy the data directory to the new system. However, both old and new systems and versions of MySQL should be compatible. For more details see: http://dev.mysql.com/doc/mysql/en/Moving.html http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html If you have a snapshot, extract the MySQL data directory from the image and do as it was described before. Julien vander Straeten [EMAIL PROTECTED] wrote: 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 dragdrop some folders to my new system? thanks for your help :-) julien -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]