Help me develop a performance and concurrency testing and improvement plan for an ecommerce site. [more inside]
posted by Kwine on Dec 7, 2009 - 3 answers

I have some wordpress sites hosted at bluehost that I want to keep backed up. Can you help me automate this? Detailed needs inside. [more inside]
posted by stupidsexyFlanders on Dec 5, 2009 - 7 answers

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

PHP/MySQL gurus: Please help me get data out of Wordpress in a really specific fashion. [more inside]
posted by jbickers on Nov 23, 2009 - 4 answers

What interesting statistical information can I dig out of this medical billing data? [more inside]
posted by neilkod on Nov 19, 2009 - 8 answers

How does PHP handle mysql requests (in regard to time and 'forking') [more inside]
posted by twine42 on Oct 16, 2009 - 4 answers

Need help converting a mySQL database with Latin characters to UTF-8 [more inside]
posted by GJSchaller on Oct 9, 2009 - 7 answers

Best practices for storing OracleDB/mysql/ldap/smtp/etc... system passwords for enterprise application integration use? [more inside]
posted by bottlebrushtree on Oct 8, 2009 - 9 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

Webdev filter: What tools can I use to avoid developing a registration/log-in feature from scratch? [more inside]
posted by telegraph on Aug 9, 2009 - 2 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

What is the easiest way to share data from MySql to a web page on Windows [more inside]
posted by kewlio on Aug 4, 2009 - 4 answers

I have 3-5 days (starting tomorrow!) in which I'm off from work, and have really nothing planned. As a developer geek in a crappy economy, I'm looking at looming unemployment and/or the start of a freelance career in the very near future. I want to this time making "something" that I can use in my portfolio to show potential employers/clients. What on earth can I build? [more inside]
posted by cgg on Aug 4, 2009 - 8 answers

Any Cloudy Nights folks on MeFi? I am googling around in getting going with backyard astronomy and Cloudy Nights appears to be (or to have been) a decent resource, but it has been nothing but failed MySQL connections and php pathing errors since I started digging. Any info? Is it dead, Bones? [more inside]
posted by mwhybark on Aug 4, 2009 - 4 answers

I am following a tutorial on how to install WAMPserver and Wordpress on my Windows machine to kickstart my learning of CM systems and PHP. A crucial component won't install and I don't know nuthin' about how to fix the problem. [more inside]
posted by Foam Pants on Jul 21, 2009 - 6 answers

How do I remotely access a mysql database with ssh on windows? [more inside]
posted by Fluffy654 on Jul 7, 2009 - 7 answers

Which forums do the best web programmers hang out at? [more inside]
posted by jackson5 on Jun 26, 2009 - 16 answers

MySQL connection error. [more inside]
posted by sailormouth on Jun 15, 2009 - 12 answers

What programming language should I use for a Digg-like web site? [more inside]
posted by jackson5 on Jun 15, 2009 - 14 answers

I need to move four large Wordpress sites from one host to another, and I'm scared at all the many ways it could go wrong. [more inside]
posted by jbickers on Jun 12, 2009 - 8 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

Building a comment system, and looking for good introduction to managing groups and users with PHP/MySQL, or a prerolled "user management system". [more inside]
posted by isnotchicago on May 1, 2009 - 6 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

Is there a GUI SQL editor that emulates a spreadsheet-style "copy down"? If not, is there a technique I should learn? [more inside]
posted by rokusan on Apr 14, 2009 - 10 answers

Are there any tools to help with deploying LAMP sites to multiple environments? [more inside]
posted by hitopshelf on Apr 13, 2009 - 5 answers

Looking to automate the backup and download of mySQL tables on a cPanel webhost to an external FTP site. [more inside]
posted by GJSchaller on Apr 10, 2009 - 5 answers

How do I keep sneaky website users from accessing files directly? [more inside]
posted by jpoulos on Apr 6, 2009 - 6 answers

Is there a good way to prevent hard coding of insert/update sql statements in PHP? [more inside]
posted by secret.osha on Mar 30, 2009 - 7 answers

Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

What's wrong with this sql query? [more inside]
posted by maniactown on Mar 21, 2009 - 3 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 can I migrate away from pbwiki before they do their "upgrade" in March? [more inside]
posted by dirtypants on Feb 21, 2009 - 7 answers

Can I use the "custom command" function in FireFTP (in the Tools menu) to export a MySQL database from my host server? [more inside]
posted by scribbler on Feb 11, 2009 - 3 answers

SQL puzzle, MySQL in particular. [more inside]
posted by xmutex on Feb 10, 2009 - 15 answers

Inserting a date into MySQL? Is there a to_date() equivalent to convert a string to a datetime? [more inside]
posted by exhilaration on Feb 5, 2009 - 4 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

How do I convert/import a dbf (2.4 gb) to a mysql database? [more inside]
posted by special-k on Jan 26, 2009 - 7 answers

I've made a large mess and need to fix it. It's a "find this" and "add it once more, but above it, in that same field" dealio in one single tables field in mysql. "This" is a different string every time. Not sure this can be done with mysql, so I'm open to all other ideas. [more inside]
posted by dabitch on Jan 21, 2009 - 19 answers

Yet another MySQL join question. [more inside]
posted by Jezztek on Dec 24, 2008 - 11 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

How do I work with a tab-delimited file when one of the fields is full of tabs? [more inside]
posted by epersonae on Dec 3, 2008 - 20 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

I've two wireless connections on the same box. So, how does windows choose which one to use? Sort of related: I've a dotnet client/server application which is IP specific for its database (MYSQL) and two LAN connections on the same server (one for local, one for the internet). How do I force that application or database to use the right one (the local)?
posted by converge on Nov 23, 2008 - 10 answers

MySQL problem [more inside]
posted by Astro Zombie on Nov 20, 2008 - 2 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

A MySQL question. [more inside]
posted by anonymous on Oct 21, 2008 - 11 answers

Zencart + 1and1 mysql database + paypal + error code that my Elance provider is not fixing = angry client. [more inside]
posted by wile e on Oct 15, 2008 - 3 answers