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

Similar Threads
thread Thread Starter Forum Replies Last Post
php mysql = NSString IDMah iPhone/iPad Programming 9 Dec 20, 2013 01:35 PM
PHP, MySQL help please please please Stocktrader Web Design and Development 7 Jun 5, 2013 01:29 PM
MySQL saberahul Mac Programming 1 Mar 17, 2013 11:47 PM
MySQL question Tholian Mac OS X Server, Xserve, and Networking 1 Nov 13, 2012 07:03 PM

Forum Jump

All times are GMT -5. The time now is 11:03 PM.

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

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