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
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
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
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
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
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
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
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
I am having trouble with URLs 404ing on an Apache/MySQL server for a website using Wordpress, with some custom add-ons to use Wordpress as a CMS.
[more inside]
posted by Scramblejam
on Sep 22, 2008 -
7 answers
I have a mysql table, and i have a csv file. I need to update some(not all) rows in the mySQL DB using the data in the CSV file. Is there an easy way to do it? There are about 2700 rows that need to get updated. 3 of the cols. in the CSV can be used to find the correct rows in the DB
(and yes, I am in fact a n00b)
(everything is on a windows machine)
posted by photodegas
on Sep 9, 2008 -
4 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
Is there a simple PHP/MYSQL commenting system available anywhere on the internets? The Google has failed me.
[more inside]
posted by bjork24
on Aug 15, 2008 -
11 answers
CodeFilter: I am looking for online classes mainly in the area of web programming (PHP, MySQL, AJAX, etc.).
[more inside]
posted by kjl291
on Jul 24, 2008 -
3 answers
I'm a tech for a school district. One of my high schools was hit by lightning. The computer that my faculty uses to clock in every day (a windows 95 machine) died. I need a replacement ASAP.
[more inside]
posted by Davaal
on Jul 21, 2008 -
6 answers
Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)?
[more inside]
posted by joemako
on Jul 7, 2008 -
8 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
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
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
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
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
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
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