Can anyone recommend some software to help me draw database diagrams the way that I want to draw them...? [more inside]
Building a comment system, and looking for good introduction to managing groups and users with PHP/MySQL, or a prerolled "user management system". [more inside]
Remote DBA services - has anyone used one of these for their business to outsource database administration? Could use some advice or references. [more inside]
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]
Is there a GUI SQL editor that emulates a spreadsheet-style "copy down"? If not, is there a technique I should learn? [more inside]
Are there any tools to help with deploying LAMP sites to multiple environments? [more inside]
Looking to automate the backup and download of mySQL tables on a cPanel webhost to an external FTP site. [more inside]
How do I keep sneaky website users from accessing files directly? [more inside]
Is there a good way to prevent hard coding of insert/update sql statements in PHP? [more inside]
Please help me simplify a complicated mysql update [more inside]
What's wrong with this sql query? [more inside]
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]
How can I migrate away from pbwiki before they do their "upgrade" in March? [more inside]
Can I use the "custom command" function in FireFTP (in the Tools menu) to export a MySQL database from my host server? [more inside]
SQL puzzle, MySQL in particular. [more inside]
Inserting a date into MySQL? Is there a to_date() equivalent to convert a string to a datetime? [more inside]
How do I merge three tables in mysql with duplicate entries for the primary key? [more inside]
How do I convert/import a dbf (2.4 gb) to a mysql database? [more inside]
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]
Yet another MySQL join question. [more inside]
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]
What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
How do I work with a tab-delimited file when one of the fields is full of tabs? [more inside]
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]
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)?
MySQL problem [more inside]
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]
I need distributed database suggestions. [more inside]
A MySQL question. [more inside]
Zencart + 1and1 mysql database + paypal + error code that my Elance provider is not fixing = angry client.
I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
I need a front end for an online database of contacts, the easier the better. [more inside]
How can I migrate PHPBB3 to BBPress? [more inside]
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]
Looking for a new webhost, with PHP and MySQL [more inside]
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)
Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko
). Which do you think is superior to run a print publication database? [more inside]
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...
Is there a simple PHP/MYSQL commenting system available anywhere on the internets? The Google has failed me. [more inside]
How does web scraping work with PHP/mySQL? What best practices are there? [more inside]
CodeFilter: I am looking for online classes mainly in the area of web programming (PHP, MySQL, AJAX, etc.). [more inside]
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]
Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)? [more inside]
What CMS would you recommend for my podcast company? [more inside]
Can I combine and sort MySQL search results? [more inside]
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]
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)?
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]