Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MYSQL


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Upgrading MySQL On Linux Server


I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting.

I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.




View Complete Forum Thread with Replies

Related Forum Messages:
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to
connect to database
I used different GUI like "Toad for MySQL"
in connection page I put Linux IP address as "Server host" and
username/password I keep getting error:
Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061)

My question is: Do I need a client installation or configuration on Windows
machine?

View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it.
When i try to connect the ODBC allways returns the following error:

[MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001)

I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc...

The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.

View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net.

Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine

So please tell me process

1 have to simply upload my mySql database in Public Html folder or else where
i m using cPanel file manager to upload files

View Replies !
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0
machine. The installation was succesfully, but now I can't start the
server. I think the right command is mysqld_safe --user=mysql but
during the starting procedure the server shutdown, it reports:

[root@psiche root]# mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/lib/mysql
040525 09:32:25 mysqld ended

If I try to rebuilt the grant tables using the mysql_install_db it
reports some errors: "asked for 196608 thread stack, but got 126976"
and "to start mysql at boot time you have to copy
support-files/mysql.server to the right place for your system".

View Replies !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux )
WHM 11.11.0 cPanel 11.16.0-S18450
REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0

after update apache then all websites on server can not connect mysql
from WHM > Tweak Settings > Mysql > 5.0
and used old style (4.0) passwords with MySQL® 4.1+

also command /scripts/mysqlup
but no way still same error can not connect to Mysql

View Replies !
Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?

View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system?

I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator.

Basically, I got caught up in a loop of incompatable modules:

# rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm
warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b
error: Failed dependencies:
perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1
MySQL conflicts with mysql-3.23.58-16.RHEL3.1
Suggested resolutions:
/var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm

If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm.

I will gladly read the "manual" or docs, and would love a pointer to them.

View Replies !
Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client In
I have recently upgraded to MySQL 5. Got this error message in my IE Browser. Have read some of the comments on other forums and my choices are: Upgrade all client programs to use a 4.1.1 or newer client library, or

SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd')

Can someone please advise?

View Replies !
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error.

Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?

View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup.

The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information.

I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration.

I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.

View Replies !
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.

View Replies !
In My Linux Server
What is the default server SQL mode when My SQL 5.0 is installed? Is there any available modes.

View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server.

If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields?

In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names?

Or do they matter?

View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error.

[MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server

Is it likely that the windows-linux combination is causing a problem here?

View Replies !
Exporting Database From A Linux Server
the following query:

mysqldump web15db1 > sql.dump

where web15db1 is the name of my database.

And i get a syntax error:
Quote:

View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located.

I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side?

I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit.

But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts?

I'd like it to be command line, so it can be run from another application which would then run this from a shell.

View Replies !
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql.
The file contains around 30000 data but after i've typed:

mysql> source /xx/file_name.sql;

Table of the sql file is created but contains no data. But it poped an error notice without any message:

ERROR: <----like this

the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?

View Replies !
Mysql Upgrading From 3.23 To 4.1
I have linux RH AS 3 server with these installations:

#rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-5
mysql-3.23.58-1
mysql-devel-3.23.58-1


How can I upgrade to mysql 4.1 ? Should I try uninstalling the above first
with all their dependencies or should I do a FORCE upgrade over it ?

View Replies !
Upgrading To MySQL 4.0
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.

What are the main advantages of upgrading to 4.0? Speed? Features? I can go
through the whole changelog if need be, but I'd prefer to hear what actual
users are reporting as far as benefits and disadvantages.

View Replies !
Upgrading To MySQL 5.x
I wish to upgrade my version of MySQL (currently stuck to version 3.23) and I am wondering if to upgrade to the most stable 4.x or 5.x version. I am concerned about any possible retro-compatibility issue with SQL queries written for the 3.x version. In particular I am inquiring about:

1. Is there any incompatibility issue between the very latest stable 5.x version and SQL queries written for 3.x MySQL versions?

2. Is there any compatibility issue with PHP 4.x or PHP 5.x ?

View Replies !
Upgrading Mysql From 4.0 To 4.1
i'm trying to upgrade mysql from 4.0 to 4.1. mysql_fix_privilege_tables reporting 'Access denied' and man says to use root pass as argument. so how to use it? '$ mysql_fix_privilege_tables -ppass' doesn't work

View Replies !
Upgrading MySQL - How To?
I'm having a hard time figuring out how to upgrade to MySQL 4.1 on my FreeBSD server. I've been trying to use the ports, like I do whenever I upgrade all my other software. The install runs without any problems, but the MySQL binary (in usr/local/bin) is never replaced with the new version.

Does anyone have any advice on how to go about upgrading to 4.1 on a FreeBSD server. Am I missing something? Can you point me towards any good articles on how to go about doing this?

View Replies !
Upgrading To Mysql 4.1
I have just upgraded to mysql 4.1...which is great...what isn't great is that it's not working. I keep getting an error message when I try to start it that it cannot find 'localhost'. My last version was 3.23 and I had no problems at all getting it to work.I've gone through the help file and changed the my.ini file and moved it to c:windows and checked everything but stil no joy...anyone had this problem and sorted it?
I'm running:

winxp
mysql 4.1
php 5.0
apache 2

View Replies !
Upgrading To MySQL 4 Or 5
A person I am working wth is running My SQL 3.23.58. He needs to upgrade, so that we can use the UNION statement, among other things, but I was wonderting if it were better to upgrade to 4 or 5. By better, I mean working well with PHP 4.3.11, and Apache 2.0.51 on Linux.
I am asking because I know there are some issues with Windows, Apache 2, and PHP 5, and I want tomake this upgrade as smooth as possible.
It seems that most web hosts are using MySQL 4 currently, so I'm guessing that is the one I should go with? It appears, according to MySQL.com, that the stable version of MySQL 4 is 4.1.20. Please let me know if there are any issues that exist with this version of MySQL and the versions of PHP and Apache I mentioned above.
Also, can you upgrade smoothly without losing your database or data? I'm going to back it up just in case, but I'm just curious to know if you can upgrade without losing data, or if the database will absolutely need to be saved and re-uploaded.

View Replies !
Upgrading Mysql To 4.0.24
I have just followed MYSQL reference manual 2.3.15 to upgrade mysql from 4.0.20 to 4.0.24. Everything appeared to upgrade correctly, but the version is still showing 4.0.20. I have searched everywhere for documentation that would point out my error, but have been unable to find the solution.

View Replies !
Upgrading From MySQL V3 To V4
I have MySQL datbase running on a Mac Powerbook with MySQL v4.1.14 installed (upgraded from v3).
I cannot get the syntax correct when trying to SELECT a record that meet a predefined criteria.

$query = "select * from members where member_ID = $ID and cat = type_ID";

I get the following error message:
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 'and cat = type_ID' at line 1

This SQL query works in phpMyAdmin (when I specify the 'member_ID' and 'cat' numners:
select * from members where member_ID =1 and cat = 5

It seems that the $ID and type_ID variables have no values when trying to execute the $query.

View Replies !
Upgrading MySql?
I have MySql installed on Win2k Pro. Recently I downloaded the latest version of MySql, wanted to upgrade the previous alpha version.

So any one here can help me guide to upgrade MySql, step by step, so that I do not loose any of my current MySql settings and databases.

View Replies !
Fedora C3 And Upgrading Mysql 3.23 To 4.1
How do I upgrade the standard version of mysql on FC3, 3.23, to 4.1 ? I already looked up some info on the internet, but it isn't quite clear to me.

I can backup my data, it isn't that much, just personal stuff. Do i just rpm the client and server, first 4.0 and then 4.1 or do I have to give special options with the rpm command ? Will this affect my webserver ? Do I have to adjust settings for apache or
PHP ?

View Replies !
Error Upgrading MySQL
I began preparations for upgrading MySQL. I downloaded the binary RPMs for
Red Hat Enterprise 4 (we're running CentOS, a clone) for MySQL 5.0.13 from the
MySQL AB web site. Running a test, I got this:

[root@seabass ~] rpm -hUv MySQL* --test
warning: MySQL-client-standard-5.0.13-0.rhel4.i386.rpm: V3 DSA signature: NOKEY,
key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) mod_auth_mysql-2.6.1-2.2.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.6.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386


Has anyone else encountered this dependency problem? What would happen if I
--force'd RPM to do the upgrade?

View Replies !
Upgrading MySQL With RPMs
I'd like to upgrade to v 4.1 as painlessly as possible (mainly I want to avoid problems with the php-mysql RPM which requires the dynamic libraries that include 3.23.x libraries). Is there an easy way to upgrade my RPM install without breaking a lot of things?

View Replies !
Upgrading MS Access To MySQL
I am upgrading a websites database from Access to MySQL. the tables work and so do many of the sql statements all be it with a bit of tweaking but I can't find what is wrong with this one:

SELECT First(B.ID) AS FirstOfID, I.Title, Count(*) AS qty FROM B LEFT JOIN I ON B.IID = I.ID WHERE B.UID=1 GROUP BY I.Title ORDER BY I.Title;

View Replies !
Issue Since Upgrading MySQL From 4.x.x To 5.0.24
I am not sure where to begin with this, but basically my host server upgrade our MySQL version from 4.x.x to 5.x.x and since some of my scripts have changed the way in which data is drawn from the database.

It seems to be a division issue when dealing with averages it extracts the data from the database different than it has on all previous versions of MySQL and I hope someone here can help me in the direction in which to solve this.

Here are a few examples of the issue I am having....

View Replies !
Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6).

Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me.

As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.

View Replies !
Upgrading From MySQL 3.23 To 4.1 - Need To Upgrade To 4.0 First, But Can't...
I just realised that MySQL on my local server is MySQL 3.23....whoops.

I'm looking to go to 4.1 for the time being. However the manual says that in order to get there I should upgrade to 4.0 first, and then on to 4.1.

But the 4.0 download has been discontinued! So where do I go from here. A completely fresh install (not sure what effect inserting my 3.23 database SQL backup in the 4.1 database will have...nothing?)

or do I just upgrade to 4.1 straight?

View Replies !
Issue When Upgrading MySQL From Version 4.1 To 5.0
I got the following message when I upgrade MySQL from 4.1 to 5.0, and unable to continue,?

[root@wl-jzarley ~]# rpm -i MySQL-server-community-5.0.45-0.rhel4.i386.rpm
warning: MySQL-server-community-5.0.45-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.12-2.RHEL4.1.i386

View Replies !
Incorrect Key File For Table Error When Upgrading From MySQL 4 To MySQL 5
I have installed MySQL 5.0.67 yesterday. Previously we were using 4.0.

On the development server, testing server, and training server this upgrade went smooth. The only thing I did there was run mysql_fix_privilege_tables.

But yesterday, after doing this same thing on production server, something went wrong, at least with one database.

While I was in the office things looked fine. But this morning I noticed error messages like:

090119 16:29:04 [ERROR] /usr/local/mysql5/bin/mysqld: Incorrect key file for table './questionnaire/answers.MYI'; try to repair it

I tried:

repair table answers

but then I got the following error message:

090120 8:49:21 [ERROR] /usr/local/mysql5/bin/mysqld: Table './questionnaire/current_answers' is marked as crashed and should be repaired

View Replies !
Loading Database? After Upgrading Mysql Version
Although I have been working indirectly with mysql for a couple of years now, I recently upgraded from mysql v3.23.51 to 5.0.67. This is the version which is found in the latest version of LAMPP. In any event, I am atmysqlting to load a database configuration into the new version but keep getting the following error:

ERROR 1064 (42000) at line 92: 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 'Specific varchar(250) default NULL,
Disabled tinyint(1) default NULL,
Demand' at line 12

View Replies !
Upgrading MySQL - Send Mail Stopped Working
I recently upgraded my Mac (running OS 10.4.8) to Apache 2.0.52, MySQL 5.0.24 and PHP 4.3.9.

While I seem to be accessing the latest MySQL from the Terminal, Apache seems to continue to use the previous install of MySQL.

Is there some config file I need to edit so the new install of MySQL is used by my Web server?

While I'm at it, my PHP seems to no longer be able to send email, though I added "sendmail_path = /usr/sbin/postfix" to the php.ini file.

View Replies !
Steps For Upgrading MySQL 4.1 To MySQL 5.x?
I desperately searched the web for a list of steps to be followed to upgrade existing MySQL 4.1 installation to MySQL 5.x. This is the first time I am performing a MySQL upgradation and I don't know how to upgrade without losing any of the current user/system data.

Can anyone pl. provide or direct me to a link that provides a step-by-step procedure to upgrade an existing MySQL 4.1 installation to MySQL 5.x?

View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.

There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I can not seem to get any of the functions
working on it. So I have now dopwnloaded the latest version hoping
that this will fix the error.

I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but
i'm getting the following error message when I install
MySQL-server-4.0.1-0.i386.rpm : Code:

View Replies !
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.

View Replies !
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account.

Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.

View Replies !
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?

View Replies !
How To Connect Remotely To Linux/MySQL Using MySQL Query Browser
http://dev.mysql.com/doc/query-brows...onnection.html

I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system.

I type server host and port 3306 user name admin + password and default schema and I get access denied message.

I use putty to connect to the server using IP and port 22 and it connects to the server.

What settings do I need to use to connect to MySQL using query browser?

View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk.

So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.

View Replies !
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98
and everything was fine. Well, I took the big leap and removed all
traces of Windows and Microsoft from the computer. (hooray!) Once I had
Linux running OK, I downloaded and installed MySQL using an RPM package.
I guess the server is running (it says it is every time the computer
starts and it stops successfully every time the computer shuts down)
however, I cannot figure out how to get the MySQL prompt.

I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and
probably some others, too. The only thing I found was a shell script
called mysql that starts or stops the server if I am logged in to Linux
as root. I cannot figure out how to start the interactive program that
allows me to make select statements, inserts, updates, etc.
I'm wondering about some things:

Did I download and install the wrong thing?
Am I just not looking for the correct thing?

Did I install it incorrectly?

View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux?
I'm trying add a user account and password to the db server but I'm not
having any luck from the command prompt.I'm trying to setup the nexus
discussion software.

View Replies !
Installing MySQL RPM On Linux
I am trying to install MySQL with this command:

rpm -ivh MySQL-server-4.0.13-0.i386.rpm

I get bunch of errors regarding conflicts with the existing
installation (files in /usr/share/mysql/.....)

1. Originaly mySQL was isntalled with Linux 7 install
2. I can't un-install mySQL via Linux Add/Remove program, I get an
error stating sthat shared library option must be selected (it's is
selected)

3. I have deleted /usr/share/mysql directly, but still have a problem.

View Replies !
MySQL, Linux, Ia32, >4GB RAM
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32
(e.g., Xeon) with more than 4 GB RAM? Did you find a performance
enhancement? With PAE mode on? How does this affect MySQL - being a
multithreaded process, is there any benefit in having all that extra
memory as anything other than a big disk cache?

View Replies !
Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

View Replies !
Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved