I have a small cluster system that I inherited that is running heartbeat and DRBD for a intranet server. It runs mostly php and mysql with some Ruby scripts. It also runs samba to enable use...
total noob
how do I find the name of my server?
I just installed MySQL 5.1
I have also installed the GUI (MySQL Administrator)
I want to connect from my ASP .NET page.
hello,
how to know the sql request which uses full the CPU and database which is used by this request?
I have make free hosting but some web site use all cpu and I want can see what web si...
I've been having some problems with replication on a master-master-slave setup
lets say there is master1 master2 and slave1 is the slave of master1
master1<->master2
^
slave1
issue is whe...
I am new to joining tables but I have achieved the results I want using the code below, but I am getting some duplicate results that I do not want... For example, some of the linkid's that bot...
Experts,
What are the accepted schemes to mirror a MySQL database?
One way: create two identical DB's and duplicate all inserts and updates to both DB's.
But is there another way, per...
I have a MySql Database with the following fields: First, Last, and DOB. (DOB is a Date Field.)
MySql requires the date to be in the following format: YYYY-MM-DD.
I am wondering if there...
I am using MySQL and PHP on my current project. I am just trying to add a row into my database but keep getting an error could someone let me know what I am doing wrong.
I keep getting this error when using my code:
Query could not be completed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
Evening folks!
I have an interesting question. Is it possible to exclude results of a given type from a MySQL Query?
For example, if I wanted to find all locations for products that did ...
Hi All
I am trying to setup replication on my mysql server. I followed
http://www.howtoforge.com/mysql_database_replication
and added
log-bin = /var/log/mysql/mysql-bin.log
binlog...
I'm trying to join the two statements below. I have tried left joins, subqueries and just can get this query to pull properly as one query. Any assistance would be appreciated
I would like to create a script using PHP or MySql commands to download a database to a .sql file. Then automate it to run nightly.
Please see the code below. There is no error produced but the table does not get updated. Can anyone see why?
it is in a PHP page that processes the results from a form.
Hi,
Because of bad programming some time ago I need to cleanup some MySQL-tables.
I need help on deleting data from one table, based on combined information from this table and another o...
I have a table with different fields. Now I want an sql query to delete the whole record for a particular host name. For example if I have something like this record looks like
| local1 ...
I'm just beginer adn i try to make small programm with vb.net and my sql
first part works fine but secont when i try to choose somthing from combo bax and show in text box
is not working Why?
I have a new Dell E6500 with Vista Business 64 installed. All is well except I cannot configure an instance in MySQL 5.1 64 bit. Doesn't matter which setup I use Simple or Detailed, the wiza...
I have three tables
1) address
2) personalInfo
3) client
Each table has its own PK.
client table contains two FKs that connect address and personalInfo.
For example, I can read f...
Here's a SQL query running on my Linux server under MySQL 5.2 that is VERY slow compared to other queries:
SELECT COUNT(*) FROM OMDaily WHERE actSubP = 1 AND BINARY username NOT IN (SELECT ...
Hello,
I need help creating a MySql command in phpmyadmin to do the following. Assuming I have two databases on the same server setup like so:
Database 1 is named DB1 with a table named TA...
I have float field where the numbers are really a percentage. But it displays as 100, 150 etc. instead of 100%, 150%.
How do i get them to display as percentage? Is there a percentage data ...
Hello,
I am looking for an app that can be used to connect to a mysql database on my host website remotely.
Where i could edit, drop, create tables etc.
Thanks
Current MySQL
-------------------
I am joining a select statement and a subquery with a left outer join. The subquery does a an average on one of the selects columns grouped by name, and I...
I have 3 tables in 1 MySQL database with about 10-15 fields per table. I would like to add a master search on a page, where someone could type in any data from one of the fields from any tabl...
