I've been looking for a nice way to synchronize MySQL databases in a quick and easy way on the Mac, but so far I haven't found any good options.
Since I'm doing my development locally on both my iMac and my MacBook I'd like to be able to sync the site I'm working on with a click of a button.
There are very nice file syncing tools available (I'm currently using Synk Standard), but as far as MySQL syncing (two-way) goes the only one I've found is Navicat.
While Navicat works great they have for some reason not made it possible to access from the command line in the mac version, which means that I can't run the db sync automatically when I run the file sync.
I've tried UI scripting but it just won't work reliably (it clicks in the wrong places all of the time).
So do you know about any good MySQL syncing tools, that sync in both directions and are scriptable?
I just started using iTunes as my music database. For that reason I started to rip all my CDs. Much to my surprise iTunes doesn't find the metadata (for tagging) for a lot of my CDs. I know the data is on discogs and sometimes even on amazon. Is there a way to automatically retrieve the data from those alternative sources. Just like media monkey does? It is really annoying to manually tag all those CDs.
what causes them to crash? and how do i prevent it? i tried setting up a secondary identity that duplicates itself from the original. But when the Main one crashed it said the secondary one is corrupted too! and now its taking hours to rebuild...
I'm looking for a Mac desktop application that will allow me to edit MySQL databases that are located on a web server. Kind of like PHPMyAdmin, only as a desktop Mac application.
The problem is I can't find a program that backs up this library automatic without copying the entire library... It's obvious in only need to copy the new songs to the network drive, overwrite the changed one's and delete the one's i removed from my original library.
Is there any way to bring up multiple instances of Safari, each one with a completely independent cookie database? I have several Gmail accounts, and I want to simultaneously log in to all of them in different browser windows. However, since Safari manages a central cookie database, I can't log into one of these Gmail accounts without signing out from another. With separate Safari instances that maintain separate cookie databases, I could simultaneously keep multiple Gmail windows open.
I just bought a new Macbook Pro 2.4 and starting fixing it with only fresh installs. I installed the OS X 10.5 (x86_64) pak. It was running fine until now.
The start/stop in the pref.pane don't work and if I do a "mysql start" in the terminal I get:
Quote:
MacBookPro:~ matsaki$ mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I tried to reinstall but it did not help. What's bugging? And what to do?
I downloaded a the newer version directly from mysql and made a install. Now I can't stop mysql from running. I throw away the strat/stop in prefpane too. But as soon as I stop mysql it restart's after 3 seconds??
I am wondering if I have 2 mysql running also. The original in the box and the new one. Now I'm at a stage where I have to solve this problem and I am truly not good with UNIX andMySQL commands to see what's wrong or what to do.
Again I almost don't know anything how to use the terminal.
I have Xcode 4.3.2 downloaded from MacApp store. However, it didn't set my environment for development libraries at all. So I included /Applications/Xcode.app/Contents/Developer/usr/bin/ in PATH so it can find common utilities like make, cc, etc. I have installed mysql-5.5.23-osx10.6-x86_64 from MySQL's DMG archive. That went smooth - I am able to start and stop the server. Get in using mysql command line client interface and execute queries, etc. Perl came preinstalled with 10.7.3 Lion. Version of perl is 5.12.3. I am now trying to install DBD::MySQL driver for interfacing with perl and ran into issues. According to MySQL documentation, I first tried to install this driver using -Â
shell> perl -MCPAN -e shell cpan> force install DBD::mysqlÂ
But this failed with make errors (the error is same as reported further below). Then, after days of googling, I found the original post by etresoft on installing this driver. I followed the steps documented in that post (reproduced below for easy reference). My comments in italics. Download the MySQL Perl driver. Done. My version of DBD happens to be 4.021.Â
Extract the archive with: tar xvf DBD-mysql-4.021.tar Move into the directory: cd DBD-mysql-4.021Â
First, fix the MySQL client library. (credit) For Lion, type:sudo install_name_tool -id /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib Done. No issues.
I am trying to create on my Macbook a mysql account but it doesnt allow it. I suspect it is the same one in the "/etc/passwd" file: _mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false I am curious though why in that same file I dont see my normal login account. Where is the 2nd list of users? Is it a plist file somewhere? Also anyone know of a utility that shows all the users including root and all the other special accounts in one place?
First, let me say that I attempted to install it using Termnial, but I messed up horribly and got very confused. Therefore I partitioned my HD and started over.
I want to use a GUI to avoid scrambling something in Terminal again, as well as it being easier on the eyes. I have downloaded the two DMG's directly from the MySQL site:
mysql-5.0.67-osx10.5-x86.dmg
mysql-gui-tools-5.0-r12-osx10.4-universal.dmg
I installed the GUI no problem, but MySQL is another thing.
Is it as easy as just installing the packages in the dmg, as well as the prefpane? Or do I need to do some Terminal work as well?
My motivation for attempting to install MySQL is so I can have access to Retrosheet files [URL]. These files are baesball statistics that can be imported into mysql. Ultimately, I would like to be able to use the Game Logs (Link) and query them through MySQL.
I had previously downloaded MySQL on my computer. However, I discovered MAMP and want to use it. When I try to "Set to default Apache and MySQL ports" in the preferences form, Apache starts back up but MySQL doesn't and then my web program won't recognize my local server. What can I do to fix this?
I was running on Mac 10.6.8 and I wanted to update to Mac 10.9, which I did. I am not discovering that there have been some issued with Apache2 and my localhost. I don't know what is wrong, but I got it working once again. Â Â
Now I am having a rather large issue with MySQL. That issue being that it's no longer on my computer. mysql is no longer a bash command, and it's not in my /var/lib/ directory, not is it anywhere else I looked. I had a few databases set up, and I don't know if they were deleted somehow or what. I can't connect via Sequel Pro either. Must I completely reinstall MySQL for it to work again, or is some stuff still recoverable? Â
mysqld has a ton of really nice startup options to help me debug my app. However I cannot figure out how to shutdown and restart MySQL from the command line and pass these options to mysqld.Snow Leopard and MySQL 5.1.56 MySQL Community Server. Â
I am attempting to install MySQL on my iMac. I downloaded the DMG packages and instaled them, then the instructions I was following from this [URL]. It told me to install a mysql connector (I am new to all of this so I dont know what a mysql connector is). This did not have a DMG package available, so I downloaded the tar.gz as it was my only option. Following the instructions I opened terminal and entered the following command (as shown in image above): sudo pico /etc/my.cnf. I am concerned about the warning message - this is a work computer and I cannot afford to replace it if something gets screwed up.
I have several folders backed up on an external firewire drive that is not always connected. Is there software or a way within OS X or Automator, etc. to easily synchronize the folder on my PowerBook with the one on the external drive without re-rewriting the entire folder and subfolders?
Macbook Pro running Lion V 10.7.4Â .After a hard drive failure this weekend, I restored frm my most recent backup.Unfortunately this did not include svn, host file changes and some other fairly easy to correct things.The one that has been giving me trouble for the last 8 hours is mysql. I have gone through and removed mysql (multiple times) and did fresh installs. Each time I was getting the error:Â
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)Â
Even after changing my /etc/my.cnf file to point to var/lib/mysql/mysql.sock I would get these errors. Â
Are there multiple locations where mysql points to /tmp/mysql.sock? Â
I am at a loss of what to do. I have uninstalled reeinstalled. Tried many different solutions all to reeive the same error.Â
How can i synchronize my iphone apps to my new mac book air? Actually, i could only manage to synchronize contacts and pictures, but neither the music nor the apps.
I have tried to sinchronize the Contacts in my iMac, but it doesn´t work. I have linked my iMac to iCloud. When I go to iCloud directly through Internet, I can see the "Contacts" I haver in iCloud. I have 6,624 contacts. The list of contactas can be seen in both iCliud and on my Mac. But when I add new contacts in my iMac (today I added 4), it doesn´t synchronize. The new contacts do not appear in the Cloud. How can I establish a good link so synchronization can effectively take place?
I also have a IPhone since 3 years and I want to synchronize the phone with my new macbook.
How can I get now the data from my phone on the macbook? Because if I want to synchronize the phone with my new macbook everything from the phone will be deleted...Â
I have installed Lion on my Mac Book and updated to 10.7.4. / and I bought the new IPhone und the new IPad. >> The synchronization (Mails/Contacts) between IPad and IPhone via iCloud is running very well. But the synchronizsation via iCloud between my Mac and IPad and IPhone for Mails and Contacts is not running. I checked the installation of iCloud on my Mac, it's installed.