Updates Invisible - Windows Only (Linux OK)
I have one Java app writing records to a database (App A) and another,
a Java web application running under Tomcat, displaying the records.
Call this App B.
When I first log into App B and get a connection, all records in the
database at that point get displayed OK.
But after that, any new records inserted by App A do not get displayed
when I refresh (running the query again).
If I log out of App B and log in again, getting a new conection, I see
all the new records.
This behaviour only occurs if I'm running on Windows. If I run the
database on my Linux box with the same application code, new records
inserted by App B are immediately visible to App B with no need to
close the connection and open a new one.
View Complete Forum Thread with Replies
Related Forum Messages:
Windows Vs Linux
We currently run our MySQL on linux. Could someone advise me on the watch outs on moving MySQL to windows and also if there is any performance loss as a result?
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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:
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
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.
View Replies !
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!
View Replies !
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
View Replies !
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?
View Replies !
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.
View Replies !
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 .
View Replies !
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.
View Replies !
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:
View Replies !
Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine. These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet. What I've Tried So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand. Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN. The VPN Dilemma I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server? Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Replies !
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?
View Replies !
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
View Replies !
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?
View Replies !
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.
View Replies !
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?)
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
Conditional Row Updates
I have a table that contains multiple rows per user. Based on user interaction with my site I want the table to be selectively updated for that user. I have built a query using CASE to make the data updates I want, but then I realized that if I am updating like this: Quote: ...SET newvalue = CASE rowid WHEN 1 THEN 3.5 WHEN 2 THEN 3.5 ELSE newvalue END My concern with doing this, however is that the ELSE statement which essentially causes the field to be left alone will cause a performance problem. What I would like to do is restrict the update so that it only works with rows that are associated with this user so I have tried to change the statement to Quote: ...WHERE userid = (/*userid from session*/) SET newvalue = CASE rowid WHEN 1 THEN 3.5 WHEN 2 THEN 3.5 ELSE newvalue END
View Replies !
Multiple Updates
Lets say you have one table, but you want to update three values for three ids. UPDATE table SET value=100 WHERE id=1 LIMIT 1 UPDATE table SET value=2200 WHERE id=2 LIMIT 1 UPDATE table SET value=124240 WHERE id=3 LIMIT 1
View Replies !
2 Updates In 1 Query?
I'm trying to update fields in 2 different tables with 1 query..... I was looking for a solution on the net, having thought that's not a big deal.... I haven't found the answer.
View Replies !
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.
View Replies !
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.
View Replies !
Multiple Updates In One Query
I want to accomplish this: Code: UPDATE table SET value_code=1 WHERE value_type='value1'; UPDATE table SET value_code=2 WHERE value_type='value2'; UPDATE table SET value_code=3 WHERE value_type='value3'; UPDATE table SET value_code=4 WHERE value_type='value4'; Code: UPDATE table SET (value_code=1 WHERE value_type='value1'), (value_code=2 WHERE value_type='value2'), (value_code=3 WHERE value_type='value3'), (value_code=4 WHERE value_type='value4')
View Replies !
SELECT Latest Updates
I have these two tables: "cats" catid INT catname VARCHAR "messages" messageid INT messageparentid INT catid INT messageposted DATETIME messageauthor VARCHAR messagetext TEXT What i need is to get all cats and include the column "messageauthor" from table "messages", but only the latest "messageauthor". That being the the post with the higest "messageid" and the same "catid" as parent table "catid". SELECT * FROM cats ...
View Replies !
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?
View Replies !
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?
View Replies !
Updates Slow Intermittantly
my webs site does updates like: update Users set lastAccess=NOW(),lastIPAddress='00.00.00.00' where id="123" on this table. Every so often, this query appears to take for ever. I'm seeing entries like the following in mysql_slow_queries: # Wed Mar 4 12:40:35 2009 # Query_time: 53 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 use favorit5_FavoritesTracker; update Users set lastAccess=NOW(),lastIPAddress='11.11.11.11' where id="123" # Wed Mar 4 12:40:35 2009 # Query_time: 40 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 use favorit5_FavoritesTracker; update Users set lastAccess=NOW(),lastIPAddress='22.22.22.22' where id="456" This seems like an unreasonable time for this update, especially since there's an index on id. I've tried optimizing the this table once a day, but that does not appear to help. Show create table Users gives the following:
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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
View Replies !
|
TRACKER
