MYSQL :: Rolling Back A DB From Version 5 To Version 4

Updated Table Fields Rolling Back After Update
I'm having to correct some scripts written by a collegue who is presently not around. I had to update 2 fields with over 13000 rows. The update do work well but the problem is that somehow, the initial values in the fields do roll back in again - kind of auto updating to the former values itself. Any ideas what could be wrong? Any way round it?

Install New Version Of Mysql With Old Version Running
I would like to install the new versin of mysql but currently i have mysql version 3.23 running...

I need to have 2 version of mysql running at the moment in win2000 for different app.

what is the steps for me to install the new version of mysql without causing error and able to run concurrently.

Version 3 And 4 On Same Box
I have a box that is currently using Version 3.23 of MySQL. I want to install a version 4 along with version 4. This will be running on a windows machine. Does anyone know if this is possible or will it cause problems for the already installed version 3?

Will any shared dlls be over written for example?

Version 5 To 4
We did some work on a mysql DB version 5. We now need to put it on the live server. However, the live server runs version 4.
IT does not want to put two versions on the server and will not upgrade to version 5. If I try to create a backup using compatability mode i get MySQL Error Nr.0
what is the best way for me to be able to get this database converted to a version 4 compatable instance.

Version Of PHP
suggest me that which latest versions are best and work properly with each other without having lots of problems.

Version
HOW TO FIND THE VERSION OF MYSQL IS BEING USED IN SYSTEM?
i AM USING "FEDORA CORE 3 " AS OS.

Version 5
I have a new application I'm working on and it would be *so* much simpler to have views available. Is anyone using 5.0 extensively and able to comment on its stability? I'd have to put some non-mission critical but still production databases into 5.0 and I don't want to have my data wandering away

Version
I tried to upgrad mysql v4.0 to v4.1 through cpanel/WHM and my user account cpanels are still showing the version as 4.0.25. How do I check which version is actually on there

Version 3.51. To 4
i just installed over the top, is this ok???? coz i have now 2 unistall options in windows install/unistall panel

Version
MySQL 4.0 or MySQL 4.1?
MySQL 4.1 supports subquery but it is still a beta version.

Version 5.0
I have MySQL version 5.0.17-nt installed in my localhost testing environment. I have run into a problem installing some software that uses MySQL. The software people have only tested their software with version 4.0.18 and nothing later.
Is it plausable that the software tested at version 4.0.18 has some incompatabilities with MySQL version 5.0.17?
If so, is there anything I can do (configuration, etc) with my version 5.0.17 server to smooth out these wrinkles?

Version 5.0
mysql version 4.1 has been in production status since october, 2004
if you're not on 4.1 yet, and you post a problem and wish to receive a solution involving sql, it is your responsibility to mention which version you're on
otherwise, you might get a solution using sql that works only in 4.1

Version 4
I have been trying to change the query below to work in version 4.0.x of MySQL (it works in version 5).

Code:

SELECT *
FROM Categories
WHERE Cat_ID NOT IN (SELECT DISTINCT Join_Cat.Cat_ID
FROM Join_Cat WHERE Join_Cat.Comp_ID = 1)

(The above returns all 'Categories' a 'Company' is not in)

New Version
I was using a previous version of MySQL before.(4.0.21) Then I downloaded version 5.1.2. I use the Windows Version for Windows 2003 server with ASP codes. What I was basicly doing is using forms to enter new info to the database and editing them by form again. On the editing page I was bringing the current values to the forms by giving the default values of the fields ( ors.Fields("propname").value ) But with this last version I have problem. It brings only the first word of the record to the form field. I could not understand why.

Version Problems
I'm getting the following error and I have 5.0.21 on my server.
CREATE TABLE cms_bbattachments_desc(
attach_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
physical_filename varchar( 255 ) NOT NULL ,
real_filename varchar( 255 ) NOT NULL ,
download_count mediumint( 8 ) unsigned DEFAULT Ɔ' NOT NULL ,
COMMENT varchar( 255 ) ,
extension varchar( 100 ) ,
mimetype varchar( 100 ) ,
filesize int( 11 ) DEFAULT Ɔ' NOT NULL ,
filetime int( 11 ) DEFAULT Ɔ' NOT NULL ,
thumbnail tinyint( 1 ) DEFAULT Ɔ' NOT NULL ,
PRIMARY KEY ( attach_id ) ,
KEY filetime( filetime ) ,
KEY physical_filename( 0 ) ,
KEY filesize( filesize )
);
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near Ɔ),
KEY filesize (filesize)
)' at line 14
The link to the whole sql file is
http://cmuench.com/sql.sql
It was version 4 and it won't let me insert it in a version 5.0.21

Using Mysqldump On Version 3.23
I need to upgrade my company's version of mysql. I'd like to backup the databases (20+) before attempting that, however when I try to use mysqldump nothing happens.
I've tried the following command line code to test out backing up one database, but nothing happens... no error or anything........

Version Conflict
I've created a stored proc using MySQL Administrator Ver 1.1.9 which runs fine in MySQL Query Browser 1.1.20. However, when I use it in a C++ program it gives me the following error:

[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds t
your MySQL server version for the right syntax to use near'{0= call 'GetAllJobDetails2'}at line 1.

The first line in the stored proc is:

CREATE DEFINER=`regan`@`localhost` PROCEDURE `GetAllJobDetails2`()

That is what the MySQL Administrator put in when I created it.

How To Get The Version Of The Mysql?
There is a running mysql on the server. But I don't know its version. I can logon on the server and have all accounts. And Can anyone tell me how to know the version of the mysql.

Version Conflict
This works perfectly in v4, but in v3.23 it throws a syntax error. I can't see what it is at all...

SELECT DISTINCT page_system_name
FROM page_data JOIN menu_data ON menu_data.menu_group = page_data.menu_group
WHERE page_hidden = 0
ORDER BY menu_data.menu_group_display_order, page_data.page_display_order

Version Selection
I am wanting to perform a fresh install of mysql on Fedora Core 6. I am assuming the Generic RPM package is best, but not sure whether to use the static or dynamic linked version.

What Version Do I Download?
i'm brand new to databases and want to download mySQL to practice with, i.e. some of my coldFusion tutorials require a database to complete. also, we use mySQL5.0 at work and i thought i should get a little familiar -- get my hands dirty. i know i have access to one with my hosting company for my site but would it behoove me to download a copy locally? what would be the advantages?

then, what version do i download? i have a dell desktop pc with windows xp. should i download the windows version instead of the linux?

Is Version 5 Ok To Install?
I am currently using MySQL 3.23 for a live web site. I have new
queries that need UNION provided in v4.0.0+. It's a simple db with 5
tables and doesn't perform any e-commerce type transactions. All of
the 7 tables are of type MyISAM. So I have to upgrade MySQL on the
live server.

Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application
is simple - is version 5 safe? My guess is that the core of the
server engine would be much the same for simpistic queries?

What are other people experience and thoughts on this? I understand
that safest would be version 4, then 4.1, then 5 - however it would be
nice to have 4.1's ability to do subqueries and derived tables.

Version Questions
My first question is about which version of MySQL I should download. The server my site is on is running version 3.23.49. I would like to install MySQL on my PC to learn with and to work on prior to uploading to my site. Do I need to load the same 3.23.49 version on my PC?

Download Version 4.1.23
I've just downloaded the latest version for Windows 98/ME from the v4.1 download page..
That was version 4.1.22, but when looking at the changes in new versions, it says that v4.1.23 has been released and has many bugfixes in it.. so why isn't that version available as the latest download? ..instead of having to install 4.1.22 then having to do updates?

Now I know v5.0 and upwards is recommended, but they require w2000 or XP and up, which I don't have and can't afford right now. So leaving that aside, anyone know the reason for the latest release of 4.1.x not being on the appropriate page?

Version Number
I know it must be really simple but at the command prompt what is the correct syntax to find out what version of mysql is running.

Version 5 Install
I am currently using MySQL 3.23 for a live web site. I have new
queries that need UNION provided in v4.0.0+. It's a simple db with 5
tables and doesn't perform any e-commerce type transactions. All of
the 7 tables are of type MyISAM. So I have to upgrade MySQL on the
live server.

Q: Do I install to 4.0.12, or 4.1, or 5.x ? Because the application
is simple - is version 5 safe? My guess is that the core of the
server engine would be much the same for simpistic queries?

What are other people experience and thoughts on this? I understand
that safest would be version 4, then 4.1, then 5 - however it would be
nice to have 4.1's ability to do subqueries and derived tables.

Mysql Version
I want to use mysql clustering,could suggest which version of mysql
server include this function ? 4.0 or 4.1 ? binary version?

Ms Version Of Rst.movefirst
I need to spin a recordset twice for two different HTML outputs. how do you move the array back to the first record so the second 'do while' can be performed again?

Which Version Is Loaded
I know I'm using a variation of 4.0 But I'd like to know which specific release I have loaded.

How can I discover this information?

Which Version To Install
I've got a book to teach myself MySql and i need the software.
when i go to the website there are so many different versions to download. Which one should i use?

Older Version
is it possible to get older versions from the mysql.com website? I have been looking but can't seem to find any. The mysql version i am looking for is 4.0.15a.

Version Question
what does the word 'log' means in the version descripction 'MySQL 5.0.20-max-log'.

Mysqladmin Version
Hi, had a problem with work in mysql, server should be up, cause ps give

debian:/etc/mysql# ps -x |grep mysqld
Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
904 ? S 0:00 /bin/sh /usr/bin/mysqld_safe
940 ? S 0:00 /bin/sh /usr/bin/mysqld_safe
942 ? S 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld

but when i give mysqladmin version i have

debian:/etc/mysql# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
debian:/etc/mysql#

what's going wrong?

Version Of MySQL
which i suppose allows one to download the mysql 4.1 file for windows.i have windows xp pro on my pc.but under this heading "Windows downloads (platform notes)"
on this page, there are 3 files for windows namely Windows Essentials (x86),Windows (x86)and Without installer (unzip in C:).i was wondering which one to download for a starter like me.

4.1.18 Pro Version Install
I have been working with an install of MySQL on a MacOS 10.4 server. I need to have the Pro version installed of MySQL. I have purchased a MySQL network account and am able to download and install the pro version 4.1.18. However in my MySQL Administrator when viewing information it is displayed that I am running MySQL server version 4.1.10a (is it not supposed to also state that it is the Pro version here?) and my client version is 5.0.xx. What gives that neither of these versions match 4.1.18? I have reviewed the install in the /usr/local/mysql directory and all seems correct and my symbionic link appears to point new my version 4.1.18 install.

MYSQL Version
what version of mysql could you recommend to use trigger, and procedure? Is it free?
I am also looking for best tutorial in trigger and procedure exclusive for mysql, can you provide links?

Install New Version
I would like to install the new versin of mysql but currently i have mysql version 3.23 running...I need to have 2 version of mysql running at the moment in win2000 for different app.what is the steps for me to install the new version of mysql without causing error and able to run concurrently.

MySQL Version
My host is telling me that MySQL 4.0.14 is installed on the server. Yet my phpinfo() is saying my Client API version is 3.xx.xx (http://www.aaron-wright.com/info.php)

Can anyone explain to me what he's talking about? All I know is that nested queries aren't working, and I need 'em to. You guys know of perhaps a switch in a config file that needs to be thrown? And apparently v4 supports query caching or something. How would one enable that?

Community Version
I'm trying to download MySQL Community Version but all I can find to download is the server version. Can you tell me what version I should be downloading and where to find it.

PHP Version 5.0.2 MySQL 4.1.7
I am trying to connect from PHP Version 5.0.2 on Windows 2003 Server an IIS to MySQL 4.1.7 but there is an authentication problem.
When I run the following PHP script...

<?php
$connection = mysql_connect("localhost","root","password");
?>

The message I get is...
"Client does not support authentication protocol requested by server; consider upgrading MySQL"This seems to be a problem with MySQL 4.1 because I can get it to work perfectly well with MySQL version 4.0.13

Linux Version
I have a need to setup a MYSQL cluster, however, I do not have ANY experience of Linux and you cannot set up the cluster on Windows currently.

I learn fairly fast, but would like someone to recomend a version of Linux that would happliy support the MYSQL cluster and also has some good installation instuctions!

Earlier Version
I recently downloaded a freeware search engine script from http://www.php-development.ru/php-scripts/search-engine.php that ran perfectly on my local server, which utilizes PHP v. 5.1.1 and MySQL v. 5.0.18. I also ran this script on a remote server, which utilizes PHP v. 4.3.11 and MySQL v. 4.1.18 and it also ran perfectly on that.

But, when I tried to run it on a different remote server, which utilizes PHP v. 4.3.3 and MySQL v. 3.23.56 it did not run and I received the following messages when I tried to search for the word 'rotolo,' which is someone's name.

Replacing Version 4.1.11
I have a Linux Box that I installed Fedora Core 4 on which came with MySQL 4.1.11.
I have not yet created any tables so I just need to replace it with the newer version since I want to be able to use some of the new features. The question is - what do I need to do to - do I need to remove any files or uninstall the older version?

Mysql-3.23.56-Max And Non-max Version
I recently upgraded my machine to SuSE 8.1 and went about getting all the
rpms I could get related to MySQL and install them.

I did notice that unlike before, I have a "max" version of 3.23 running and
I'm 99.99% sure this was not the case with my previous version (an earlier
version of 3.23).

What is the difference between the max and non-maxed version... I've not
found any info on it

Minimum Version
Moved to a new job and now I'm working with MySQL however they're using an older version (3.23, I believe) which doesn't support sub queries and doesn't seem to support EXISTS either. I was wondering what the minimum version is that supports these syntax.

I'm looking for the minimum version because hopefully, I'd like to have them avoid any possible licensing issues with the newer versions.

Mysql 5 Version
I am trying to run Mysql 5 on fedora. I copied the zip files and tried running following command to start the server:
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

But geting the error:

[root@varun mysql5]# Starting mysqld daemon with databases from /data/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060116 04:31:00 mysqld ended

I already have mysql 4 installed and running successfully.. To start with mysql 5, I stopped mysql 4 and executed commands for mysql 5 (as mentioned above).
While I was able to run it successfully on my local linux machine but not on the server machine (fedora)

MySQL Version
I'm wondering if there are procedures anywhere for DOWNgrading a MySQL
database to a more stable version. I'v recently upgraded to
4.1.3-beta and was hoping to roll back to 4.0.20 production. I'm
seeing to many spurious problems at the beta level (which are to be
expected given its status).
Finally, could anyonw hazzard a giess as to when 4.1 may become the
stable production release>

New Version Of Mysql
mysql is a free software.Its new version is often released.
But I wander who control the relase.And how one programmer join the
development team?

Version Of Mysql
I've been asked to take a php/mysql web app and somehow make the database available to the client on their laptop, when they don't have an internet connection.
They want some sort of Windows front end for editing the data. Not simply the control center, since the client isn't very computer literate. Something more like Filemaker.
Even worse they want to be able to merge the "offline" database back into the online database, which probably has changed since "offline" version was captured.
Anyone have any ideas...preferably something pre-canned and quick to implement, since the boss believes "this is a simple task and shouldn't take more than an hour or two to throw together".
I'm leaning towards just intstalling the whole web app on their laptop (apache/mysql/php), but I have no idea how to merge the data.