Join 3,500 readers in helping fund MetaFilter (Hide)

76 posts tagged with mysql and database. (View popular tags)
Displaying 1 through 50 of 76. Subscribe:

My MySQL Kung Fu is not strong...

I need a script for a MySQL table. The table has multiple fields but one ENDDATE will be populated as a Date/time value. When I am 90 days from that date, I need to update the field STATUS with the value of "email" Work your magic hive! thanks
posted by keep it tight on Jun 24, 2014 - 9 answers

PHPBB Auto User Pruning - how do I undo it?

I run a forum where we discuss open source book scanning technology. Many users visit only occasionally. In a recent update, PHPBB enabled a feature called "Auto User Pruning", and it deleted users who had not logged in for 24 months. Two Thousand Users were deleted. It did not delete their posts, and their account names are still attached to their posts. Please help me restore these users from my database backups or via some other method.
posted by fake on Mar 3, 2014 - 5 answers

How to capture data through Mobile App / web on the GO ...

This is a simple thing to ask, but how do I capture input data through a form on mobile phones / tablets / laptop in a database? More details in... [more inside]
posted by jassi on Aug 2, 2013 - 8 answers

How do I import my Magento database? (memory errors)

I am trying to import a Magento database in phpMyAdmin but keep getting an exhausted memory error. [more inside]
posted by Unhyper on Dec 22, 2012 - 2 answers

SugarCRM or custom?

Is SugarCRM a good contacts database solution for my wife's small business, given her current database and business needs? [more inside]
posted by sleevener on Jul 3, 2012 - 7 answers

Help me choose an upgrade path for my vintage site and get my info to a database?

I'm looking for some guidance in my quest to enter a moderate amount of information into a database, and then choose an appropriate front-end to display that data with a small array of filters and search options. The project is not complicated; I mostly want to avoid wasting time learning things the hard way (in contrast to my usual style). [more inside]
posted by Banky_Edwards on Jun 21, 2012 - 10 answers

Best way to organize a list of tags and their hierarchy in a database of some sort? (More details & examples inside)

Best way to organize a list of tags and their hierarchy in a database of some sort? (More details & examples inside) [more inside]
posted by darkgroove on Oct 24, 2011 - 5 answers

i need a database!

[Python/database filter] I wrote a script in python for a class and I want to challenge myself now to make it attached to a database... [more inside]
posted by handbanana on Aug 26, 2011 - 8 answers

Please help me find the right back end solution

Is PHP/MySQL the best solution for the back end programming of a job listing website? [more inside]
posted by ljshapiro on Aug 9, 2011 - 10 answers

How do I collect dictionary definitions for ~350 words to put into a database?

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

How to make a database-driven website

Building a super-simple database-driven website, from scratch - where to start? [more inside]
posted by Mwongozi on Jul 21, 2010 - 9 answers

Practical web programming books & resources?

Practical web programming books & resources for the ultimate goal of creating a niche community website. [more inside]
posted by Wossname on Jul 15, 2010 - 9 answers

How do I go about making a database app for the iPhone?

What is the best way to go about creating a simple iPhone database access application? I'm looking to create an application which, although it could be very easily done in a web-based manner through the combination of php and mysql, I'd like the data to all be stored locally on the iPhone, in the app itself. [more inside]
posted by Biru on May 16, 2010 - 6 answers

Collabtive Installation Error

Why is my installation of Collabtive 0.6.2 not connecting to the MySQL databases on my web server? I've uploaded the software and set up a MySQL database, but when I run the install module I keep getting an "Error: Tables could not be created" message. [more inside]
posted by gov_moonbeam on Mar 19, 2010 - 3 answers

How should I handle types, varieties and errors in my coin DB?

How should I handle types, varieties and errors in my coin collecting database? [more inside]
posted by chndrcks on Mar 16, 2010 - 4 answers

Giant but simple database - how to build

What is best method to create a non-techy local interface for a 40M+ record database that I'd like to host on my web server? I'd like to regularly import new data, crunch it, and export specific CSV reports (which will be much smaller than 40M rows). [more inside]
posted by mtstover on Feb 5, 2010 - 2 answers

MySQL and PHP suggestions for beginner?

I am looking for suggestions for inexpensive online or real life courses, books, or web sites that will help a friend learn MySQL and PHP. [more inside]
posted by parrot_person on Jan 18, 2010 - 3 answers

Help me recover a deleted MySQL database on osx

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

Serious help needed with Excel

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

Automatic MySQL migration

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

Database Schema design tool

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

Advice On Outsourcing Database Management

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 Question

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

Upsize Access database?

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

Merging tables in mysql

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 fill a database with all commonly available wines?

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

How do I produce an inventory of my data in MySQL?

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 blow the whistle without getting involved?

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

Serious MySQL table repair help

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

Distributed DBMS

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

Online collaborative database front end

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 play nice together?

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

Database suggestions

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

PHP/MySQL Database solution for newbie?!

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

Podcast CMS needed

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

Help me copy a Drupal install for local sandbox testing

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

Recommendation for reporting tools for MySQL database

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

Teach me where to fish...

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

PerHaPs SeQuentiaLly?

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

SQL sorting when sort field is null

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

Is there a MySQL version control system or something?

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

How to count the number of times a string appears in a database field.

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

How do I collect email addresses?

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

MySQL Query from 2 Tables?

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

All months, now.

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

Does taking on mysql after 10 years of Oracle make sense?

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

Bootleg Management with WordPress?

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

MYSQL form woes

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

I just want a good time...

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

Other frameworks akin to Ruby on Rails?

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

Page: 1 2