Query Behaving Differently In Windows And Linux

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?

---

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.

---

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.

---

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.

---

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?

---

Switched To 4.1, Now Passwords Work Differently - How To Adjust?
I switched from MySQL 3.23 to 4.1. I used Pear DB but now, it doesn't seem to work so I switched to Pear MDB2.

I used MySQL Control Center to add a new system user to the MySQL user table but the password was like an nd5 hash instead of the old 16 character password in version 3.23.

When I try to connect it indicates it can not connect.

---

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.

---

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.

---

Query Cache Not Working: MySQL 5 / Windows XP
I just installed MySQL 5, and its running great except that the query cache is not working, despite the configuration excerpt from my "my.ini"
below:

query_cache_size=5M
query_cache_limit=2M
query_cache_min_res_unit=4096k
query_cache_type=1

From the MySQL command line, if I enter: SHOW VARIABLES LIKE
'have_query_cache';

I get:
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| have_query_cache | YES |
+------------------+-------+

Also, doing a: SHOW STATUS LIKE 'Qcache%'; gives me:

+-------------------------+---------+
| Variable_name | Value |
+-------------------------+---------+
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 5234168 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 450 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 1 |
+-------------------------+---------+


I figure the "Qcache_free_blocks" and "Qcache_total_blocks" values of 1
are creating the problem; it's basically telling me that there are no
(okay, 1) free blocks to put my query. However, these values never
change.

The query cache is not vital to me, but it does improve performance, and
I'd like to get it going....

---

Where Is My.ini On Linux!
Where do i find my.ini on a linux box! or should it be something else! any help would be appreciated...my aim is to change the location of the data files!

---

GUI For Linux
suggest the best GUI of MySQL for Linux with Store Procedure support(Create/Update). Better if also supports triggers etc.

---

Win To Linux
I have set up a website on a windows machine using PHP MySQL but I want to port this over to a Linux machine.
Is it possible for me to simply copy over the MySQL data files e.g. .frm .myi .myd files over to the Linux machine and place them in the appropriate folder after creating the database?

---

Linux Box
i have a redhat 8.2 box and people told me i should have mySQL in it. is there a way to find out whether my linux has it or not?

---

Linux
i installed mysql(usr/local/mysql) on linux but its not starting showing me error like
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
though mysql.sock file exists(linked) in tmp directory wont helped me.

---

Low Performance With Linux SMP
I use
#mysql -V
mysql Ver 12.21 Distrib 4.0.15, for suse linux (i686)

with a SMP-kernel

When I used this version with a kernel not SMP mysql was very very fast but now
with the SMP-kernel the mysql is very very slow. I takes several minutes to make an INSERT on a table with near 50.000 Records

Is there any problem with mysql an SMP? is a problem of the version I have installed?

---

MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.

There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I can not seem to get any of the functions
working on it. So I have now dopwnloaded the latest version hoping
that this will fix the error.

I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but
i'm getting the following error message when I install
MySQL-server-4.0.1-0.i386.rpm : Code:

---

Upgrade From 3.23 To 4 In Linux
I have an installation of MySQL 3.23 located in /usr/local/mysql.3.23.51,
which is working perfectly. Now I installed in /usr/local/mysql.4.0.14 the
binaries for a new version (4.0.14 of course), and don't know how to start
using it instead of the older one. I have a link: /usr/local/mysql pointing
to /usr/local/mysql.3.23.51 and some few databases in that directory.
My data files are in MyISAM format.

How do I migrate the database files? How do I tell Linux to use this
version? I never did a task like this in Linux, for I always used MS Operating
Systems, so please be as clear as possible... In fact, I didn't understand
the MySQL manual about this topic.

---

Mysqli.dll In Linux
We have developed and application using mysqli.dll and the following functions:

mysqli_connect()
mysqli_query
mysqli_result()

The platform was: Windows 2003 / IIS 6.0 / PHP 5 / MySQL 5

Now we need to port over the application to Linux - Red Hat Enterprise Server / Apache / PHP 5 / MySQL 5

Does anyone has an idea what to use instead of mysqli.dll in Linux servers.

---

Db Migration From Linux To Xp Sp2
db migration from linux to xp sp2 -- can't read

I want reinstall my bbs program from fedora 3 to xp sp2 apm.

The apm version is apache 2.0.54,php 4.3.11 mysql 4.1.11.(linux and xp)
And backup the data and restore on xp machine. ( I tried db copy)

The problem is I can't log in my bbs program with migrated ids. But, i made another id and tried to log in, this worked.
At phpmyqadmin, I can see the whole records including new id. But bbs program could not read the other migrated records.

---

Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.

---

Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3
in particular? My goal is to do no harm to my current 4.1 setup. Can
the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql
commands for running multiple versions?

---

In My Linux Server
What is the default server SQL mode when My SQL 5.0 is installed? Is there any available modes.

---

Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?

---

Linux Version
I have a need to setup a MYSQL cluster, however, I do not have ANY experience of Linux and you cannot set up the cluster on Windows currently.

I learn fairly fast, but would like someone to recomend a version of Linux that would happliy support the MYSQL cluster and also has some good installation instuctions!

---

Linux To Install
I am creating a dedicated DB server running mysql. What is the best linux to install for this?Also the db server will have its own ip is there any other additional security measures that should be taken?

---

MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account.

Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.

---

Debian Linux
I have mysql 4.1.8 from backports.org running on stable debian linux. I have 3 medium-scale web apps running off this same db server. the log files on this machine are becoming larger every day. finally this morning the db server hung up and after some detective work i found the culprit was the log files. they are huge, 3 gigs sometimes, and when logrotate tries to zip them the whole thing geeks up. in the /etc/mysql/ directory there is a logrotate.conf file that contains the following comment :

# Configuring /etc/logrotate.d/mysql-server does not yet work.

which is the logrotate config for mysql on that machine. I need to rotate those log files much much sooner than they are being rotated now. does anyone have any experience with a similar setup?

---

Toad For LInux
Does anyone know an Equivalent of TOAD for MySQL on Linux

---

Intalling Mysql On Linux
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this...

Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR
Platform : Small - Fedora Core 3
Control panel : Plesk 100
Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb

OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local

This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this, then that etc.

---

Uninstalling MySQL On Linux
I recently manually installed MySQL on linux/fedora 5 which caused problems as MySQL is built into the the RPM. Therefore I would like to uninstall my version of MySQL and revert back to original.

As I am new to Fedora can anyone point me in the right direction to help me uninstall MySQL as there does not appear to be an unistall package/function.

---

Benchmark Differences: Mac OS X - Linux
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.

The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is more than twice as slow. Below are the benchmark
results for boch machines, and the my.cnf I used.

I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?

---

Installation Problem On Linux
I am using fedora 8, and trying to install mysql-5.0.51a-linux-i686. The script runs well:
scripts/mysql_install_db --user=mysql

but when i try to start the daemon using:
cd . ; ./bin/mysqld_safe &
or
cd . ; ./bin/mysqld_safe & --user=mysql

i get this error message:
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysql ended

---

MySQL, Linux, Ia32, >4GB RAM
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32
(e.g., Xeon) with more than 4 GB RAM? Did you find a performance
enhancement? With PAE mode on? How does this affect MySQL - being a
multithreaded process, is there any benefit in having all that extra
memory as anything other than a big disk cache?

---

Benchmark Differences: Mac OS X - Linux
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.

The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is more than twice as slow. Below are the benchmark
results for boch machines, and the my.cnf I used.

I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?

Thanks in advance for any insight,
Jan Pieter Kunst

Benchmark results:

Dual 1GHz G4/Mac OS X Client 10.2/MySQL 3.23.57:
===============================================
alter-table: Total time: 186 wallclock secs
ATIS: Total time: 37 wallclock secs
big-tables: Total time: 78 wallclock secs
connect: Total time: 57 wallclock secs
create: Total time: 118 wallclock secs
insert: Total time: 6811 wallclock secs
select: Total time: 1340 wallclock secs
wisconsin: Total time: 21 wallclock secs

.... snip ...

insert 137.00
insert_duplicates 23.00
insert_key 3099.00
insert_many_fields 10.00
insert_select_1_key 4.00
insert_select_2_keys 6.00

.... snip ...

update_big 93.00
update_of_key 180.00
update_of_key_big 29.00
update_of_primary_key_many_keys 478.00
update_with_key 228.00
update_with_key_prefix 22.00


800 Mhz Intel/SuSE Linux 8.0/MySQL 3.23.57:
===========================================
alter-table: Total time: 230 wallclock secs
ATIS: Total time: 36 wallclock secs
big-tables: Total time: 32 wallclock secs
connect: Total time: 89 wallclock secs
create: Total time: 90 wallclock secs
insert: Total time: 2895 wallclock secs
select: Total time: 1502 wallclock secs
wisconsin: Total time: 20 wallclock secs

.... snip ....

insert 190.00
insert_duplicates 39.00
insert_key 140.00
insert_many_fields 10.00
insert_select_1_key 5.00
insert_select_2_keys 7.00

.... snip ....

update_big 33.00
update_of_key 35.00
update_of_key_big 22.00
update_of_primary_key_many_keys 28.00
update_with_key 178.00
update_with_key_prefix 44.00


These are hopefully relevant parts of the my.cnf I used:

[mysqld]
skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=4M
set-variable = net_buffer_length=8K
set-variable = record_buffer=1M
set-variable = thread_cache=8
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

---

Reinstalling Mysql On Linux
Hi I'm running MySQL under debian and was wondering how I can uninstal it. So that I can do a fresh install of MySQL.

---