+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: A fun unix/mysql project! Whee-hoo! (/showthread.php?tid=8951)
A fun unix/mysql project! Whee-hoo! - Greg the dogsitter - 04-07-2006
My localhost connection was somehow mucked up, so I decided (foolishly?) to dump all and start over.
Progress is being made, thanks in large part to Google.
Here's the current situation:
- I installed MySQL 4 via the Apple Installer.
- I downloaded a few more things (e.g., myODBC & some dbi stuff) via DarwinPorts. These, in turn, installed their own copies of Perl and MySQL because, basically, I didn't know to tell them not to.
I can now use phpmyadmin at localhost/~user to see some tables.
I can also run a Perl script to a CSV file; there is no error returned.
However, I cannot see the imported. It seems that the data is put into one place, and phpmyadmin is looking in another.
What sort of thing has to be done to that everything points to the same place? After playing around with this for a week, I'm guessing it's got to do with sockets, but I could be totally wrong, here.
Thanks greatly,
GtDS
Re: A fun unix/mysql project! Whee-hoo! - Seacrest - 04-07-2006
First, how many mysql servers are you running?
You can only run one at a time on the same port. If you try to startup another one, it will tell you that the port is already in use.
So, then did you have to create two databases: one via Perl (or the command line) and one in phpmyadmin? If you had to create it twice then you would have two distinct datasets.
Why can't you just use phpmyadmin to export CSV? phpmyadmin is pretty darn powerful, you know.
Also, the exported CSV data is no longer linked to the mysql database at all. Just FYI.
Re: A fun unix/mysql project! Whee-hoo! - N-OS X-tasy! - 04-07-2006
Greg, you need a girlfrie-- hey, wait a minute.
Re: A fun unix/mysql project! Whee-hoo! - mattkime - 04-08-2006
perhaps your perl script just isn't returning any errors?
try importing manually.
...and try to keep track of how many active mysql installs you have. I'm not sure why you're having trouble with this.
Re: A fun unix/mysql project! Whee-hoo! - volcs0 - 04-08-2006
This will make your life easier.
http://yoursql.ludit.it/
Re: A fun unix/mysql project! Whee-hoo! - Greg the dogsitter - 04-09-2006
mattkime Wrote:
-------------------------------------------------------
> perhaps your perl script just isn't returning any
> errors?
>
> try importing manually.
>
> ...and try to keep track of how many active mysql
> installs you have. I'm not sure why you're having
> trouble with this.
A-ha! I can tell you exactly why I'm having trouble!
MySQL5, installed from the binaries ("binaries" - that's the word, right?) over here, comes with a nifty little preference pane. So that lets me skip the whole bit about starting it from the command line.*
An installation from DarwinPorts of some other bit of software included MySQL4 as a dependent. So now I have two different versions of MySQL installed. Are they running? I dunno. Thus far, I'm a GUI sort of guy. Looking through invisible folders and checking configuration files doesn't intimidate me; I just don't have any experience with that sort of thing.
GtDS
*I guess I should just find out how to do that, and then it won't be scary.
Re: A fun unix/mysql project! Whee-hoo! - wowzer - 04-09-2006
in terminal type ps -ax
See if you have more than 1 mysql running.
Also, import with phpmyadmin. It can import csv files. GL