MYSQL :: Updates Invisible - Windows Only (Linux OK)

From Windows To Linux
I've got a production MySQL database running on a Linux server, but do my development on a Windows laptop.

I recently overhauled an existing app and needed to write data conversion routines in order for my existing data to map to some new data layouts.

I'm running the conversion on my laptop, so I don't mess up the existing production data. I will be running some tests in parallel before going live with the new app.

When I run the conversion, Windows sets all the table names to all lower case. So when I load the data to my Linux box, the table names are all wrong.

Is there anyway to force MySQL to maintain it's case on a Windows machine so that I don't have discrepancies from one OS to another?

Windows Or Linux?
I am developing a website using php, MySQL and Apache on my home pc which uses WinXP. I am pretty sure that I will not be able to find a web host who will support Apache on Windows, so I guess I will have to go for one that uses Linux. If I do this, is there a serious difference between the way I need to write the PHP code, or is it just the same.

Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

Used Mysql On Windows Now Im On Linux Need Help!
Ok iv changed over to linux running ubuntu 6.06 after installing mysql i tried create a database i did "CREATE DATABASE forums" and got this:

./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'DATABASE''

so how do i logging as root? on windows i just used the terminal thing but now i dont have that (well to the point where it asks you to login)

Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error.

[MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server

Is it likely that the windows-linux combination is causing a problem here?

Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and
RH9 Linux. the intranet was first set up and running in win98. I have
a mysql database in the win98 . The win98 partition is mounted in
Linux and is accessible. I am duplicating the intranet in Linux. the
HTML pages are accessing from the win98 partition. Is there a way to
use the database as such by the intranet in the Linux.

Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

Windows And Linux Versions
I would like to know what are the main differences between windows and linux versions of this DB system.

I´m using it on linux but i´m planning to migrate to windows...

Is there any performance difference? Is it as solid as linux version? It´s of free use (under GPL) ?

I made a test here in windows and it seems to work well..

How To Copy InnoDB From Linux To Windows
I am trying to copy an InnoDB Database (mysql) from a linux system to a Windows XP machine.. I copied the files under /mysql/data/mydatabase/ files to the same one on my windows machine, and I copied anotehr 3 files from the the /data folder which I read about in mysql.com (indata1, and two log files)...

All the database worked expect for the child tables (that has relation with other tables)..

Did I do anything wrong, or is there another way to transfer the database..

Is MySql Syntax Different On Windows Vs. Linux?
On our team, we're working on a database. One copy is on the PC. The other copy is on Linux. I wanted to send a new table to the Linux guy. I went into MySQL Query Browser, did a "Copy CREATE statement to clipboard", and pasted the SQL code into a new email and sent it to my Linux guy. He tells me that the code fails every time. Here's what It looks like:

Connection Problem !!! Windows To Linux
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.

But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect.

Moving MySQL From Windows To Linux
Is it possible to develop a database on Windows and then copy it to Linux? In Oracle it's not possible to simply copy the database between platforms, I just wondered if MySQL is the same.

Query Behaving Differently In Windows And Linux
I have a query to find the blog entries that are most commented:

SELECT blog.*, COUNT(blogcomment.id) AS cnt FROM blog, blogComment WHERE blog.ID=blogComment.BLOG_ID GROUP BY blogComment.BLOG_ID ORDER BY cnt DESC

The query works fine on my development machine running Windows mysql 5.0.22 but on my Linux server running the same version of mysql (5.0.22) I get the following error:
#1054 - Unknown column 'blogcomment.id' in 'field list'

Any ideas why it works differently on the two servers? Suggestions on a better written query is ofcourse welcome too

Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system.

I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle.

Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!

Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?

Sharing Database Tables Between Windows & Linux
I'm new to MySQL (using v4.1) and have a dual boot machine with Windows and Debian Linux (Etch).

My goal is to share a table named "wordpress" between Linux and Windows by storing it on a FAT32 mount (I realise this limits me to 4GB in total).

From what I can see at the moment, the "wordpress" tables live under /var/lib/mysql/wordpress.

Numerous searches have revealed how to backup data, but I haven't seen any clues on how to permanently reloate a database to another location.

Moving Mysql Database From Linux To Windows
I have to move my mysql 5 database from linux to windwos system. Can this be done by moving files from data folder or do I have to dump the data then import it back to new system?

Mysql Invisible Row
has anyone had anything that works perfectly when you insert, and then on one occasion, it works but the row is invisible?

Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.

I have seen some benchmark details on internet. But still they are not
having concrete facts to support LAMP as a better alternative to WAMP.
Allmost all the search done on google melts down to IIS vs Apache, My
main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly
for PHP/MySQL.

FRM Files In MYSQL Are Invisible
I am using MYSQL 4/ RHL7.2 when i installed mysql all are the types (frm,myi and myd ) are available there. but when i untarred some files downloaded from the infected machine(missing frms there also) our server also affected.

This is in our what i got from our server:

shell# ls -l users.*
-rwxr-xr-x 1 mysql mysql 6908 Jul 16 19:44 users.MYD
-rwxr-xr-x 1 mysql mysql 3072 Jul 16 19:44 users.MYI

shell# ls -l users.frm
-rwxr-xr-x 1 mysql mysql 9312 May 22 18:40 users.frm

when u access this thru php_admin, i can' see any tables showing.

mysql> show tables;
Empty set (0.00 sec)

But actually the tables are present which is shown below.

mysql> select count(*) from users;
+----------+
| count(*) |
+----------+
| 78 |
+----------+
1 row in set (0.00 sec)

CAn anybody come up with a solution for this?

JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25

I receive:
ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause'

But this query DOES work under my linux 5.0.0-alpha!

I can modify the SQL Statement to the following and it works fine:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
RIGHT JOIN building b ON a.sortcode=b.sortcode
WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .

Mysql Linux To Mysql Windows
i have been running mysql on rehl4 and now the powers that be want to move the databases to a central windows 2003 server running the windows version of mysql.

how on earth do i import my dump file in the window version? i am familiar with doing it in linux but i cannot figure out the mysql command line tool that comes with the windows package.

Side Menu Item Invisible Unless MySQL Contains Item
I have a menu attached to a MySQL DB that has various items stored and are called with PHP when a user clicks on the link. (I included the menu code below)

I want to add a menu item that is only visible if there is something stored in the DB.
I bolded the area below as to the part of the menu I want the field. Can someone please show me how to incorporate this in that general area with PHP? I have scoured the Web and Googled but could not find a way to do this. Code:

Updates
How do I look for/download and apply updates to the Windows 2000 server.

Updates
if there's a query that could help me 2 update my table fields as follows.
It needs to 2 tables.

Withing table2 i needs to update the same field twice 2 different records e.g. set name='1', name='2' where id='1' and id='2'.
I've tried it like that but all it does is to update both records with 2.
What i wanted 2 to was to update "name=1 where id=1" then "name=2 where id=2".
Can anyone help me on this?

SQL Updates
This is so weird, I'm writing a little poll thing for my website and I've run into a problem..
$update = 'UPDATE mith_poll SET ans7N = 3 WHERE id = 1';
mysql_query($update);
When I vote on an answer it will go up +1 but when I pick a different answer after the last field has been updated the same field gets updated again, I then have to vote again to make the second choice go up + 1..
Am I making sense?
I'll try a bit harder for those who don't understand..
I select answer A
Answer A gets updated
I select answer B
Answer A gets updated
I select answer B,C,D,E and which ever I picked gets updated
I select answer F and the last answer gets updated

Updates Not Consistent
I got a simple application in C# where I have a text box and the userinsert the serial number then I will check if its status in thedatabase is 'y' then I am able to select it and set a new status as's'. The problem here if I do it 2 for different serial number oneafter another for ex. first I select 00123 and then 00124. First the00123 is set to 's' but then the moment I select 00124 the status of00123 gets back to 'y'. I am using the same set of code for both 00123and 00124. There is no place where I run a query which sets the statusto 'y' and I dont understand why the status of 00123 can become to 'y'when it shows in the first place it has succeffully updated to 's'.Below is my code. I have commented the places what I do exactly.

MySQL Updates
We have a new application that will be using MySQL i haven't used it before so have some time put aside to get the hang.

I downloaded mysql-essential-5.0.45-win32.msi and installed it i have the app up and running ok but i'd like to know how i find out what MySQL patches are available and if they need applying. Is there a live update style facility?

Updates And UDF Statements
I have a particular UDF function called pcd which returns the first 1
or 2 letters of a postcode (postcode area), it works fine in selects
but when i use it in a update the column being updated ends up with
the first column in the table, 10 spaces, then the 2nd column in the
table, instead of whatever the UDF function returns.

Has anybody else experienced similar problems, im losing my faith in
mysql a bit, im trying to use it for serious business applications but
might have to find an alternative. I prefer linux servers to windows,
any advice, like Max DB?

Automatic Updates
I'm not sure if this is possible or not, but is there a way to automatically insert data and delete data in a database at specific times during the day?

Is there a script or something out there that would allow me to do this?

Substrings In Updates
I have a column called full_name that contains name like 'amar ram patel'.
I want to update the same table by breaking the name in 3 different values using space as delimiter and add it to the respective columns viz. name, middle_name and surname.
I guess substring_index function can be used for the same.

Trigger Updates
If a certain table is updated I want all other tables which contain some of its attributes as a foreign key to be updated as it is updated.
However the tables that I want to trigger updates from is ISAM
and the other tables are INNODB.

Table Updates
There is a field in a MyISAM table that gets updated each time a PHP page is reloaded, providing an indicator of continued presence on a web site. There is also an app on the server that watches this field for 'logged in' users and logs them out if the timestamp doesn't update for several minutes. Mostly it works, but sometimes it seems that the value in the database table isn't being updated. I.e. the web page refreshes, but the server-side app continues to get the same timestamp.

I'm pretty new to this environment, so I didn't attempt to layer session logic (transactions) over the top of the basic 'update table' and 'select' commands.
Is there something I can put in the php file, or a configuration option on the database or server that would insure the data is committed to disk? (and, since the docs say that happens when the php script terminates..., is there something else I might not be seeing in this situation?)

Multiple Updates.
UPDATE site_settings SET
value = '$title' WHERE setting_name = 'site_name'
value = '$keywords' WHERE setting_name = 'keywords',
value = '$description' WHERE setting_name = 'description'
How can I perform this in ONE Query?

I Have Way Too Many Inserts/updates In My Forum
when someone posts a thread theres 2 count queries
2 fetch queries
3 insert queries
and 2 update queries

so my question is, is there a way to do a sort of join query for inserts and updates?

also, has anyone got some mysql musts?
i dont see a mysql tips thread
i think there should be one

Optimizing Multiple UPDATEs
Basically what I want to do comes down to this:

UPDATE players
SET ranking = 1
WHERE id = 45;

UPDATE players
SET ranking = 2
WHERE id = 30;

UPDATE players
SET ranking = 3
WHERE id = 8;

UPDATE players
SET ranking = 4
WHERE id = 97;

UPDATE players
SET ranking = 5
WHERE id = 12;
I do have a php array containing each player ID with its (new) ranking. However looping through all the players to update their rankings (as shown above) does not seem like a scalable solution to me.

Finding Out Table Updates Since...
I want to synchronize 2 sets of tables and need to be able to tell wich updates the offline set has had since the last time it sychronized the online table. Then i want to run these queries against the online table so their both in sync again.

Is there a MySQL way to do this or will i have to store the SQL queries ran agains the offline table manualy?

Updates Not Visible To Client
I have a Java application (app A) which "polls" a MySQL database table
for records with a certain column set to 0. It runs continuously,
utilising the same commection repeatedly.

The other day, I had a support call raised, whereby there were clearly
suitable records in the database, but my application was not selecting
them.

I wrote a standalone test app (app B) to read the same table and list
the records with the column=0. Sure enough, this app listed records as
requested.

So, app A retrieved zero records whilst app B retrieved many. Both
apps *are* using the same select statement.

I think it might be something to do with the rules governing when
updates become visible to clients.

The application that writes records to the database is not mine so I
don't know all the details. It's a php webapp that seems pretty simple
and just does plain inserts into the table with no attempt to do
anything non-default wrt locking afaik.

Updates To Multiple Tables
can i insert multiple records into multiple tables using MySQL:

statement.executeUpdate("INSERT INTO members, members2, members3, members4, members5 SET
La_Na='"+lana+"', Fi_Na='"+fina+"', NRIC='"+nric+"', CCode='"+ccode+"'");

is this possible?

Safe-updates From All Clients
This is version 5.0.24a on a Windows based machine.

If safe-updates is specified in the [mysql] section, if using the MySQL command line client, safe-updates does work! However, if using another client, or a web page for example to access the database, safe-updates does not work.

Is it possible to have safe-updates work in all clients, such as through connector/ODBC?

safe-updates in the [mysqld] section does not work (the server will not even start with it there).

So the question is: Is it possible to specify safe-updates somewhere so that it is global to every connection that accesses the database no matter what the source is for that connection?

User Updates On MySQL With PHP
I am trying to do is to have a login form in html or php that when a user enters a user name and password that they are taken to a page where their editable information in a mysql database is displayed for them to change.

Mass Updates To A Table
I've got a web-based form that will allow people to update a database
that is displayed as a table. Let's say that there are several columns
across titled Red, Blue, Green... and several rows titled 01, 02, 03...
In each cell, they can fill in some simple text data.

The only way that I can think of to update the database with this
information is using two imbedded loops in Perl:

pseudocode:
for($color=1;$color<=10;++$color) {
for($number=1;$number<=10;++$number) {
update table xyz set value=$value[$color][$number]
where color=$color and number=$number;

This would mean that it would have to execute 100 update statements.
Perhaps this is no big deal and I shouldn't worry about it, but since
I'm relatively new to sql, I'm guessing that there's probably a more
streamlined method to do this.

BTW - I've seen a lot of people asking questions that were vaguely
similar to mine in this group, and they've been told to go to the php
group, even though I didn't see any php-specific code in their
questions. I don't use php and don't have it installed on my server.

Multi-Table UPDATEs
on my old server I developed an application in MySQL 4+. Now I am trying to run it on a different server that only has MySQL 3.

Previously, I used these queries:

CREATE TEMPORARY TABLE x
SELECT *, 0 AS flag
FROM user
WHERE active = 1
ORDER BY id
LIMIT 0,25

UPDATE x, othertable
SET x.flag=1
WHERE x.id = othertable.userid AND othertable.type = 8

Is there any way to do this same sort of thing - update data in one table based on data in another table in MySQL 3?

Detect And Track Updates
I'm trying a develop a connector (or synchronizer) between MySQL and OpenLDAP(very similar to Metadirectory connector). The connector has to detect any updates made to the mysql database and should replicate that in OpenLDAP. The first part of it, is how to detect changes in MySQL? I thought of the option of using a Timestamp variable as an additional column in my DB table. But it won't work for 'delete' detection. Please let me know how to do that or point me to any source regarding that. Please reply soon as this is a part of my project.

Newbie: Formating Data In Updates
My POS products table is formatted totally different from that of the Online products table. No problem, I've got FileMaker Pro and it is really good at changing and formating data how I want it. I can output the product records for my website one way, the output the records for Froogle in another format.

The problem is that it takes and extremely long time with 70k+ records. My current scenario is outgrowing itself and I need to come up with a better solution. I need to find a quicker solution, possibly one I can automate down the road.

Any advice for resources? Or examples?

Unwanted Updates Follow A Select
I update a field after a very banal query (call it the WANTED update).

After that, this crazy thing happens: if I load a page of statistics to see the newly updated values after the mentioned update query has run, it results updates by 3 numbers rather than increased just by 1.
I am absolutely, psoitively sure the WANTED update increased only by 1: I printed the result all in the page, no weird addition ensued.

If I reload again the statistics (that is, I deliver one more select), it doesn't happen.

Morale, an update, followed by a select, updates (this is not wanted!) the selected fields of more than 2 or 3 digits. If another select follows on the same table, no unwanted updates occurs.

Best Way To Issue Hundreds Of Inserts/updates?
What is the best way to execute several (hundreds of) inserts and updates?
Rather than issuing tons of individual inserts and updates, can I send the
strings to a text file and then have mysql do them all??

IE :
query.txt

insert into table1 (col1,col2) values (1,2);
insert into table1 (col1,col2) values (9,4);
update table1 set col2=0 where col1=9;
insert into table1 (col1,col2) values (5,2);
insert into table1 (col1,col2) values (6,2);
insert into table1 (col1,col2) values (4,2);

Whats the best/fastest way to execute a few hundred of these?
Should I lock the table and then somehow use mysql.exe to run all the
commands in the txt file??

Syncronizing Updates From File To Mysql
Is it possible to upload just the changes made to file since last time
it was imported/updated to the database.

For Eg:

1. File A has String "One"
2. This get uploaded to mysql table
3. File A is updated and now it has
"One"
"Two"
4. Only "Two" gets uploaded to mysql.