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

33 posts tagged with mysql and resolved. (View popular tags)
Displaying 1 through 33 of 33. 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

Best tools for rapid web app development with MySQL on Mac OSX?

I desperately need to pull together a web front-end for my MySQL database on Mac OSX 10.9.1. I have two days to do this, and have spent most of the day down a Python rabbit hole. [more inside]
posted by tel3path on Feb 11, 2014 - 18 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

Webapps for MySQL-based charts?

You want to create a web dashboard with some pretty charts based on data in an existing MySQL database. What do you use? [more inside]
posted by odinsdream on Dec 5, 2012 - 10 answers

How to get perl to connect to mysql using DBD:mysql

I'm over my head again trying to run a program for a class and you were a great help last time. I'm trying to connect to mysql from Perl and have installed DBD:mysql on my Mac (OS X 10.5.8). I have no idea what I'm doing. Can you help? [more inside]
posted by sunshine37 on Nov 23, 2012 - 6 answers

Running mysql server on a mac

I'm trying to install and run MySQL Server 5.0 on my Mac (OS X 10.5.8) for a class. I have no idea what I'm doing. Can you help? [more inside]
posted by sunshine37 on Sep 11, 2012 - 9 answers

Wordpress 1.5 Exporting/Upgrading Woes

I have an old WordPress 1.5.2 installation. I'd like to either export the posts to a new domain/fresh install or upgrade the current install. I expected that to be easy, but getting my posts out of my existing blog does not appear to be simple at all. I only care about the posts and titles: I'd be fine with losing existing comments. [more inside]
posted by gd779 on Apr 12, 2012 - 14 answers

php/mysql escaping backslashes

Php question: mysql_real_escape_string is turning '\6' (and I assume any other \(number combination) into a single character '' where it's in my code, but not when the same string is passed through $_POST. Is this a behaviour of magic_quotes (currently on) or something else - and without the ability to change global php settings, what can I do about it? [more inside]
posted by monkey closet on Jan 26, 2012 - 6 answers

What other strategies are there for seeing CPU bottlenecks in a large PHP application?

How can I track down the cause of periodic spikes in CPU usage caused by a plugin-bloated WordPress install on a LAMP server? [more inside]
posted by cowbellemoo on Dec 5, 2011 - 5 answers

Upload/convert MSAccess to MySQL using PHP

What's the best way to upload an Access DB using PHP and read its contents into MySQL?
posted by monkey closet on Sep 22, 2011 - 6 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

Database diagram -> sql

Help me find a program (Windows / preferably free) that draws database diagrams and then creates the relevant SQL... [more inside]
posted by sodium lights the horizon on Jan 26, 2011 - 5 answers

Do MySQL privileges really work like this?

With MySQL 5.0, how can I grant SELECT privileges on everything *except* for one column in one table? [more inside]
posted by chengjih on Nov 22, 2010 - 13 answers

MySQL: How to Selectively Update a Table from a CSV List?

MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
posted by darth_tedious on Nov 18, 2010 - 8 answers

How does this basic mySQL/PHP loop work?

Basic mySQL/PHP question. Help me understand how this simple while loop involving mysqli_fetch_array() works. [more inside]
posted by Ziggy Zaga on Sep 9, 2010 - 10 answers

SQL JOINs are driving me crazy

Help me dig myself out of an SQL hole involving crazy multiple joins. [more inside]
posted by le morte de bea arthur on Sep 1, 2010 - 14 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

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

How to compile WordPress author stats from a database

Where to find WordPress post view stats. [more inside]
posted by thelastenglishmajor on Mar 25, 2010 - 6 answers

Drupal/OpenAtrium Installation Frustration

How do you modify the install.php file for Open Atrium (which is basically Drupal) to run on your site? I can't find either string where you're supposed to enter your site account id/password or the URL. [more inside]
posted by green_flash on Mar 4, 2010 - 3 answers

Turn on, tune in, log out?

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

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

MySQL connection error

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

The restore did more damage than the crash...

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 - 6 answers

Help me with this sql query

What's wrong with this sql query? [more inside]
posted by maniactown on Mar 21, 2009 - 3 answers

Find it and add it once more in mysql field

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

it's full of tabs?

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

Indexing a SQL table for efficient queries

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

Looking for a new webhost

Halp! I need a new host for a wiki. My RPG has a wiki, because we're wordy and five years old and ... well, we're dorks. Our current host is not so good for us anymore for reasons of database size. [more inside]
posted by FritoKAL on May 23, 2008 - 8 answers

MySQL Monster Query Issue

MySQL monster query is timing out. Anything I can do about it? (Long question, possible a cure for insomnia.) [more inside]
posted by maxwelton on Nov 19, 2007 - 16 answers

Help me help users identify themselves properly to mysql

How do I pass this password in the correct form to MySQL? [more inside]
posted by Tuwa on Sep 29, 2007 - 12 answers

name this bug

Why doesn't this code from O'Reilly's PHP and MySQL work for me? [more inside]
posted by Tuwa on Jun 16, 2007 - 16 answers

Contact management web application?

Can anybody recommend a good, free, preferably open source php-mysql contact management web application I can install on my own server?
posted by monju_bosatsu on Jul 25, 2005 - 14 answers

Page: 1