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?
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
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.)
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.
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?
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?
Update Query Fails In Previous MySQL Version
The following query runs fine on my development server (v4.0.17): "update user inner join events on user.username = events.username set user.LastMessageDate = '$current_time' where events.text_sent=0 and events.to_mobile >0 and events.GMT_event_send_time<='$send_time'" but fails on my production server running v3.23.56. Anyone any ideas why it doesn't run and what I need to do to fix it?
Mysql Is Giving The Previous Month, Not This Month, Strange!
PHP Code: $myquery = @mysql_query("select year(sendon) as yr, month(sendon) as mth, count(*) as hits from ebook_user group by yr, mth"); while ($myrow = mysql_fetch_array($myquery)) { $mymonth = $myrow['mth']; $myyear = $myrow['yr']; $myhits = $myrow['hits']; print '<td bgcolor="#E7E7E5">'.date("M", mktime(0, 0, 0, $mymonth, 0, $myyear)).' '.$myyear.' </td><td bgcolor="#E7E7E5"> '.$myhits.'</td>' } The above code is printing the previous month instead of current month ... can any one help?
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?
Select Previous And Next Id After Id=# ?
For a gallery I'm trying to query for a picture by its id and also get some images before and after that id (according to current sort) are there references like DOM previousNode or stuff like that to use in the WHERE statement? Or how could I do this? Currently I have: ($picId is a php variable) '(SELECT id, picUri, picUriSmall FROM pictures WHERE id < '.$picId.' ORDER BY id DESC LIMIT 2) UNION (SELECT id, picUri, picUriSmall FROM pictures WHERE id = '.$picId.') UNION (SELECT id, picUri, picUriSmall FROM pictures WHERE id > '.$picId.' LIMIT 2)' This works but doesn't seem to be the best way. I want to be able to have it working for other sorts than by id. And the two first images gotten by this query will be in reversed order (can be fixed in php). Is there a way to ask for my picIDs position in a query and then use another query to make the LIMIT 10,14 if my image was in position 12?
Paging With Only Next/previous
I'm running PHP + MySQL (innodb) and in some pages, the paging is slowing down the system a lot. Now I've seen on some sites that have paging implemented in an interesting way. They only let you go forwards and backwards one page at a time, and some don't even tell you how many results there are. For instance if you look at google search results, they only says "about XXX results". Plus they never actually let you jump to the last page. I'm thinking of implementing my system this way in certain pages as well, to cut down on the load times. However, I'm exactly sure how that cuts down the load. Can someone shed some light on this?
Previous To Last With A Certain WHERE Condition
How do i fetch the previous row record with the same WHERE when the last record has only a lately date. for example field CConsorcio CRubro ImporteA FechaA 1 105 1000 2006-05-10 2 110 30 2006-05-12 5 105 300 2006-05-13 4 104 600 2006-05-14 2 103 800 2006-05-15 the WHERE CConsorcio=2 the last record: 2,103,800,2006-05-15 and i want to select the row: 2,110,30,2006-05-12
Using Data From Previous Row
I only want to select the current row if a field in the previous row is not null. Is it possible to write such a query?
Previous Record
I need to get a previous record from database - i need to retrieve records which differs from the previous one about 5s example: select eventDate,previousEventDate,eventDate-previousEventDate as delta from events having delta<5 order by eventDate; eventDate is normal column from table previousEventDate is an "alias" for the previous date ... how can I write it in SQL? Please help. I can use SELECT as subquery, but it would be probably really slow, the table will have 100000s maybe milions of records soon.
Previous Row Comparison
I have a table in this format: Column A | Column B 1 | 2 1 | 3 1 | 4 2 | 5 ..... ..... What I want to do is something like this: If in Column A there is a change in the number i.e. from the above table there were many 1s which transitioned into a 2. I want to record this change. I want to extract these two rows into another table. How can I make this possible?
Get Next And Previous Records
Our website has a portfolio database which uses a column entitled 'list_order' to set the order of how we want the projects to display in a list. Each project has a link to click into it to see the full details of the project. Inside this details page we would like to add a View Previous Project and View Next Project link which would allow the user to navigate through our projects. The problem is that we are using an order set by 'list_order' and not an auto incremented column. How would I setup the Query to grab the previous and next rows no matter which project the user clicked on? For example, our database has these records: id - list_order 102 - 100 89 - 200 7 - 250 30 - 300 97 - 400 20 - 500 62 - 600 88 - 650 103 - 700 85 - 800 112 - 900 95 - 1000 So, if someone clicked into id 97, we'd need a query that would grab id numbers 30 and 20 for the previous and next id to create the links.
ID Of Previous Insert
Im thinking i need a transaction here. I want to insert a record into a table, which has an autoincrement field as the primary id. Then use this id to insert into another table. In the time between the first insert and then getting the id, couldnt there possibly be another user that causes an insert and hence the id the first user gets back isnt correct ?transactions to the rescue ?
Subtract Previous Value.
I'm trying to get one column of numbers to subtract from another column and to keep a running total. Column A is a dollar amount from an invoice. Column B starts out with an opening amount ($10,000) and I want to have Column A to subtract from that. Code: COLUMN A--------COLUMN B $0.00 $10,000 $1000 $9,000 $500 $8,500 $2000 $6,500
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.
Versions Of AMP On Windows?
I am somewhat concerned that i have the right versions of AMP on my Win XP system so it will all work together... Is there some link that (in simple terms!) tells which versions are safe together? I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php 4.3.10. Is this the best combination?
Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2. Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared! I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.
Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use and code in lots of other languages. When doing a bit of survey I find many many versions of commercial and public versions of sql. Can anyone tell me if the syntax is generally similar or are they completely different. If I invest time learning mysql on XP or Linux will that be useful if I end up using something like Oracle later on? The only one I would avoid is MS.... like things that work occasionally.
Removing Old Versions
I loaded a new version of Mandrake Linux 10.0 CE and have also installed and dowloaded a new version of MySQL 4. I'm not sure but think I have several versions installed and running ... How can I check to see what is installed, what is currently running, and then perhaps remove them all and start by installing single new copy?
Compatibility Between Versions Of SQL
Hi! Would like to enquire if different versions of SQL are compatible to one another. I've done some code in PHP and which requires access to MySQL on my server. I have tested it on localhost and everything worked fine. Hence, i decided to upload both my code and the database i created to the server. That's when the prob started. I received this msg while trying to view my page: Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) what this is about? For info, my MySQL version on my personal computer is 5.0 while that of the server is 3.23. Are the database compatible?
Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use and code in lots of other languages. When doing a bit of survey I find many many versions of commercial and public versions of sql. Can anyone tell me if the syntax is generally similar or are they completely different. If I invest time learning mysql on XP or Linux will that be useful if I end up using something like Oracle later on? The only one I would avoid is MS.like things that work occasionally.
Get Previous And Next ID Of Current Record
I want do create a "Previous" and a "Next" link, all I have is the ID of the current record. Is there a good way to get the previous and next id of a record with a single SQL Query? example: ID's: 4,10,7,9,13 I open my page and show all details from the record with the ID 7, now I want to create the links and I need the previous and the next ID, 10 and 9. I could make a query that returns only the ID's and loop through the recordset till i have my ID's but that's such an ugly solution, not to mention the performance issues.
Phase Previous And Next Record
I want do create a "Previous" and a "Next" link, all I have is the ID of the current record. Is there a good way to get the previous and next id of a record with a single SQL Query? example: ID's: 4,10,7,9,13 I open my page and show all details from the record with the ID 7, now I want to create the links and I need the previous and the next ID, 10 and 9. I could make a query that returns only the ID's and loop through the recordset till i have my ID's but that's such an ugly solution, not to mention the performance issues.
Previous And Next Record Delimma
I have a main page that has a query to get all my clients in alphabetical order. "SELECT * FROM clients ORDER BY cname ASC" This obviously mixes up their IDs. So when I click on a client's name "Goofy" (id = 6), I need the next client "Mickey Mouse" (id = 2), and "Donald Duck" (id = 9) to be the previous client. And I would prefer this to happen on the same page where it displays my client's details rather than have to put those vars in the URL. To get my client, it's simply: $client = $_GET['c']; "SELECT * FROM clients WHERE clientid = '".$client."'"
Getting Next, Previous Record After INSERT
When I insert a record in a given index order I want to be able to traverse to the previous or next record of that index order, before or after the one I inserted. So for example if I insert a record with an address of "20 Heather Court" using an address index order, I want to be able to push a Next button (on a Web HTML form) to go to the record corresponding to "21 Heather Court" or, if I press the Previous button I I want to be able to go the record corresponding to "19 Heather Court". Assuming of course that both the Next and Previous records exist before I insert "20 Heather Court". If I change the index order to customer first name and insert a new record for a customer named "Harry" I then want to be able to push the Next button and see the record for a customer named "Jan" or if I push the Previous button I likewise want to pull up the record for a customer named "Garry". Assuming that the records for Jan and Garry already existed before I inserted the one for Harry and that they became the Next and Previous records with respect to Harry's after the insertion. Using an auto increment field does no good because every time I change the index order any kind of sequential relationship between the values in the auto increment field gets totally messed up. I have also tried statements like " SELECT * FROM Customers WHERE Customer_ID <349 ORDER BY `Customer_ID` ASC LIMIT 0 , 1" without success if there are 10 records before the one with a Customer_ID of 349. A LIMIT of 0,1 will start at record 0 for only 1 record. I want to pull up the record immediately preceding the one with a Customer ID of 349. In short is there some way to tell which record is Next or Previous to one that I insert under a given index order?
Subtracting Current Row From Previous
I am trying to create a query that will subtract the current row of a column from the previous row, and if the value is negative, just return the value of the current column in the result column. For example, if I had the table below, here are the results I would like to see: Key value REQUIRED RESULT 1 12 12 2 21 9 3 3 3 4 1 1 5 67 66 .
Previous Version Coding
I am trying to load some sql into myphpadmin and whilst I believe I have a later version of 5.0 which is causing the error (as this coding is apparently up to version 5.0), can someone suggest how I go about finding the coding to use with my version? Here are some of the errors: CODESET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
Determine Previous Month
basically I need to display a list of "unpaid" statements for the previous Month, no matter what day the search/request is made on. I know MySQL has the DATE_SUB function where I can subtract 1 Month from the current date, but will that subtract the date exactly 1 month to the day ? Or will it simply give me the Month as I need ? What happens if the search takes place on the 31st of a month (for example: July), yet the previous month only has 30 days (June). Will it roll back to the previous month correctly or think that the date is 31st June or try to roll back further until it finds another month which has 31 days ?
How To Keep Trace Of The Versions From A Table
From the Code that is been written below i need to keep trace of the versions that are been read from the file(test1.lst) each time it is been changed.Does anyone know as to how i can store it in diff tables(version_0701151004 version0701151100,version_0701161000 ....versionYYMMDDHHMM) each time when this query is been called? n how to keep trace of the date and time ? or maybe is there any other method where i can store diff versions in diff files ? would be gratefull for any advice --DROP TABLE stocklist_values; CREATE TABLE stocklist_values( SAG_FREIGABE INT(1) NOT NULL, SAG_SNR VARCHAR(50) NOT NULL, SAG_NAME VARCHAR(40), GSM_RELEASE_VON VARCHAR(20)); LOAD DATA INFILE '/home/user945/database/test1.txt' INTO TABLE stocklist_values FIELDS TERMINATED BY '&'
XAMPP And MAMP Versions
I'm running an XAMPP version of mysql on a PC and the MAMP version on a Macintosh. I just realized that I needed to change a couple of tables. Can I change them on the MAMP version and then copy the appropriate files to the XAMPP version, and expect them to work? Which files should I copy over ... .MYI, .MYD or both? The MAC version is 5.0.19 The PC version is 5.0.27 I use Navicat to modify my tables on the mac and do not have this product for the pc.
Import Export With Different Versions
I am hosting a WP site locally on my computer, to test it before putting it online, Now I have the hosted WP site online & ready to go, but I am having trouble loading the backup data from my computer into it. When I go to import in the myPHP section, it gives me an error message of: Import failed, You probably tried to load too big a file. But the file is only 350kb! The max is 8Megs! Double checking, it looks like the 2 databases are different versions. Would this be the problem? If so, how do I go about downgrading the version on my computer? And once done, how would I transfer my posts & info onto it?
|
TRACKER
