MYSQL :: MySQL + SQL Server 2000 Both Running On XP Pro?

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.

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?

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?

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.

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

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.

Problem With MySQL On A Dell PowerEdge 1850 Running Windows 2K Server
I have 3 friends that installed MySQL 4.0.24 on their Windows 2000 Server platforms all on Dell PowerEdge 1850's.

After one to two days - Windows gives an error that the EVENT LOG IS FULL and the applications lose connectivity to the DB. I have to restart the system in order to bring it back up.

THis does not happen on Win 2003 nor 2000 Pro nor XP Pro. Only on Win 2k server on Dell PowerEdge 1850.

Running .sql Script On Server?
I just installed a .php based mailing list program, which I've never done before, and one of my instructions is to "Run the mysql.sql script to create the necessary tables in the database." I have no idea what that means or how to do it. Is there an easy set of instructions anyone can give me on this one?

Check Which Server Running
i'd like to know how control which server is actually running between mysqld and mysqld-max.

Switch Query Logging While The Server Is Running
It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened.

Otherwise, the server has to be restarted to change logging, which is a bit annoying...

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?

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.)

#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).

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 :

Help Please Running Mysql On Os X
I am very new to mysql. I am using the sitepoint book 'Build your own Database Driven Website using PHP and MYSQL. I have installed mysql mysql-5.0.41-osx10.3-powerpc. Under preferences/mysql it indicates that the mysql server is running. When I try to access mysql through the terminal window I get a message - command not found. Or no permissions. I can go to the bin directory and list the contents - they seem to be there. I can't get past page 21/22 Post-installation setup tasks. I am also new to using the terminal window. I suspect I have missed something really basic - any suggestions on how I can get up and running would be much appreciated!

Need Some Help In Getting MySQL Set Up And Running.
I wasn't sure if someone would be able and willing to help me, but I am new to installing MySQL on a Windows 2003 server (actually .. any server), but I am installing it on a Windows 2003 server right now. I also installed a new version of PHP on the same server. Everything looks fine, but when I go to phpinfo.php I don't see anything saying MySQL. (I saw somewhere that if MySQL is installed properly, it should be displayed on the phpinfo.php page.)

I am currently trying to set up and run Cerberus Help Desk, but it isn't finding the MySQL database that I installed.

So, I would really appreciate it if someone could not just help me via email or postings in here, but actually by using Instant Messenger (AOL, Yahoo! or MSN) to walk me through the set up, testing, etc. so I can get things up and running properly.

I was hoping that someone with more experience than I might be willing to help me in this manner.

Could Not Get MySQL Running
I went to MS-DOS to start the MySQL application by typing mysqld into the bin directory of where I installed MySQL but once I did typed the command and pressed enter this is all I got :

A moment passed before I am shown the path of bin with no indication of MySQL server started. And also I have installed this as a window service.

Running MySQL 5.0
I've just downloaded and installed 5.0 on my Pc/ win 98se.
When I run the program MySQL Command Line Client, it appears to run for a second then disappears. I see the program flash open for a second and then it is gone.Complete newb needs some help.

MySQL 4.1 Running
I've been running mysql 4.1 for sometime and using phpMyAdmin (v2.6.2) to administer the databases.

Using php scripts I can also update/insert etc the databases (maintained on my laptop Mac OS X Tiger).

Suddenly, I can't get phpMyAdmin to load in the browser. I've also tried other MySQL GUI tools like CocoaMySQL and Navicat....they won't run either. I downloaded and installed phpMyAdmin 2.6.3-pl1 as well but no improvement.

Why would mysql run but the admin apps not work?

Running MySQL From A CD-ROM?
I have used PHP and MySQL for a few years now. Just today I can across an application that had a MySQL database running locally off a CD ROM. I did not know this was posible. When the application runs it starts up the MySQL database without the user even knowing they are running it. It is pretty amazing.

So I want to do the same thing. Is there any documentation on how to run MySQL locally. I would like to know how to build the database and create tables under these curcumstances.

Running MySQL
I have installed mysql-3.23.54-win and it all seems to have gone OK .... now i want to run it and setup a database. I dont have an icon on the desktop and there is nothing in Start - Programs ..... start it from DOS prompt via C:> C:mysqlinmysql.exe and i get error 2003 cant connect to MySQL server on localhost <10061>

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?

MySQL Is Running, But I Can't Connect
I really need some help with this. MySQL will not start on boot despite
everything I've done to make sure that it is set to do so.

When I start it as root from a terminal with "/usr/bin/mysqld_safe
--skip-grant-tables &" I show several mysqld procs. and one mysqld_safe,
but I can't connect:

[root@adamsmdk madams]# ps -aux| grep mysql
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 3650 0.0 0.1 2276 664 ? S 11:09 0:00
/usr/lib/courier/authlib/authdaemond.mysql start
root 3654 0.0 0.1 2316 792 ? S 11:09 0:00
/usr/lib/courier/authlib/authdaemond.mysql start
root 3655 0.0 0.1 2276 664 ? S 11:09 0:00...............

Gdb Bus Error When Running App With Mysql 5.0
When linking with mysql 5.0 library, I can't no longer use gdb to debug
my app anymore. It cores immediately with a bus error. I've also
noticed that the size of the executable is more than doubled compared
with one linked with mysql 4.0

Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP. Any suggestions or experiences?

Running Two MySQL Versions
Actually what I want to do is remove 4.1 because I downloaded 5.0 and installed w/o removing the previous version. I now have port 3307 for 5.0. Is this a problem and how can I change it back to 3306 so e.g. when I use Apache/PHP evrything works?

MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:

On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?

Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database.

I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site.

The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss.

I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference.

For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem?

I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.

MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app.

if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.

Running Mysql From Shell
I need to run this sort of querys from shell:

delete from 3dinformatica where preco = " " ;

CREATE TABLE tudotest AS SELECT DISTINCT * FROM 3dinformatica;

DELETE FROM 3dinformatica;

INSERT INTO 3dinformatica (cr_datetime,produto,vendedor,preco,link) SELECT DISTINCT cr_datetime,produto,vendedor,preco,link FROM tudotest;

DROP TABLE tudotest;

i wanted to put the mysql cmd in a file like mysql.sh and run it from crontab.
i have about 100 querys like that i need to run at the same time.

Running Mysql On Old Computers
IÂ´m running mysql on a Pentium 166 Mhz with 16 Mb of RAM. Pretty old, right?

I want to know if there is a way to improve performance. I donÂ´t know, something about reducing the number of queries that it will respond or cutting out some features.

Testing If Mysql Is Running
how can i test if mysql is running on my machine?

Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems
that running MySQL in RAMDisk might be a good solution. Access to the
database is through PHP.

Running Two MySQL Versions
It seems that my computer is running two different mysql versions. When I'm trying to login to the database it refuse my password and giving me access to the test configuration. This is what i get in the event viewer.

Do you already have another mysqld server running on port: 3306 ?
Event id 100.

The problem occur when I changed my password for the database. I have turned off Mysql in local services but i think that that's the original version. When I start the xampp i think it starts the winmysqladmin version (not sure). How do I reconfigure the hole thing and how can I see what's running on my machine.

I actually have another question to. I'm trying to run and open the shell mysqladmin which doesn't work. It's just a flash, which one of them am I supposed to run?? You have several options like mysqladmin, mysql, mysqld, mysqld-nt....etc. I opened the winmyslqadmin which i think wasn't that good.

Running Backup For Mysql
Can anyone suggest a reliable and inexpensive backup service for mysql? I have about 50 tables, of which I've been doing database backups daily on the server, then downloading the backup every couple days or so. The backup files are starting to get relatively large, and I'd like to find a service to backup to off site.

MySQL Database Running
How do i find out if a MySQL database is running or not?

Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users.
Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station.
But I have problem to start the program (mysql.exe). It just gives back an error:
Error 2003: can't connect to MySQL server on localhost 10061
Network is running, I can ping localhost. I don't know what to do to get it running.

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 Running Query On Data Through Php...
I am trying to take address info from 5 different fields in mysql, concatenate them into one string of text and have then run through a POST, like you would in a form, and have them spit out on the other end into the database the Lat and Lon of the address... I can do it manually, but I would like to do it automatically...

I would like to know if I am going at this right...

Psuedo

QUERY=SELECT addressNumber, addressStreet, city, state, zip FROM table
$addressStr=addressNumber + " " + addressStreet + ", " + city + ", " + state

RUN IT THROUGH A POST SOMEHOW??? and call GEOCODER from my manual insert script...

$sql=INSERT INTO table SET lat='$lat', lon='$lon'