MYSQL :: How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS

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.

MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to
install the binaries recommended on MySQL. However, when I run the
mysql client, I get simply:

Segmentation fault.

So I tried to do a basic source compile, which went fine, but when I
run mysql client, I get this:

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2 to server version: 4.1.12

Segmentation fault

When I try the flags recommended by MySQL
(--with-extra-charsets=complex among others), the make test fails on
ucs_binlog - something to do with charsets I believe?

The mysql user, group etc. are all set up. Strangely, the mysql client
works in batch mode so if you make a file that reads:
SHOW DATABASES;

Then type:
mysql < commandfile

It'll display
Database
mysql
test

Without any faults....

Anyone any ideas or suggestions?

MySQL Administrator Install (service Already Exists)
I've installed MySQL 4.1 on a W2k machine and would now like to install MySQL Administrator. Whenever I try to do so, however, I get an error message saying that the specified service (which service is isn't specified!) already exists and the installation fails. I get the same error trying to install the Query Browser.

It was suggested elsewhere that this may be due to my version of MSI being out of date, so I've updated to V2, de-installed MySQL (including removing all traces from the registry and HD) and re-installed using the latest MSI. Same result.

JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25

I receive:
ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause'

But this query DOES work under my linux 5.0.0-alpha!

I can modify the SQL Statement to the following and it works fine:

SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a
LEFT JOIN users c ON a.createdby=c.id
LEFT JOIN users d ON a.modifiedby=d.id
RIGHT JOIN building b ON a.sortcode=b.sortcode
WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .

User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine.
mysql-administrator v1.0.22 is installed on RH Linux FC3 from the
mysql-administrator-1.0.22a-1.rh9.i386.rpm.

Everything seems to run fine except User Administration is *extremely*
slow. If I click on "User Administration" in the sidebar, it takes
about 2 minutes (seems like forever) before the window comes back with
the infomation. All the other functions seem to function fine.

Is it because I'm using mysql-administrator on a remote host? Do I need
to move and rebuild the server to a newer Linux version? mysqlcc
doesn't have this problem at all. (It's using the libraries from MySQL
4.1 that the databases were migrated to.)

MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us.

What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job.

Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days.

So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery.

How much would we be better off spending more Â£ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?

Mysql-administrator And Mysqlcc Install Directory Conventions
What Linux directory ought the mysql-administrator and mysqlcc
executables be installed? Granted, they'll run from anywhere but is
there a common path used by most Linux distributions?

How To Backup/restore To Move Databases From One Server To Another (Win2k3 Enterprise, Mysql)
I'm trying to move a "schema" (I guess thats the term) aka database from our webserver2 to our webserver3. I backup the .sql file, and move it over to webserver3. I tell it to restore that file and create the database if it does not exist. Part way thru i get all these errors like: Code:

64-bit MySQL 4.1.14 Install: GNU/Linux Ver 2.6.9-11.ELsmp
We have attempted to install 64-bit MySQL 4.1.14 on GNU/Linux ver 2.6.9-11.ELsmp. Following are the packages that we installed this time:

MySQL-server-4.1.14-0.glibc23
MySQL-debuginfo-4.1.14-0.glibc23
MySQL-client-4.1.14-0.glibc23
MySQL-devel-4.1.14-0.glibc23
MySQL-shared-4.1.14-0.glibc23
MySQL-Max-4.1.14-0.glibc23

Our other three installs (from many months ago) of 32-bit MySQL on Linux went without hitches. This time, however, we are encountering the following error messages (following other unsuccessful attempts to connect on the installed software):Quote (MySQL error log):

Code:

Administrator Stopped MySQL Server
I installed MySQL 4.1 on my Windows XP Pro system and started using it with the command line client. I didnâ€™t like that and downloaded MySQL Administrator (I have yet to download the MySQL Query Browser). I went to the online documentation and I came to the section on configuration and noted that the de-bug component was not enabled. I clicked on it to enable it and a window popped up that said I could use the Stop/Start Service feature so that the component would take effect.

I clicked on Stop Service and the Administrator stopped the MySQL Sever, but when I clicked on the Start Service I got a message saying that the service could not be started. I recycled the computer and no change. I went to Services in the Administrative Tools and attempted to start MySQL Sever, but that would work either. Can someone tell me how to get MySQL Sever running again? Iâ€™ve spent the whole day on the web looking for answers and canâ€™t find anything useful.

Using Mysql Administrator & Connecting To Server Instance
I Have a mysql database which i need to back up, i have down loaded
"mysql administrator for this purpose, however when i try to connect &
use it I get error message 1045 & i am unable to connect

Linux To Install
I am creating a dedicated DB server running mysql. What is the best linux to install for this?Also the db server will have its own ip is there any other additional security measures that should be taken?

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

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?

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.

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.

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".

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?

Can I Install 2 Version Of Mysql On The Same Server
Is that impossible for to do that (install 2 different version of the mysql on the same server) if yes Currently, I have mysql 4.0.22 on win 2003 and IIS6
With my.ini file what can i do customized config it

[mysqld]
basedir=x:/mysql
#bind-address=192.168.x.xx
datadir=x:/mysql/data
#language=x:/mysql/share/your language directory
#slow query log#=
tmpdir=x:/windows/temp
#port=3306

that for mysql 4.0.22
I design will be install mysql 4.1.x into x:/mysql41
so what do you think the my.ini what would be done

Install 2 Version Of Mysql On The Same Server
Is that impossible for to do that (install 2 different version of the mysql on the same server)

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.

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

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?

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?

Install Httpd To Web Server
I hv a mysql 4 run on RH linux server , the default apache service is
running , now I want to install the httpd rpm to the server because
the ARCserve backup software need to install it first , I just want to
ask if I install the httpd to the server but not start it , will it
affect the setting / o peration of the web server , I am afraid the
setting will be changed after install the httpd ?

Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local.

1. I have installed MYSQL Server to my localhost [Windows].
MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt.

2. I have installed the MYSQL Network Monitor to my local system [Windows]
With all options like admin login, agent and other details.

But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor.

I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor.

We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?

MySQL Open Source And Enterprise
what is the main difference of the two... enterprise and open source

MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like.

The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead.

I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims.

By no means do I want to get into 'down with Microsoft' thread here.

Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?

MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant".

Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service.

Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?

Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP.
I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects
Does anyone know a tool like the one I just described in my dream

Install / Re-Install MySQL 4.x
1. If I want to simply run MySQL on my RedHat Linux server (Intel) based which product to I install?

2. I have paritally installed MySQL once. Had some problems. Now that I am trying to Re-Install, it says that I cannot because previous components exists. How do I uninstall MySQL?

Crystal Enterprise Connection
I can connect Crystal Reports to MySQL via JDBC or ODBC. But I have trouble connecting MySQL to Crystal Enterprise. Is it possible to connect Enterprise to MySQL?

Which Version Is Enterprise Ready
Am I correct in assuming that the "Enterprise" production ready version of MySQL is version 5.0? If so, when is the 5.1 release going to be production ready?

After Install Cant Select Install As Windows Service
i cannot configure MySQL to install as a windows service. NOR can i get the blasted thing to let me setup a user name and password. how do i correct this ?

Mysql-administrator
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will
not work. When I try to acccess it I get the following message.

linux:/home/grabro # mysql-administrator
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib10ObjectBaseE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk9ListStoreE' has
different size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk5EntryE' has different
size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib6ObjectE' has different
size in shared object, consider re-linking
/usr/bin/mysql-administrator-bin: Symbol `_ZTIN3Gtk6WidgetE' has different
size in shared object, consider re-linking
*** glibc detected *** /usr/bin/mysql-administrator-bin: free(): invalid
pointer: 0x083ca0e0 ***
======= Backtrace: =========
/lib/libc.so.6[0xb716d911]
/lib/libc.so.6(__libc_free+0x84)[0xb716ef84]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb72e6e51]
/usr/lib/libstdc++.so.6(_ZNSs4_Rep10_M_destroyERKSaIcE+0x1d )[0xb72c2fed]
/usr/lib/libstdc++.so.6....................................

MySQL Administrator 1.1.9
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour.

Am I OK to use this version of mySQL Administrator to backup my database and what unexpected behaviour can I expect ?

MySQL 5.0 Administrator
I have installed a new MySQL 5.0 administrator and since I am so used to deleting a database directly through data folder in my old mysql 3.23 that I do it now also in MySQL 5.0 rather than deleting it through administrator .

Now the problem , if the db is deleted not through administrator , it somehow creates a same name cache of the database and it creates a problem if I try to run a sql script because it gives a error of duplicate name.

My question is , Is there a way to delete old cache names of the db's so that new db's can be created or a script can run the db which has been created and deleted before .

MySQL Administrator
I am using the MySQL Administrator version 1.1.3. Why is the "Edit Table Data" grayed out when i right click on a table? Is there a way to ungrayed this?
Or is this not part of version 1.1.3 anymore?.

Mysql Administrator 1.0.19
when i click catalogs -> my schemata ; right-click on any InnoDB table i am not able to "edit table data" it is grayed out.

What do I have to do to be able to edit table data with mysql admin.

MySQL Administrator
My mysql server's version is 4.1.11_win32 and my MySQL Administrator's version is 1.0.19. When I use MySQL Administrator to modify the user administration, it always shows me "Error while storing the user information!".

MySQL Administrator
I want to view the config file in MySQL Administrator but it says I must be connected to localhost to see it.
Can I grant myself permissions to be localhost as well?

MySQL Administrator
I am trying to make one of my fields UNIQUE, however the MySQL table editor has the 'index settings' greyed out so I can not select "UNIQUE".
How do I make field unique

MySQL Administrator
I have setup MySQL Admin to run scheduled backups on my databases... do I have to keep the program open in order to run them?

MySQL Administrator 1.0.13
I've just downloaded MySQL Administrator 1.0.13 and wish to connect to a mySQL server v3. When connecting I get a message saying that this server version is not support, which I can ignore.
Can someone please advise what problems i might encounter if connecting to an unsupported server version ?
My main requirement for the mySQL Administrator program is scheduled backups of the data and table structures.

MySQL Administrator
I have a site hosted with a company. I created a testing sub-domain called testlab.swattle.com In this sub I have created a database called swattle_test and I also added a user called swattle_testuser
Now when I go into the MySQL Administrator program on my local machine and try to logon to the server I keep getting an error 1045 I put up the screen shots of at http://testlab.swattle.com I also fired off an email to my hosting company

Mysql Administrator
i installed it for windows i can't seem to get it to connect to the database though, the mysql server is on the same machine as this one. for the hostname i typed in localhost port:3308 (is that the right port?) and my root username and password

it gave me an error that it couldnt ping to "localhost" i dont get it

Mysql Administrator
How do I edit table data using Mysql administrator.
If I click on edit table data the table opens, but then there is no way to edit the table.
At the bottom there is a button to apply changes but this is grayed out.

MySql Administrator
I'm using Innodb on windows server 2003.I noticed today that some of my tables are reported by MySql Administrator to have a far greater number of rows than what is return in a query for all rows.
For example, one table shows 51,600 rows in Administrator but when I do a SELECT * on the same table from Query Browser I get a mere 5,293 (this is the correct or "real" number of rows)
So, what's up? Why is administrator showing so many more rows?
I've also noticed that each time I press the refresh button in Administrator the number of rows changes. one time it might be 50k+ then 30k then 43k, etc, etc.
being a newb I'm a bit freaked out by all of this. I've heard that innodb can do some funny things, but this seems REALLY strange. I'm sure it's nothing, I just need to hear it from an experienced user