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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
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
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.
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 :
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?
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:
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?
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.
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 =
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.
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.
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.
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
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.
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
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.
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
|
TRACKER
