Where does MySQL store actual data in Snow Leopard? How would I retrieve a deleted database from a Time Machine backup? [more inside]
posted by special-k on Dec 4, 2009 - 5 answers

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

How can I automate the migration of an existing MySQL database to a newer schema? [more inside]
posted by fightorflight on Aug 6, 2009 - 5 answers

Can anyone recommend some software to help me draw database diagrams the way that I want to draw them...? [more inside]
posted by twine42 on May 15, 2009 - 11 answers

Remote DBA services - has anyone used one of these for their business to outsource database administration? Could use some advice or references. [more inside]
posted by spicy_sockpuppet on Apr 22, 2009 - 14 answers

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

How do I merge three tables in mysql with duplicate entries for the primary key? [more inside]
posted by special-k on Feb 2, 2009 - 5 answers

I am thinking of making a simple wine-tracking website. The website would allow users to search for specific types of wine and add them to their "list". Where can I get data for all common wines? [more inside]
posted by jdlugo on Dec 14, 2008 - 3 answers

What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
posted by crapmatic on Dec 10, 2008 - 5 answers

I stumbled on a phpMyAdmin page for a database of personal info along with credit card numbers, hosted by a multinational corporation. I deleted some records. How do I report it without being accused of hacking? [more inside]
posted by anonymous on Dec 3, 2008 - 23 answers

Are there uncommon ways to repair a corrupt MySQL table? I have a MySQL database that is experiencing some serious corruption. Using the standard instructions, I have repaired all of the tables but one. No matter how many ways I try those instructions on the ornery table, in all cases either a) nothing happens or b) the data file is emptied, which is, obviously, not the result I want. [more inside]
posted by Mo Nickels on Nov 15, 2008 - 6 answers

I need distributed database suggestions. [more inside]
posted by edmz on Nov 6, 2008 - 8 answers

I need a front end for an online database of contacts, the easier the better. [more inside]
posted by sleevener on Oct 5, 2008 - 7 answers

Can WordPress and WordPress MU share a database? [more inside]
posted by brundlefly on Sep 5, 2008 - 2 answers

Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted by spakto on Aug 19, 2008 - 6 answers

I usually design sites using either plain html/css or Wordpress for its CMS capabilities. However, one client has just asked if there can be a database on his site, which they can add to and visitors/members of the site can purchase "entities" from. This obviously needs a database with a usable front-end for the client and an ability to connect to a payment gateway to purchase "entities". Can anyone help advise on a PHP/MySQL package to do this? I do not have the skills to build a database from scratch (I plan to learn, but cannot do so in the timescales needed for this potential assignment), and I'm presuming there must be a solution out there...
posted by wibbler on Aug 18, 2008 - 4 answers

What CMS would you recommend for my podcast company? [more inside]
posted by arniec on Jul 1, 2008 - 11 answers

I'm having some trouble recreating a Drupal site on my local machine for testing/sandbox purposes. The mysql databases are the biggest stumbling block at the moment - very basic, beginner advice is probably needed. [more inside]
posted by Banky_Edwards on Jun 27, 2008 - 7 answers

Need recommendations for tools (e.g. Crystal Reports) to build reports from a MySQL database. Should be easy enough for a non-programmer to use. What are the pro's and con's of the tool(s)?
posted by gaharrington on Jun 5, 2008 - 3 answers

I've had what I think is a decent idea for a website. Rather than asking someone to "punch it up" in their "spare time" I'd like to learn to do it myself. I know a bit about html and took a turbo pascal class 11 years ago. Since then it's been all humanities, social science, and law. What do I need to learn and what, in your experience, are the best books/web sites to learn from? [more inside]
posted by the christopher hundreds on May 22, 2008 - 8 answers

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted by prophetsearcher on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted by dnash on May 2, 2008 - 8 answers

What is the best way to work databases like we does with version control (Subversion or CVS) for the source files? I was researching but probably I'm not using the right words or there's some special way to work.
posted by Leech on Mar 12, 2008 - 19 answers

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers

I need to code a form to gather contact information from visitors to my website, and I'm looking for alternatives to mySQL. [more inside]
posted by fvox13 on Feb 18, 2008 - 10 answers

How do I query data from one MySQL table, but I also need to get a single piece of data from a second table too? Should I be doing a JOIN, or a separate query? [more inside]
posted by gramcracker on Jan 7, 2008 - 9 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience? [more inside]
posted by anonymous on Sep 18, 2007 - 6 answers

WordPressFilter: Can I do something like this site with WordPress? [more inside]
posted by SansPoint on Sep 16, 2007 - 8 answers

MYSQL question: I want to develop simple input form for our internal office MYSQL. We need to attach files to our product information. I'm using OO, but it doesn't deal with BLOBs what other software could I use to create forms to our database? [more inside]
posted by Yavsy on Aug 20, 2007 - 6 answers

DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version? [more inside]
posted by tmcw on Aug 20, 2007 - 16 answers

What are the best database-driven Web application development frameworks out there right now? More specifically, please orient me to toolsets you know of that are similar to Ruby on Rails. [more inside]
posted by killdevil on Jul 6, 2007 - 17 answers

MySQL, why won't you replicate properly? [more inside]
posted by ph00dz on May 29, 2007 - 6 answers

An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted by mysterious1der on Mar 1, 2007 - 21 answers

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted by Wild_Eep on Dec 5, 2006 - 10 answers

Mysql5... why won't you accept more connections from a set of IP addresses? [more inside]
posted by ph00dz on Nov 16, 2006 - 12 answers

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

Stupid database question: what are some quick "viewer" applications my customers can use to work with data I'm providing locally in a mySQL database? [more inside]
posted by hodyoaten on Nov 1, 2006 - 10 answers

Are there any free PHP and MySQL based apps for setting up a bootleg trading site? [more inside]
posted by SansPoint on Sep 27, 2006 - 2 answers

How to improve MySQL (5.0.22-max-log, PPC) + InnoDB table performance? [more inside]
posted by Blazecock Pileon on Sep 24, 2006 - 9 answers

How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted by cmyers on Aug 28, 2006 - 8 answers

I work at a small non-profit book publisher, and I need to build a database for our website. [more inside]
posted by mekanic on Aug 9, 2006 - 23 answers

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted by disillusioned on Jul 19, 2006 - 12 answers

MySQL/PHPmyAdmin for a band: How do I easily create a repository of lyrics that can be brought in for multiple albums? [more inside]
posted by Brainy on Jul 17, 2006 - 8 answers

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
posted by Afroblanco on Jun 27, 2006 - 19 answers

I'm working on a website for my band, and I would like to have a section on the main page which lists news items. I don't want to have to edit the html file every time I want to add an update though. I'd like it to run from a database or something, so can I set something up to display the 5 most recent database entries on my website? [more inside]
posted by bajema on May 22, 2006 - 11 answers

How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
posted by mic stand on Apr 19, 2006 - 6 answers