Irish SEO,  Marketing & Webmaster Discussion

 

Installing MySQL on Mac?

This is a discussion on Installing MySQL on Mac? within the Coding Help forums, part of the Webmaster Help category; I just bought a PHP book from Sitepoint which I plan to use to delve into the wonderful world of ...


Go Back   Irish SEO, Marketing & Webmaster Discussion > Webmaster Help > Coding Help

Register Forum Rules FAQDonate Members List Calendar Search Today's Posts Mark Forums Read


Notices

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 25-01-2007, 11:55 AM
ButtermilkJack's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Location: Dublin, Ireland
Posts: 267
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
ButtermilkJack will become famous soon enough
Default Installing MySQL on Mac?

I just bought a PHP book from Sitepoint which I plan to use to delve into the wonderful world of PHP. I have a MacBook laptop, and as OS X automatically has PHP installed, the book suggests I install MySQL as well.

Are there any advantages/disadvantages to doing this. Would this mean I can test my sites/work locally on my laptop without having to upload everything to my web host each time to test it?
__________________
Print & Web Design
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 25-01-2007, 01:16 PM
Arch-Stanton's Avatar
Member
Recent Blog:
[CaRP] XML error: > required at line 102
 
Join Date: Jan 2006
Posts: 103
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Arch-Stanton will become famous soon enough
Default

Quote:
Originally Posted by ButtermilkJack View Post
Would this mean I can test my sites/work locally on my laptop without having to upload everything to my web host each time to test it?
You hit the nail on the head, that's exactly it. It really speeds up your testing


.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 25-01-2007, 01:37 PM
ButtermilkJack's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Location: Dublin, Ireland
Posts: 267
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
ButtermilkJack will become famous soon enough
Default

Excellent, thanks. I'll give it bash so.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 25-01-2007, 02:33 PM
Frontpage User
 
Join Date: Jan 2007
Location: Cavan
Posts: 15
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Mirror will become famous soon enough
Default

Well yes and no, it's irrelevant if you aren't going to be using databases obviously.

But that's primarily the use of Php and as such I recommend you do as the book suggests. I develop in php/mysql and use the same setup, saves so much time.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 25-01-2007, 08:54 PM
blacknight's Avatar
Web Slave
Recent Blog:
 
Join Date: Jan 2006
Location: Ireland
Posts: 6,578
blacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to behold
Send a message via ICQ to blacknight Send a message via AIM to blacknight Send a message via MSN to blacknight
Default

The one thing you will need to be aware of, however, is the versions of MySQL and the php extensions.

In your local environment you will have 100% control, but on a shared (or even dedicated server) you will not have the same level of control all the time.

For example, if you were using RedHat Enterprise (or a clone, such as Centos) you may find that the cutting edge versions of MySQL 4.* aren't readily / available / supported, so you may need to compromise
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 25-01-2007, 09:36 PM
Arch-Stanton's Avatar
Member
Recent Blog:
[CaRP] XML error: > required at line 102
 
Join Date: Jan 2006
Posts: 103
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
Arch-Stanton will become famous soon enough
Default

Excellent Point ...

Sometimes problems pop up when you backup a database using phpmyadmin that was hosted on a windows server and restore it on a linux server using a different version of phpmyadmin.

.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 25-01-2007, 09:46 PM
blacknight's Avatar
Web Slave
Recent Blog:
 
Join Date: Jan 2006
Location: Ireland
Posts: 6,578
blacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to beholdblacknight is a splendid one to behold
Send a message via ICQ to blacknight Send a message via AIM to blacknight Send a message via MSN to blacknight
Default

We've had all sorts of oddities with encodings as well.. No idea what was going on - I just hear my technical support team sobbing
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
installing, mac, mysql

Thread Tools
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads

Thread Thread Starter Forum Replies Last Post
I'm thinking of buying a MAC Cormac Webmaster Discussion 9 24-01-2007 12:46 PM
MySQL Optimisation? blacknight Server / Technical Administration Tips and Queries 5 15-01-2007 05:17 PM
CSV to MySQL Conversion Tools? blacknight Coding Help 7 04-01-2007 11:00 AM
MySql gurus louie Coding Help 5 16-11-2006 11:00 PM
What MySQL front end GUI do you use (windows) louie Webmaster Discussion 3 02-10-2006 01:06 PM


Sponsored links

Paid On Results


All times are GMT +1. The time now is 08:50 PM.


Powered by: vBulletin Version 3.7.3, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
Hosted in Ireland by Blacknight - Test your ISP |Irish Hosting Directory| Armchair.ie|Logo by Eden Web Design|Avatars by Afterglow |Latest Blog Entries | VPS HostingAd Management by RedTyger

Search Engine Friendly URLs by vBSEO 3.2.0