337 posts tagged with mysql.
Displaying 151 through 200 of 337. Subscribe:

Podcast CMS needed

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

MySQL Sorting

Can I combine and sort MySQL search results? [more inside]
posted by kirkaracha on Jun 30, 2008 - 4 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

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 vs PostgreSQL?

What's the hive mind's opinion on MySQL vs PostgreSQL? [more inside]
posted by xmutex on May 22, 2008 - 24 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


After working in a mostly LAMP (Linux, Apache, MySQL, PHP) environment the last few years, I need to make a quick switch to WISA (Windows, IIS, MS SQL, ASP). [more inside]
posted by gringoese on May 18, 2008 - 6 answers

Book 'em Danno

Suggest an offline booking system, no wait... Suggest a one-click WAMP solution, no wait... Flash and flat files mebbe? [more inside]
posted by Iteki on May 17, 2008 - 1 answer

Multi-core MySQL fun!

MySQL experts: How to get the optimal performance from a database server with a quad core processor? [more inside]
posted by barc0001 on May 11, 2008 - 14 answers

How can I extract data from Wordpress MySQL files?

Is there any way to restore Wordpress MySQL tables from the Unix directories? I don't have a database backup. If a restore of the tables is impossible, can I at least recover the text of my blog entries? [more inside]
posted by phliar on May 9, 2008 - 6 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

My SQL/PHP shareware programs for tracking projects?

Moving an Excel spreadsheet schedule into MySQL/PHP [more inside]
posted by gov_moonbeam on Apr 28, 2008 - 4 answers

Ordering MySQL queries by comma-separated strings?

I'm trying to run a MySQL query that returns rows in order by a value stored in a string (but it will also include the non-matching strings). This is not as easy as I would hope. Code inside! [more inside]
posted by EduTek on Apr 9, 2008 - 15 answers

How do I setup 2 MySql databases with failover?

How do I setup 2 MySql databases with failover? [more inside]
posted by blacksky on Apr 4, 2008 - 5 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

Export MySQL to Access for free...

What is the easiest (and free) method of exporting a MySQL database and getting it (intact) into Access ? [more inside]
posted by Pogo_Fuzzybutt on Apr 3, 2008 - 3 answers

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 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

Help me price a server

Help me price out a server. I have a 10GB dataset from a company that I want to run SQL queries against. Right now on my MacBook they're taking ~12 hours to complete. Faster hardware is definitely needed! [more inside]
posted by sbutler on Mar 12, 2008 - 17 answers

What is the right combination of joins and select statements to get this information from a mysql database?

MYSQL newbie needs some help with a crazy query! (Joins, foreign keys, and bears "oh my!") [more inside]
posted by lucidreamstate on Feb 25, 2008 - 4 answers

How to return users to the right page?

How can I put a login box on every page of my website? [more inside]
posted by samstarling on Feb 25, 2008 - 5 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

Large Site Network Infrastructure (Hardware) Examples?

Network admin / geek question: I'm in the process of building a small cluster of servers for my quickly growing wallpaper website, but I've never charted those waters before. I found a nice article on TorrentFreak about Mininova's server setup, and found it quite intriguing. My question is, are there any other big-ish sites like Mininova that are open about their hardware infrastructure? Googling around yielded few results. I'd be interested to see the setup for a site like Digg, MeFi, or Flickr. Thanks in advance. [more inside]
posted by hmaugans on Feb 16, 2008 - 5 answers

How is Facebook doing its queries?

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted by bonaldi on Feb 4, 2008 - 27 answers

Constant corruption - and I'm not even talking about the government!

I have a few mysql tables that keep repeatedly getting corrupted - help! [more inside]
posted by twiggy on Jan 25, 2008 - 12 answers

URLs with ampersands (&) screwing up my website database calls.

URLs with ampersands (&) screwing up my website database calls. [more inside]
posted by arrowhead on Jan 23, 2008 - 7 answers


Is there a simple way to convert an XML feed into a MYSQL database? [more inside]
posted by alse on Jan 21, 2008 - 6 answers

Authentication across Windows, Linux, and Mac

How do you use a single authentication system for different kind of servers, systems, and workstations? [more inside]
posted by remi on Jan 11, 2008 - 6 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

WP Blog gone blank, Admin section is fine

WorpressFilter Blog gone blank, Admin section is fine - help ! [more inside]
posted by Baud on Jan 6, 2008 - 8 answers

Installing MediaWiki on XP with an Existing Apache Webserver

MediaWiki install: Apache, MySQL, & PHP already on my machine? [more inside]
posted by jjsonp on Jan 4, 2008 - 5 answers

open source program for rotating signups?

Hi, I would like some recommendations for (preferably open source or inexpensive) web based software that I can implement for my church. Everyone takes turns bringing refreshments, playing songs, etc... and there are waaaaay too many "Who can do it on Sunday the 16th? on Sunday the 26th?" e-mails going around and it gets very confusing to keep track. [more inside]
posted by apark on Dec 12, 2007 - 10 answers

Excel into MySQL..How?!

I've been trying to get a 600 record Excel database into MySQL, and failed at every turn. There must be a way! [more inside]
posted by lemonfridge on Dec 5, 2007 - 15 answers

Tricky SQL for a simple function

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted by arrowhead on Nov 23, 2007 - 14 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

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

Cascading a MySQL SELECT

I'm determined to do this in one query. I sure I can, I KNOW you can. Writing a tooltip retrieval system for a site with multiple versions of the same module. I want to supply a generic tip for each version level that can be overridden for a specific module. Diagrams = word x 10^3 [more inside]
posted by handybitesize on Nov 12, 2007 - 9 answers


How do I dump a heavy-loaded 800MB MySQL table without affecting anything? I have a MySQL database serving data for a business-critical popular website. I need to grab the data from one of the tables, but cannot affect the website's performance in any way. I don't mind if it takes days to do it, as long as it affects absolutely nothing.
posted by lpctstr; on Nov 9, 2007 - 17 answers

Where can I have a huge MySQL database hosted?

Where can I have a huge MySQL database hosted? My current host only allows databases of up to 100Mb in size, but I have one of just over 1Gb - anyone know a web host that will allow such a thing? (I'm in the UK if that matters.) Cheaply, of course!
posted by hatmandu on Nov 2, 2007 - 5 answers

PHP MySQL version of Dell's Idea Storm

I'm after a PHP+MySQL app along the lines of Dell's Idea Storm site. [more inside]
posted by TheDonF on Oct 26, 2007 - 4 answers

How do I send out automated emails from my new website without being marked as a spammer?

I have an idea for yet another hairbrained social networking website (which paradoxically might hit it big :-) ). I've coded most of it up on a linux server using apache, php, mysql at softlayer.com. The hostname is registered at godaddy (which I can change if desirable). What's the minimum I need to do the following (I'd rather work on the website application logic and learn as little as possible about mail server administration for now): [more inside]
posted by realpseudonym on Oct 23, 2007 - 8 answers

Getting from point A to B (the right way)

I've got the skills and knowledge, mostly, but I'd like to get a better workflow with PHP/MySQL development. [more inside]
posted by tmcw on Oct 11, 2007 - 15 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

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

I need dynamic pages without PHP or a database. What are my options?

Without access to PHP, MySQL, or any other fancy server-side stuff I still need to have dynamic pages. What are my options? [more inside]
posted by genial on Sep 12, 2007 - 11 answers

How to go about managing payments in a web app?

PHP/TransactionFilter: Designing a web application where users will have actual monetary accounts. What is the best way to approach this? [more inside]
posted by ReiToei on Sep 10, 2007 - 8 answers

Page: 1 2 3 4 5 6 7