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 !
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 !
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 !
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 !
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 !
|
TRACKER
