Tagged Questions
The php tag has no wiki summary.
-1
votes
0answers
20 views
I am kind of familiar with mysql, need a book that goes into a little more detail [closed]
Possible Duplicate:
How can I learn to become a DBA?
my mysql experience is limited to making a classified site, nothing significant , and a few webbots here and there. So I am familiar ...
0
votes
1answer
16 views
What would be the best way to design a table in Mysql that handles read items in an RSS feed reader?
I'm working on an RSS feed reader, it is mostly functionnal. But after some time beta testing it, I noticed that its very slow running some queries on a table that handles all the items that have been ...
0
votes
1answer
42 views
I want to count all the rows for todays / yesterdays date based on a DATETIME - mysql+php
I have database "db2" with table "menjava"
In table menjava have "id", "author" and "date_submitted" field
id - auto_increment
author - int(11)
date_submitted - datetime
I want to count all the ...
1
vote
0answers
18 views
Change a flag in database to show someone is “online” but it's not working [migrated]
Here is a little breakdown of whats going on
The biggest problem I have right now is, in login.php, it is supposed
to change a flag in the database to show a person is online.
...
2
votes
6answers
575 views
importing large SQL file phpmyadmin
I am trying to import this SQL file in phpmyadmin and got this message
#1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right ...
1
vote
1answer
40 views
What is the most effective way to cluster MySQL for my requirements?
Basically I have 3 edge servers and 3 application servers. The edge servers are running nginx and load balance between the application servers. The application servers are running Virtualmin GPL with ...
1
vote
2answers
122 views
Preventing mysql deadlocks in your php application that uses SELECT… LOCK IN SHARE MODE
If I understand SELECT ... LOCK IN SHARE MODE correctly, you can place it into a mysql transaction to select the rows you will be working with during that transaction.
This is done in order to "lock ...
3
votes
1answer
301 views
MySQL 'LOAD DATA INFILE' : Can't replace entry when foreign key exists
Here's a minimal case for my database scheme:
CREATE TABLE `test` (
`id` int(11) NOT NULL,
`name` varchar(22) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT ...
3
votes
3answers
63 views
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted?
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted? For instance, I'm splitting payments and charges to their own tables from a previously unified ...
6
votes
1answer
85 views
Application Settings in Database
In the past I have stored all generic settings and configuration items such as: custom application title, home address, version, debug, etc.. all in a "settings.php" file that I would include into all ...
1
vote
2answers
177 views
MySQL connection doesn't work anymore
I had two MySQL servers running (127.0.0.1:3306 and 127.0.0.1:3307). Now I get this strange error: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet' I can ...
3
votes
4answers
267 views
Why is MySQL caching data on our dynamic PHP site?
We are having an annoyance with our PHP/MySQL site in that it seems to cache data from the database and our PHP pages are showing out of date records. In fact, there are pages that link to URLs that ...
