MYSQL :: SQL Server 2000

SQL Server 2000
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above

SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.

How Much Is MYSQL? Does It Run On Win 2000 Server?
How much is MYSQL?

Does it run on Win 2000 server?

Does it have reliable ODBC drivers?

Has anyone reliably used it with a Powerbuilder application?

I tried looking for a FAQ (didnt see one) and doing a keyword search.. a lot of hits - to many threads to digest.

MySQL + SQL Server 2000 Both Running On XP Pro?
I've had mysql on my machine plenty of times with no trouble currently i have SQL Server 2000 Trial running but never both at once. Unfortunately i have to have them both on at the moment.

So before i install and mess everything up, Does anyone here have this setup?

I basically want to get php/mySQL/MSSQL running with IIS

App In Server 2000 Connect To MySQL - MAC
I am absolutely new to MySQL. I came across the need to look at MySQL from an application I was developing using REALbasic.

Here is the system:

An MS 2000 Server with an application that needs to connect to a SQL database.
A MAC OSX 10.4.7 PPC G4 running MySQL mysql-max-5.0.24a-osx10.4-powerpc.pkg.

What I can do:

I can connect to the MySQL table using the data app in REALbasic on the MAC and make changes etc.

What I need to do:

I need to create a DSN to allow the App on the 2000 server to connect to the MySQL server table on the MAC to make changes etc.

How can I accomplish this?

Probs With MSSQL Server 2000
Well i have installed MSSQL server 2000 on my PC(OS:XP Prof). And the server does run as well as the agent. I know how to use the registration wizard of SQL server 2000, cause untill i sucessfully complete the registration process i woun't be able to create a database OR use the query analyser.

I know how to access the registration wizard, but i at last it gives me an error saying"access not granted, unsucessfull registration" **** like that.
:confused:

And i am using the same PC as the server as well as client.

Communication Between MySQL And SQL Server 2000.
Is there an established (third party software for instance) means to allow communication between MySQL and SQL Server?

For instance, SQL Server has a replication service that allows a database to be kept in sync with another one (SQL Server to SQL Server). Does anyone know if such a thing exists for SQL Server to MySQL and MySQL to SQL Server?

MySQL On Windows 2000 Server
I want to install MySQL on to a Windows 2000 Server, I also want to remotely manage it using MySQL administrator, so connecting to the server using its IP Adderss, On windows workstations if you try and connect to the MySQL database from a remote mechine it does not allow you to do it (I have disabled all firewall's etc.).
Do you have to install a server version and not LOCAL version of the MySQL server?

My.cnf Is Not Available Under Windows 2000
according to the manual,

There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf , please?

My.cnf Is Not Available Under Windows 2000
There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf.

SQL 7 To MSDE 2000
I would like to upgrade a machine from SQL 7 to MSDE 2000. I would like to keep the existing database from Altiris Deployment solutions intact. Is this upgrade possible?

SQLServer 2000 Conversion
I have a web app that uses SQLServer 2000. I am switching to MySQL 4.

1.1. I have re-created all the tables but I'm running into 2 problems.

1. In SQLServer I can create a date field and as the default value I

can use a macro/function to have it set the default. I have not seen

an equivalent in MySQL. After doing some research I have seen only

two possible solutions:

a) Use timestamp. This is not suitable because it has a tendency to

auto update and it's more trouble than it's worth to use a field that

does this when you know it should never really change.

b) Use datetime and just insert the time in. This option will
require

me to mess in the web app and go through and change SQL which I

really would rather not have to do but will as a very last resort. I

prefer the database to handle this sort of thing.

So am I missing something? Or does MySQL simply not support using

macros or functions as default values like SQLServer does?

2. Second problem may not be MySQL. I use Naicat and I created a

varchar field with a length of 2. When I saved the table it was

converted to a char of length 2. This was not cool because the two

are not equivalent. I don't care how much faster char is. So my

question is, is there something in MySQL that doesn't allow varchars

of length < 4 or is this a Navcat thing?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-

Stormblade (Shaolin Code Warrior)

Software Developer (15+ Years Programming exp.)

Access 2000 As Frontend
I know this is an 'old chestnut', but I have been trying to add an ODBC connector for MySQL frpm mysql.com. It downloaded and installed correctly, but when I came to configure it, the dialogue looked different from the picture on mysql.com help page. I figured it had just changed and made a best guess of what went in which text box.

Thing is, whenever I try to test the connection, I get an error message;

[MySQL][ODBC 3.51 Driver]Access denied for user: 'dbusername@my fixed ip address' (Using password:YES)

I am assuming it got through to the MySQL database and was denied access because it had my fixed ip address attached, rather than say, localhost? Is it a config problem or have I missed something?

MySQL On Windows 2000
I am migrating my web enabled Access dbs to MySQL.
I am using ASP on my development machine running Win 2000 professional with IIS and MySQL.When I attempt to run queries on my development machine, against the MySQL databases they run like a dog!! My Access databases flew compared to MySQL. I'm not expecting blistering performance, but it's taking minutes to access tables with under 20 rows.However, when I upload to my hosting company, everything is fine.
Can anyone give my ideas how I can tune my developmet machine speed up the queries?

Mysql Crash On Win 2000
I have latest mysql version 5.0.2 alpha installed on my windows 2000 machine. Now there is bug in the version, which causes the server to crash everytime I try to use any mysql client like phpmyadmin, mysql query browser. The only possible way of accessing the database for now is only through the command prompt and not theough any other client. This bug has already been reported to mysql. But it appears they have fixed in the cvs. But as of now there is no binary patch for windows. Anyone got any ideas on how do I tackle this one without having to change my version.

MySQL Script And SQL 2000
I have a MySQL script which contains scripts to create tables and insert data. I would like to re-create those tables and insert those data in Microsoft SQL 2000. What would be the best way to do that?

Raw Partition With InnoDB On Windows 2000
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...

In Linux the configurarion is:

innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =

and in Windows 2000 ?? Code:

Can Run Two Versions Of MySQL In Windows 2000?
I have been running 4.0.13 for several weeks now and though I'd like to =
test 4.1.0. 4.0.13 is under c:MySQL. I downloaded 4.1.0 under c:4.1 =
AlphaMySQL. When I try to launch mysql it brings me to the old =
version, how do I access the new one without killing the old one? (I =
have also tried putting 4.1.0 on a totally different machine and linking =
to it also.)

Raw Partition With InnoDB On Windows 2000
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW PARTITION to use InnoDB tablespace... In Linux the configurarion is:

innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =

and in Windows 2000,

5.0 Security On Windows 2000 Best Practices
Does anyone know of a set of standards for securing MYsql 5.0 on Windows
2000? I already saw the document on mysql.com's website at
http://dev.mysql.com/tech-resources...ql_windows.html,
but something that is missing is precisely what are the minimum
permissions needed for the server? Specifically, which directories need
which access rights?

#2000 - Unknown MySQL Error
I'm using my SQL via one of SBC yahoo's packaged deals for web access.

Everything had been going along smoothly...until today.

Under PHPMYADMIN...privileges I started seeing the following msg:

Warning: Your privilege table structure seem to be older than
this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

Whatever SQL statement I try to run (a select, alter, update etc etc) I get the #2000 - Unknown MySQL error msg. So I can't run the script mentioned in the error msg since it won't get past the very 1st alter statement.

I'm not sure what went wrong but I can't even "reload mysql" - I just keep getting the "Uknown" msg.

With the exception of the "mysql" database, all of my other databases show a dash sign instead of the number of tables (in the PhpMyAdmin drop down. I can't even click on one of them without getting the "uknown" msg.

Connecting To Mysql From MSAccess 2000
I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS =
Excel. However, it returned the following error when I tried to link =
some Mysql tables from Access 2000:

ODBC--call failed.
[MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for =
user: '@<my ip address here>' to database 'tradingdata' (#1044).

Regular Text File How To Sql 2000 Table Code
i have a text file as follow, line with ¡°|¡±and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|

i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate
smalldatetime£¬update smalldatetime£¬after to sql table is as follow,

sign year month trandate update
8 -186075919.000 387820.000 3/31/2008 4/23/2001
9 -3919.000 -123620.000 3/31/2008 1/1/2001
8 -18623419.000 387820.000 5/30/2008 4/23/2001

Open And Close Time 2000 Kills The Connection
I am moving some data from a text file into mysql and my code in c# using ODBC fails.

Actually I created a loop to test mysql and realized that mysql goes banans when

for(int i=0; i < 5000; i++) {
connection.Open();
connection.Close();
}

This code is for illustration purposes ONLY but it should work!? When I reache around 2000 the connection.Open() loses the connection to localhost and terminates the program! After a minute I can get access to mysql again? Inserting a delay of 100ms seems to keep things going.

Exporting Binary Data From Access 2000 Into MySQL 4.1.5 Gamma
I'm trying to export a pictures table, my mySQL database table already
exists so I have linked both tables in Access and I tried to run a
simple append query in Access to export the data but I either :

- lose the connection to mySQL
- have packets that exceed max_allow_packet

I have tried different things to set max_allow_packet to a higher
value which seems to be 1M by default. I want it to be 1G like setting
the value at run-time from the prompt but it seems that no matter what
I tried, I either get the syntax wrong or the command is simply
ignored.

I have also added in my.cnf, the following lines :

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.

Transferring Tables From Testing Server To Online Server
I need to copy my tables from a testing server on a local area network to my hosting companies online server. Is this something I can use MySQL Query Browser to do, and if so how?

Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors.

The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2.

I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?

Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server?

I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.

Copy Data From Database On Server A To One On Server B
In an older version of MySQL that defaulted to MyISAM table types I could simply copy the contents of the MySQL/Data/DbName folder to a similar folder on another server and the MySQL on that server would, following a reboot, see the entire database.

Using the 4.1.12 version of MySQL the default is InnoDB tables ( and I do want to move to transaction save tables anyway ) - which do not respond to the same treatment.

How can I copy and entire database from one server to another ( this new server is at a different site, connected over the VPN )

Both servers are running MySQL 4.1.12 on a Windoz operating system.

How Do You Manage Changes From Development Server To Production Server?
What started out as a simple test of mysql has turned into what is
quickly becoming a replacement for our entire business system and web
site

The bad news is that we are now wrestling with how to we continue
working on development the system without risking down time for users.
If we work on a development server, how can we log the changes to table
structure and then apply them to the live database on the production
server when we are done testing?

Is there some sort of tool or log that would just let us apply table
structure changes to another copy of the database?

Ugrading Win2k Server To Win2k3 Server
I would like to know if there is anything I should watch out for or do before I upgrade my Win2k server to Win2k3 server. I am running MYSQL version 5.0.27 and PHP 4. Which I must admit was a bit of a challenge finding the right combinations of the 2 that work together very well for my setup.

MySQL 4.1.22 And SQL Server 2005 On Same Server?
Is anyone running MySQL and SQL Server on the same machine? We are running SQL Server 2005 on a Win2k3 server and need to add an instance of MySQL for a new PHP site.

Server To Server Root Prob
Not to sure if this is the correct forum for my problem, but here it is. I have a site running mySQL and the hosting I would like to keep but is in another country, not UK where I am based.

I have a domain hosted on another server which I would like to use as the main site domain and is a .co.uk which I belive has to be hosted in the UK.

Now when I use the UK domain and link to my overseas SQL data base it changes the path eg /home/www.myurl.com/index.html/..... the /home/ is the problem which causes errors when the database is called..etc.

Mysql Server And Regular Server
I recently decided to get another server to do just mysql, however, I ran into a few problems.
As soon as I switch the script to pull from the other server it creates a huge lag between the two and eventually starts timing out the sites. in my.cnf i did do skip-name-resolve but still the same thing.
Are there any programs or anything that are maybe bottlenecking it because the site will load in the first 10 secs after i switch the mysql (with a lag) but that lag gets bigger and bigger.
The mysql error log doesn't show anything weird either.
To further complicate things, another server that was pulling off it worked for the first few hours, then when traffic started to increase, it started doing the exact same thing. (both server loads were low and max connections was not getting even close). Roughly 600 qps, half to HEAP tables.

Unable To Connect To Database Server. Can't Connect To MySQL Server On 'localhost' (10055)
I am running a PHP application with mySQL . Some times it gives the following error.
I do not understrand why this error occures .

today i am using the application but it is not giving the error but error occures yested day .

Unable to connect to Database Server. Can't connect to MySQL server on 'localhost' (10055).

SQL Server
I have used PHPMyAdmin and MySQLFront for connection to MySQL to create and manage tables.

What tools would I use to connect to a MS SQL Server Database?

How Do I Set Up The Server?
I have tried installing both MySQL and DBDesigner4 but am confounded by the request to sign in -

Invalid Username / Password

So, can anybody tell me how to set up the program so that I can start working with a database?

Are there online manuals anywhere?

UDF Server 4.* 5.*
I noticed that behavior of "create function" depends on server version. Using connection with empty database name In early versions we do not need to write database name befor function name, but in 5.* we MUST write some, eaven if we realy don't have such database.

Question is:
Am I right? and From whoch version such behavior appeared.

Web Server Ram
How do I calculate the memory needed by a webserver (APACHE) connecting
to a mysql server (different box). Is this only related to the select()
operations / data transferred to the webserver?

On the mysql server I assume that I have to calculate the max tabel
size X the number of connections.. but I'm not sure about the web
server size.

On A Different Server
I need to know how do I place my databases on a different server on a different machine(a very remote machine.).

Are there some files that I can just place in some particular directories?

Server
My MySQL server is accessible only through the socket file (I believe).

netstat -lan yields:
cac1bc82 stream 0 0 c1e37378 0 0 0 /tmp/mysql.sock

I can't figure out how to get mysql to listen on 3306. I would like MySQL to listen on 3306 automatically upon boot.

I have gone to mysql.com and have tried everything i can find there.

Server
Error i get:

Can't connect to local MySQL server through socket ''

I am attempting to conect to my mysql database, through a program i'm writing using mysql++.The database is running and my website(also using database) is recieving no problems.

I notice in the error that it can't connect to socket '' which is the empty string which is wierd, looking for solutions on the net gave me plenty of results with the socket being '/tmp/mysql.tmp' or the like, but none with it empty.

Best Server
Could anyone answer my questions :

1. Can VB applications on Windows clients (workgroup)
access MySQL on a dedicated Linux server ?
If Yes, could you tell me how to set the
network for it ?

2. If my application should run from a windows client,
using MySQL, Which server is the best ( speed,stability,
ease of opration and cost ) for running the database :
a. Dedicated Windows server 2002
b. Dedicated Windows XP

Different Server
we have a client who we're designing a website for and we have a shared server so we thought we'd just host it there but we DON'T want to handle their email so I'm assuming this means they're going to have to stick with their current host right? Well ok, but we want to make use of a MySQL database but this would sit on OUR server...so how do I go about this?
Couldn't I just replace the 'localhost' with 'someipaddress/whereeverthedblives' or something like that?
The only other thing I can think to do is to have the specific page that holds the db information actually live on our server, but look like it's living on the same server as everything else.... I'm not even sure that would work....but regardless, I don't know which way to go.

Server A To Server B
I am a web master who up until about a month ago had only worked in ASP using Acess Databases. Now I have a client (in Austria) who I redid his web site using PHP and a mySQL database. To access the his db, I browse to a web site, log in, then manipulate the database that way. I just set up a new hosting account in America and am baffled at how I transfer the database from the current server to the new one? Do I somehow export and import the database? Is there a file created so to speak?

My Sql Server 5
I'm trying to connect to a Win XP instalation of Server 5, from a win 98 PC over our working LAN. The PC's can ping each other and can browse files on each other. I can connect to the sever from the XP PC, under MySQL and ODBC. The Win 98 PC has the ODBC 3.51 connector installed. I can't even get the DSN to connect un the the Create Data Sources.