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
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
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)
[more inside]
posted by darkgroove
on Oct 24, 2011 -
5 answers
[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
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
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 for the ultimate goal of creating a niche community website.
[more inside]
posted by Wossname
on Jul 15, 2010 -
9 answers
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
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 collecting database?
[more inside]
posted by chndrcks
on Mar 16, 2010 -
4 answers
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Sum of data for all months, including months with no rows, in MySQL?
[more inside]
posted by tmcw
on Nov 15, 2007 -
7 answers
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
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
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
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
Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database.
[more inside]
posted by Yavsy
on Feb 6, 2007 -
10 answers
