Anyone here running their own MySQL dB?

[rueben26]

Hello all.

I am attempting to learn MySQL at work, my eventual work is to write some front ends in perl and to have it all run from the web. I have a book about MySQL and Perl for the Web(insert laughter here)*, but I do have two years of perl programming.

Does anyone have any tips or pointers to getting started w/MySQL? Thank you in advance.

* Funny because generally people that claim that they have a book, may not have too much success.

[roninblade]

what os are u running the mysql on?

[rueben26]

At work it is either Solaris or HP-UX. My site is hosted on a variant of BSD.

I wouldn't think it would matter, beside the paths to the different executables.

I have three years of HPUX experience and about two in Perl.

Any tips?

[Strike]

Yeah, the IRC bot I work on runs on a MySQL database, not to mention that my senior software project here for school does as well.

Good site for intro material to MytSQL: http://www.devshed.com/Server_Side/MySQL

Then, the syntax docs on www.mysql.com are all you need once you get fairly familiar with doing simple selects, updates, and whatnot. Of course, any background in DB design is good.

[inkedmn]

i'm in the process of doing some things with mysql and python (going pretty well), and i have a couple pages bookmarked at home with the basics of mysql syntax, i'll post them later.

[iDxMan]

I've been using MySQL at work for some intranet stuff. Yeah, stock example `employee phone list` deal -- and various other apps. All are in PHP, although the data sync scripts (account/client/etc.) are in perl.

Tips? I dunno -- don't write nasty perl? Read lots of docs and try not to use anything too mysql specific.. eg: I believe pg and mysql handle the LIMIT statement differently.

use strict;

:)

[Strike]

I'd say an employee phone list might be more fun to play with using OpenLDAP or something like that, but it'd easily work with MySQL.

[Heywood]

I am running my own SQL server on Messedup.net. It is actually easier than you might think. Basically, on a BSD machine, you go into ports, and make it from there, follow the directions, and its a piece of cake.

It is kind of a feeling of power knowing you have a whole database server to yourself.