Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Sep 10, 2010, 03:53 AM   #1
toadster
macrumors newbie
 
Join Date: Sep 2010
mySQL issues

Hi I just recently upgraded to Snow Leopard on my Mac Book.

There was no issues except for mySQL wouldn't Work. Did a quick search for the issue and found the simply solution to upgrade to mySQL 5.1. In my haste I download and installed this without backing up my older DB's in mysql 4.1.

Of course now I have a fully function mySQL 5.1 and my old db's hopefully still in the mysql4.1 folder on my mac book. I have know Idea how to copy or import these into mysql5.1. I have limited experience using the terminal on a MAc but have managed to find the old 4.1 folder in the mySQL folder. Anyone know where to start???
toadster is offline   0 Reply With Quote
Old Sep 10, 2010, 05:23 AM   #2
Cromulent
macrumors 603
 
Cromulent's Avatar
 
Join Date: Oct 2006
Location: The Land of Hope and Glory
Quote:
Originally Posted by toadster View Post
Hi I just recently upgraded to Snow Leopard on my Mac Book.

There was no issues except for mySQL wouldn't Work. Did a quick search for the issue and found the simply solution to upgrade to mySQL 5.1. In my haste I download and installed this without backing up my older DB's in mysql 4.1.

Of course now I have a fully function mySQL 5.1 and my old db's hopefully still in the mysql4.1 folder on my mac book. I have know Idea how to copy or import these into mysql5.1. I have limited experience using the terminal on a MAc but have managed to find the old 4.1 folder in the mySQL folder. Anyone know where to start???
From the MySQL documentation:

Quote:
If you perform a binary (in-place) upgrade without dumping and reloading tables, you cannot upgrade directly from MySQL 4.1 to 5.1. This occurs due to an incompatible change in the MyISAM table index format in MySQL 5.0. Upgrade from MySQL 4.1 to 5.0 and repair all MyISAM tables (see Section 2.12.4, “Rebuilding or Repairing Tables or Indexes”). Then upgrade from MySQL 5.0 to 5.1 and check and repair your tables.
http://dev.mysql.com/doc/refman/5.1/en/upgrading.html
__________________
Neural Advance - Mac OS X, UNIX and Windows Development
Last.fm Profile | Extreme Metal Reviews
MP 4x 2.66Ghz Xeons / 6GB RAM / 640GB + 500GB + 750GB + 1TB HDDs / ATI Radeon 4870 / iPad 3
Cromulent is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Resetting MySQL password and Sudo issues. fraser1980 OS X 5 Oct 3, 2012 12:46 PM
porticus install mySQL is it supposed to take so long? Starhorsepax Mac Basics and Help 1 Nov 10, 2011 02:29 PM
MediaWiki and MySQL issues with mysql.stock Me! Web Design and Development 3 Feb 3, 2009 11:50 AM
MySQL Issue Stridder44 OS X 1 Sep 8, 2007 04:28 PM
PHP and MySQL issues Brother Michael Mac Applications and Mac App Store 10 Sep 29, 2004 09:38 AM


All times are GMT -5. The time now is 08:01 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC