Bluehost.com Web Hosting $6.95

Differences between 2 MySQL databases

This is a discussion on Differences between 2 MySQL databases within the MySQL Database forums, part of the Database Forums category; Hi everybody, I'm gonna ask a newbie question since I've used MySQL only twice in my life, and ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-17-2007
Vilco
 
Posts: n/a
Default Differences between 2 MySQL databases

Hi everybody, I'm gonna ask a newbie question since I've used MySQL only
twice in my life, and it always was installed on a Linux box in my LAN (I
use WinXP). This time I wrote a routine which creates tables and inserts
data into them via ODBC (Driver version 3.51 both here and at the costumer's
site). Here it all works perfectly, but at my customer's site it's giving
errors; obviously, otherwise I wouldn't be here.
In my LAN environment I can insert records in a table, while at the customer
many errors are rised: the first was "Data too long for field xyz", where
the field xyz is a varchar(40) and I'm inserting exactly 40 bytes of data
into it. I cut it to 38 and now it stopped giving this error at the
customer's site, but now it throws an error on a datetime field: the datum
is empty so I just don't send any data to that field, and theyr MySQL
answers with "Incorrect datetime value: '' for column 'ORANAS_AN' at row 1".
The same operation, here on my local MySQL, works flawlessly for thousands
of records.

Note that the tables on the customer's MySQL DB have been created via ODBC
using the same routine (the same exact sequence of SQL commands) used to
create the tables in my LAN environment, so table structures are identical
and also the engine type and charset, since the "create table ...(" commands
all ended with the string
") ENGINE=InnoDB DEFAULT CHARSET=latin1"

This considered, there is obviously some difference between my MySQL and my
customer's one: or a version difference or a configuration difference or
both, as it seems.

Theyr errors begin with this string (they have MySQL on a Windows box):
[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]

My errors begin with this string (I have MySQL on a Linux box):
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a]

Is there any known difference in the ways these two versions/setups of MySQL
handle incoming data? Or are there differences in the default configuration
these two versions/setups use?

Where should I look to find those different settings which prevent my
commands to execute regularly on the customer's DB? I'm using both SQLyog
and direct ODBC access.

TIA anyone
--
Vilco
Think pink, drink rose'


Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 07:38 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0