Im currently configuring my two mysql servers for replication using Windows Server 2003. I used this link for setting up the servers: http://www.hackosis.com/index.php/2008/06/09/how-to-setup-...
I am trying to upgrade MySQL from 4.1.2 to 5.0.X. This is on a redhat 4 server. I downloaded the packages below. When I go in to the GUI and do a right click > Open with install packages ev...
Hello, it's me again...with a request for an even more refined concat query.
In the original question, you provided an elegant solution to the problem of concating detail records that had i...
Hi,
I have a query where I need to select Items from a table called products. on field "Item_ID" has the primary key for the record and another field "Item_related" has a comma seperated lis...
I am developing an inventory solution. This is the first time I am using MySQL database. I am using version 5.1. I am confused with an appropriate data type for storing item quantity and rate....
How can you move a MySQL database from one system to another without using mysqldump? I have the original MySQL files from a backup and I need to restore them to a different system with the s...
I was wondering if this can be done directly in a MySQL database:
I have a column with canadian postal codes (alphanumeric values) and would want to strip all non alphanumeric characters (s...
I've got a pretty large, complex web application running on one one webserver. This server is getting pretty bogged down and we just setup a second server for failover and load balancing. I h...
Hi there ,
I have a multi users web application , every user have a user name and password to login the system
now I want to to fine out who is the users logged to the system and who is not ...
I have a problem in that I have little to no adminstrative experience of MySQL, however everyone else is on holiday!
Logs seem to indicate that the database shut down unexpectedly, with thi...
I have two tables (users and websites). How do I set up a php mysql code that if the user does not have 26 or more credits in his/her account under table USER, then do not display their websit...
Hi i have a windows 2003 server with mysql installed. i also have a web server.
because of bandwith issues and security issues i want to use my windows server to run the mysql database and us...
Ok im going nuts, i copied and pasted this statement from a working app and just changed the column and var names and now its telling my i have a syntax error.
thanks
ps - some notes:
t...
Hi,
I am experiencing a strange phenomena with MySQL. When I use 'show database info' I see a different row count than when I use select count(*).
I have two database servers with differe...
Dear experts,
I'm a bit stuck with a query - I wish to find the differences between datetime values in different rows of a given column (further limited by the fact I wish to restrict outp...
Hello,
I have root access to a remote Linux server running CentOS with MySQL installed.
I want to populate a database from a text file at the command-line prompt.
This does NOT work:
...
i have a table where each record has a TaskID
Each TaskID row has a ParentTaskID field (in the same table)
The topmost level of Tasks in a given "chain" (of hierarchy) has a ParentTaskID va...
ive tried this in the command line, mysql query browser and in phpmyadmin
i have a windows based setup using latest programs from mysql 5.1, i have successfully been using the databases in ...
MySQL PHP HTML APACHE LINUX
Hello,
QUESTION: How do I retrieve unique value in a field only once?
I have a MySQL database like this:
(1) Company Name (co_name)
(2) Date ...
I am running SQL commands on my web server. It could be MYSQL 5.0 or MSSQL.
I am doing a lot of inserts and updates and am trying to cut the number trips to the server. So i would like to...
Hi all,
im having a problem while taking a backup of my database, till yesterday it was working fine but suddenly it is giving me an error.
my backup command is .
C:\mysql\bin>mysqldump -...
Hi guys!
Lets say i have a table called cars, with fields as follows.
car_id
make
model
year
If I do a:
select * from cars
Is there any way to subtitute the returned results ...
I have events, which users sign up for, and I'm not sure how best to store this information.
I guess I'm looking at something like an events table, with one row per every user who signs up....
Hi,
Is there a way to select data from one database and insert them into another but using the same php page? I want to copy a table from one database to another but doing it with export or...
I would like to run MySql on a Windows XP machine using a USB drive.
It seems to run o.k.
besides performance, is there any other problem with doing this?
steven
