How To Detect If Different Mysql Versions Are Installed/runing
from my InnoSetup setup :) I need to detect if any version of mysql is runing on my windows. Others sugested to check fo a mutex or a Class Name(dont know what are these) or Windows Names or Look for a mysql*.exe, so is there something common for mysql starting with v3 .. v5? I mean what is the thing that i have to search for, to know at least if mysql is runing.
For mysql v3 there are the posible runing files:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
mysqld-nt.exe
mysqld-opt.exe
or on Win98 only winmysqladmin.exe?
For mysqlv4 .. im not sure yet
For mysql 5 seems to be more simple, only
mysqld-nt.exe
Do I have to search for all these files(and others that I dont know yet :) ) to be sure that its not runing?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Benchmarks Of Runtime Versions Of Mysql Or Other Sql Versions Sqlite Hsqldb
mysql vs sqlite vs hsql First of all i'm on a win32 platform using java. I also have mysql installed. My question isabout benchmarks and multiple inserts & selects SQLITE: http://www.sqlite.org/ HSQL: http://hsqldb.sourceforge.net I current have a mysql database of approx. 80mb. Each day I Insert approx .5mb of new records into this table, and I might also run mutiple Update, Delete, and Select queries as well. I'm trying to get an idea of how fast a sql database engine will run given that is is inside of the JVM. I know it's going to be slower than a db engine written in C and that's a trade off for being portable to different operating systems. What I want to know is how much of a trade off though - I don't want to have to wait 10 mins or deal with screen freezing... Right now on a windows platform using mysql things move really fast. Can anyone give me an idea of the time delay needed to do these Inserts in HSQL (ie: how much does the jvm slow things down).. Thanks in advance
How To Detect If A MySQL Db Table Exists In MySQL 4.1+
$sql = "SELECT IF((SHOW TABLES LIKE '$subselectTableName'), count(*), NULL) AS numRows FROM $subselectTableName"; I am trying to write a SQL statement that will tell me if a table exists or not, this is because PHP will throw Fatal Errors and halt all programming if the table does not exist that I attempt to query. How do you write an elegant MySQL 4.1+ statement to detect if a table exists or not?
Mysql 4.1.7 Installed - What Now ?
I have installed Apache web server and PHP 5.0.2 on Windows 2000 I have just installed mysql. I got no errors but how do I start the service ? I have tried to test the connection between mysal and php but I get the follwing error in my browser Fatal error: Call to undefined function mysql_connect() in C:Program FilesApache GroupApache2htdocsmysql_up.php on line 9 The code for the page I am trying to run : <html> <head><title>Test MySQL</title></head> <body> <!-- mysql_up.php --> <?php $host="localhost"; $user="root"; $password="johnny5"; mysql_connect($host,$user,$password); $sql="show status"; $result = mysql_query($sql); if ($result == 0) { echo "<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>"; } else { ?> <!-- Table that displays the results --> <table border=”1”> <tr><td><b>Variable_name</b></td><td><b>Value</b> </td></tr> <?php for ($i = 0; $i < mysql_num_rows($result); $i++) { echo "<TR>"; $row_array = mysql_fetch_row($result); for ($j = 0; $j < mysql_num_fields($result); $j++) { echo "<TD>" . $row_array[$j] . "</td>"; } echo "</tr>"; } ?> </table> <?php } ?> </body></html>
Is Mysql Installed?
I am trying to set up apache2 php5 and mysql5 on my computer. I have managed to installed Apache and PHp and can get view phpinfo. But i am getting problems when i try to install mysql. Besically i am running the exe and it says it installed. Have gone into php.ini and removed the ; from the beginning of the extensions section. But when i restart apache and run the file with phpinfo there is no mention of mysql. tried to install phpmyadmin and it says the mysql handles arn't installed.
Installed MySQL
I downloaded and installed MySQL 5.0 on my laptop to experiment with it and learn. After the installation the software configured itself and I set a password. Now that I have it installed on my laptop, what can I do with the MySQL to learn it? When I launch it, I get a command prompt box asking to type commands. I thought that there would be a MS Access type of interface. Can you folks explain and give me some pointers on what to do next?
MySQL Installed, But Not Functional
I'm new to all this, and have managed to get IIS and PHP runing fine now, but I just ca't get MySQL running. phpinfo does not show MySQL, and the page I'm trying to run tells me MySQL Module is not available I've installed it correctly according to all the guides out there and I have the GUI tools. I've made a secondary user, but this is where I get lost. Every guide that I've looked at tells me once it's all installed it should just work. Is there something else I need to do or something that I've missed?
MySQL Unsuccesfully Installed
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've created directory /home/users/mysql and add group for mysql. Those are the command that I've used previously: shell>groupadd mtsqlid shell>mkdir /home/users shell>useradd -d /home/users/mysql -s /bin/false -g mysqlid mysqlid Then i decompressed mysql-3.23.55.tar.gz into /home/users/mysql and one new directory called mysql-3.23.55 created. According to www.mysql.com, mysql installation, i need to run ./configure --prefix=/usr/mysql but this is the message i've got. configure:error: no acceptable C compiler found in $PATH then when i tried to run this command shell>scripts/mqsql_install_db it also give me an error that is no such file or directory.
Do I Have Multiple Instances Of Mysql Installed?
I'm running ubuntu 6.06, with a web application called Joomla. Right now our databases appear empty.. while i originally panicked, our web application is running smoothly. I cant figure out why this app would work while it needs mysql. Is it possible this is connecting to another instance of mysql on my server and how would i tell?
Do MySQL 4.0.25 Deafult Installed Is Using InnoDB
I want to build up a e-commerce web site host by myself's Windows 2003 Server with IIS 6.0 + PHP 4.4.0 + MySQL 4.0.25 (www.oscommerce.com <--- it need a MySQL) But some reason, oscommerce failed fuction on MySQL 4.1.14 properly with the Order query fuction, and ... I am very newbie on MySQL, I like the MySQL Administrator Tool 1.1.2, but I installed a MySQL 4.0.25 in my home's PC, and run the MySQL Administrator Tool, discover many thing can't using ..., this tool is look like better for MySQL 4.1.x, and I know MySQL 4.1.x is using InnoDB databse But now I need oscommerce work well, so decided choose MySQL 4.0.25, but have some thing I don't understand and know well. 1. Do MySQL 4.0.25 default using the InnoDB to save the Database and Table or it default using the MyIsam to save the table?? If not, what is it using? 2. Do MySQL 4.0.25 default setting is support multilanguage like utf-8, big5 chinese (Taiwan), gb2312 chinese (China Mainland), english etc, since my oscommerce main target is for Chinese (Taiwan, Mainland), and english user.... 3. How to full backup MySQL 4.0.25 database + table easy and safe for newbie (better have the step by step or GUI Tools can using) 4. Since I had try MySQL 4.1.14 before, so I know it can allow remote connect to the database by using MySQL Administrator Tool from localhost, how to setting MySQL 4.0.25 also can remote connect by some GUI tools, with localhost?
Installed MySQL On WinServer2003, Can't Create Databases
It installed as a service, and seemed to start just fine, but on the 'databases' tab of the WinMySQLAdmin ver 1.4, I can't create databases. It shows 'test' but no tables. Right clicking gives me a menu with 4 flush choices Contents of C:Windowsmy.ini follows: #This File was made using the WinMySQLAdmin 1.4 Tool #8/5/2004 12:48:19 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.100 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=dfs password=dfs
Mysql 4.0.12 Version Cannot Be Installed On Windows Vista
We have application written in Java and Mysql running on laptops. Recently a fwe laptops have been upgraded to vista. Since our application is old we use 4.0.12 version of Mysql. I am not able to complete the installation. When I say Start the Service from the traffic light at the task bar it gives an error "Fails to install Mysql Server Service". It installs fine in Windows XP.
Installed MySQL On WinServer2003, Can't Create Databases
It installed as a service, and seemed to start just fine, but on the 'databases' tab of the WinMySQLAdmin ver 1.4, I can't create databases. It shows 'test' but no tables. Right clicking gives me a menu with 4 flush choices Code:
PHP Commands Unexecuted, But MySQL Successfully Installed!
I have a problem I found nowhere else on the net in some resources: My infrastructure: OS: Win XP pro, SP2 Webserver: Apache 2 PHP: PHP 5 mySQL: mySQL 4.1 (php and apache work!) And this is what happens: I try to connect to a mySQL db via PHP, which is done by the regular mysql_connect statement. But when I access the .php - file via my browser by typing "localhost", the code is executed UNTIL the php commands, not further. The code is really cut off when I view the source in the browser. What am I doing wrong!
Mysql Installed And Running But Wont Start (XAMPP)
hey iv installed xampp as i want to begin learning php and need the php and mysql servers, it all seems to be running fine in the control panel of XAMPP it shows apache and mysql as running. The problem is when i go to start mysql to create an actual database,by going: C:xamppmysqlinmysql the DOS window pops up and disapears and the motherboard beeps. Is this not the correct way of starting mysql for editing? im using wondows xp serivce pack2 and XAMMP 1.5.5.
MySQL Versions
I am using MySQL 5 on my computer but the web-hotel I am contemplating to use only use MySQL 4.0xx. Can I use the database without modifying it? Or do I need to "convert" (downgrade) it for MySQL 4.0xx? If so, how do I do that?
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?
Two Versions Of Mysql On Same Unix Box
I have mysql 3.23.58 version running on my unix box. I installed a new application on it which need mysql version > 4.0 so I thought of having two mysql versions running on the same unix box. I have first installation in /usr/local/mysql and I untared the new version in /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23. I am following instructions given in http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html I also created a empty file and named it as mysql.sock.new and stored it in /var/local. When I try to start this new version from /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23 using ./bin/mysqld_safe --datadir=/var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23/data & it says "A mysqld process already exists". Please tell me where I am going wrong and how to configure it properly?
Row Select In Old Mysql Versions
We are using MySQL version 4.0.20-standard. Our application requires a query to do a row select. From what I have found this version does not support rownum. We are unable to update the version of MySQL. Can anyone give us some support.
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.
Downgrade MySQL Versions
I need to move a MySQL database created with MySQL 4.1.22 on PHP 5.2.3 to a different server with MySQL 3.23.58 on PHP 4.3.8. Is it possible to convert the database to do this? Alternatively, is there a way to export from the newer version in a format that the older version will accept?
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.)
Previous Versions Of MySQL With XAMMP
I've downloaded XAMPP for Linux 1.5.1 for use on Fedora Core 4. I notice it only has the latest version of MySQL on it. I'm working on two web sites (for different clients) and they are hosted on different shared Linux hosting servers (with PHP), each with different versions of MySQL available, i.e: MySQL 4.0.25-standard MySQL 3.23.52 Is it possible for me to use older versions of MySQL with XAMPP? Could I just turn off MySQL in XAMMP and just run and older version of MySQL independently of XAMMP? If I can then how would I install multiple versions of MySQL in Fedora Core 4?
Symlinking Between Different Serveurs And MySQL Versions
I have a hosted server where we have both web and intranet share a same database. For interne reasons we need to migrate the intranet onto one of our servers and keep the web on the hosted server. We will thus have the database splited in two. Our intern server willl have MySQL5 and our hosted one will remain with MySQL3.23.39 at list for a while longer. I would like your advises on the faisability of using symlinking to access the tables on the hosted server from our intern server, knowing that MySQL version are different. The tables on the hosted side are MyISAM. The main idea is to avoiding using replication to access comon tables on remote servers.
Utility To Convert Between MySQL Versions?
My webhost downgraded from mysql 5 to 4 and I'm seeing errors in the forum I was running. All I can see that would have changed and given me this database error would have been this downgrade. Is there a conversion utility availaible that can change back and forth between MySQL versions? I've looked around for about an hour thru Google and on this forum, but I haven't found anything yet. I was getting password errors, but we seem to have resolved that issue, and now I'm left with this database connection error. Thanks for any assistance! P.S. The errors I get are: Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 331 phpBB : Critical Error Could not connect to the database
Selecting Correct Versions Of MySQL
I have searched this forum and google to try and get a comprehensive answer to this question but i haven't found anything yet. I am looking to select the correct versions of MySQL, Apache and Php so that they all work together. I notice that there are alot of issues with various different versions sets being chosen and there seem to be instances where it can be very problematic if the wrong one is chosen. I am looking to use InnoDB and would like to use the latest versions of everything as possible but it doesn't really outline anywhere what works with what best. There are lots of cases that outline what can be problematic but i'm trying to avoid this if possible and find what isn't problematic.
How To Detect Foreign Key ?
I have to creer a webapp that view a any database. But I have problem: I don't know which column (some table) is foreign key and which table this key points to ! I use JSTL;
Detect Locks
My program accesses an InnoDB database. I sometimes have to lock a table for a quite long time (10 seconds or so) to update, where I also forbid reading the table with a LOCK TABLE ... WRITE. When other users then try to access this table I don't want the program to be blocked for 10 seconds waiting for the lock to be released. I'm thinking of a nice little message box such as "please wait while another user performs critical updates" or something. But how can I detect if the table is locked? I read the following thread, Thread436-520964, but I don't want to give all my users the SUPER privilege so that they see all running threads using SHOW FULL PROCESSLIST. Anyway, this command can only show me if the table is locked WHILE the thread issues LOCK TABLE .. WRITE, can't it? What could I do? Is it the only solution to create another table that contains TABLENAME string, LOCKED tinyint unsigned where LOCKED>0 if the table has been locked?
Trouble With NATURAL JOIN Between MySQL Versions
I have this query which works perfectly well in MySQL 5, but doesn't work in 4.1. I know there were some changes made to join syntax between the versions but for the life of me I can't figure out exactly what I need to do to fix it: SELECT Status, UserName, FontName, FontPath FROM AccountInfo NATURAL JOIN AccountPrefs, Templates.Fonts WHERE AccountPrefs.HeaderFont = Fonts.FontID AND UserID = '$userID' works fine in v5, but in v4.1 I get the old "Column 'UserID' in where clause is ambiguous". I'm trying to match the UserID in AccountInfo and AccountPrefs, I just left the font thing in there as well because I'm not sure if it's contributing to the problem.
Alternative To Group_concat For Early Versions Of Mysql
Is there an alternative to group concat, if you are using a lower version of mysql. If any one has any ideas it would be great, currently my code (thanks to some one from these forums) looks like this. SELECT c.clientID, group_concat(ci.interestID) as interests FROM Clients AS c JOIN ClientInterests AS ci ON c.clientID = ci.clientID GROUP BY c.clientID HAVING find_in_set(1, interests) AND find_in_set(3, interests) Is there any way of doing this on a lower version of mysql? Is it possible to wirte a function similar to group_concat?
Detect Real Character Set
Is there any way to detect the real character set use in columns? I've just seen a mysql 4.0 database where the default character set was latin1 but greek was being inserted. When that database was upgraded to 4.1 the greek became unreadable. So I guess I'm asking how can I detect this so I can run a process on suspected databases and ALTER them to the correct character set.
How Can We Detect Replication Failures?
What is the easiest and sure way of generating an immediate email notification for replication failure? We currently use a PHP script in crontab that submits the 'show slave status' command and then checks on the 10th flag (Slave_IO_Running) to be 'Yes'. Is there a better way?
Detect Date Ranges
i have a table containing a list of 'dates' attached to 'events'. I'm trying to display the dates returned for an event by combining dates that follow each other in date range. Example. The resulting dates are '1973-10-16','1973-10-17','1973-10-18','1973-10-19','1973-10-22' And it would be shown as 1973-10-16 to 1973-10-19, 1973-10-22 I'm trying to do it in php but i was wondering if it would be possible in mysql?
Detect And Track Updates
I'm trying a develop a connector (or synchronizer) between MySQL and OpenLDAP(very similar to Metadirectory connector). The connector has to detect any updates made to the mysql database and should replicate that in OpenLDAP. The first part of it, is how to detect changes in MySQL? I thought of the option of using a Timestamp variable as an additional column in my DB table. But it won't work for 'delete' detection. Please let me know how to do that or point me to any source regarding that. Please reply soon as this is a part of my project.
Detect Similiar/identical Rows
I have a table where I register this info: user selection_1 selection_2 Lets's asume this records: | USER | SELECTION_1 | SELECTION_2 | | A | 1 | 2 | | B | 2 | 1 | | C | 1 | 3 | | D | 1 | 2 | I want to detect what users have made the same selection (A, B and D: it can be in the same order or not). Is there any mysql function to do this. What is your suggestion for resolving this problem?
How To Detect Circular Reference/relationship With SQL
What's the common SQL code used to detect circular reference/relationship. E.g. This simple category can add other other category as its children or set other category instance as its parent.if there is a select clause that can detect if descendants of a category instance has the category instance's parent as its children. CREATE TABLE category ( category_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, parent_category_id int(10) NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, description VARCHAR(1000), PRIMARY KEY(category_id), CONSTRAINT UNIQUE(parent_category_id, name) ) TYPE=InnoDB; Thanks, Sam
Just Installed 5.0.27.
I didn't know where to go next after my Linux installation, so I just typed: chown -R mysql:mysql /var/lib/mysql ..then from root, I typed: /usr/bin/mysqld_safe ...and the terminal proceeded to look like this: [root@localhost ~]# /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql ...and the cursor disappeared. The terminal cursor stayed disappeared (and probably would have all day) until I typed <Ctrl+Z>: [1]+ Stopped /usr/bin/mysqld_safe [root@localhost ~]# ...and that's where I am thus far in my Linux usage of MySQL. Question 1: Am I on the right track? Question 2: Is there a better way to handle this?
How Do I Know If My Sql Is Installed?
i had someone wo installed mysql in mu comp, he worked with it and added tables and so on. i'd like to know how i can know whether my sql is working or not. how can i add new tables on the data base?
Installed
I downloaded 4.0?? yesterday. I installed it, set it up all that.. I'm running windows 2003 Server Enterprise, Everything is defaults. I created a couple databases and a few tables with fields... I can see them in the Mysql query box, but when I try accessing the database with my php website, nothing happens, no errors, nothing.php works fine, After retreiving the database script, no other script will work after that.
Installed Version Number
Installed mysql 5.0 (server,client dev, etc.). After doing mysql --version, I get this weirdness: mysql Ver 14.7 Distrib 4.1.13, for suse-linux (i686) using readline 5.0 I don't know what a readline is. Do I have 5.0? If so, why does it say 4.1.13? I think that's the old version. Then, YaST tells me I have two versions: 4.1.13-3.2 -i586 installed 4.1.13-3-i586 available (older) What's the difference between installed and available? What happened to my 5.0 that I installed?
Libmysqlclient.so.10 Is Needed By (installed) Mod_auth_mysql-1.11-12
Redhat 9.0 Mysql 3.23.56 ==> Running I want to upgarde to 4.0.13 but this is the error it says: [root@localhost downloads]# rpm -Uvh MySQL-server-4.0.13-0.i386.rpm warning: MySQL-server-4.0.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12 libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3 libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17.2 If i install with -i will it install with the backward compatibility, it should not break those dependencies.
MySQL4 Installed But Mysqladmin Prevents Me From Making Changes...
I've been using MySQL 3.23 for a number of months - I've got familiar with the everyday stuff (read/write/sort) but access or grant management still remains foreign. After a recent hack attempt on my server, I decided to be safe and re-install everything (its a LAMPhp server on a SuSE 8.1 box). Everything looks fine with the exception of my MySQL installation. I am installing it via an rpm - I've tried using both version 3 and version 4 but both give me the same problem. When I install the server and client, and then execute the following on the server # /usr/bin/mysqladmin -u root -h 192.168.1.3 password elephant I get the message error: 'Host 'stanley.mydomain.com' is not allowed to connect to this MySQL server. I have two network cards on the box (192.168.1.3 ad 192.168.1.2). I've tried using each of their IP addresses, and localhost, but none seem to work. I had a previous working version of MySQL Control Center on my WinMe box which I have also tried to use, but it has started to fail during bot with the message "Mysqlcc has caused an error in QT-MT312.DLL. Mysqlcc will now close." This error repeats even after a reboot or re-install. Can someone advise me as to how I can proceed as this is the only thing that is holding me up from continuing with my project work... Please share via newsgroup for all to learn as I note there seems to be frequent posts with regards to access problems... I'd prefer to stick with latest production version 4 (though I have no problems rolling back to 3.23 if need be).
Versions
I have MySQL 5.0.24 installed on a XP Pro SP2 PC. The latest version is 5.0.41. I looked at the change logs and they say they are bug fixes only. Have there been any security issues with 5.0.24 that I should be aware of? Do I need to move to 5.0.41 to be safe?
Run 2 Versions
Is it possible to run both MySQL 3.23 and MySQL 5, at the same time on the same machine with php4.3.0 and apache 1.3.27? What should I consider ?
Two Versions
I wanna run MySQL 3.23.54 and MySQL 5.0 in the same Redhat Linux 9 box at the same time. Is it possible?
Differences Between Versions
We have two versions of mySQL running; version 4.1.15 on a couple of local machines under Windows XP Professional and our public database running 3.23.58 under Apache. I was populating a new field in our members table based upon a match to a table called region using the following query UPDATE members,region set members.FPosition_Id = 19 where region.Region_Commodore_Id > 0 and region.Region_Commodore_Id = members.member_Id The query ran fine locally (ver 4) but gave a syntax error on version 3. Is there a list of differences/updates between these two versions? Does version 3 not support update queries using multiple tables? I tried parenthasizing the where statement but that made no change.
|
TRACKER
