MySQL 5 In CentOS 5.2
I have installed the OS and installed MySQL 5.0 and PHP 5.1.6 through the Add Remove programs GUI and i am lost...
I checked to see if MySQL is running by using
mysqladmin status but i get the following:
[root@wiki1 bin]# mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 2 Replies (Posted: July 15th, 2008, 01:21 PM)
Sponsored Links:
Related Forum Messages for MySQL:
Setup - Getting DB To Work On CentOs 5?
I've bee tearing my hair out trying to get MySQL 5 running on CentOS 5 but I've had hardly any luck. If I leave everything as default, and launch the initial install it works a charm, but if I tell the my.cnf to use a different drive to store the data, I continuously get the "Timeout error occurred trying to start MySQL Daemon." error. My.cnf is as follows: [mysqld] datadir=/database/mysql socket=/database/mysql/mysql.sock user=mysql old_passwords=1 log-error=/database/log/mysqld.log long_query_time = 10 log_slow_queries = /database/log/mysql-slow.log query-cache-type = 1 query-cache-size = 8M innodb_file_per_table skip-bdb set-variable = local-infile=0 [mysqld_safe] pid-file=/var/run/mysqld/mysqld.pid The folders all have the right privileges and the mysqld.log doesn't have any error messages in there, according to it, MySQL launced successfuly. Oh, and /database is a mounted drive, but even if I trial it on a local directory, I get the same error.
Posted: Feb 28 09 at 20:36
View 2 Replies!
View Related
Changing Data Directory On CentOS 5.2
I want to change mysql's data directory from default location(/var/lib/mysql) to "/home/mysql" I have copied all the data from default directory to "/home/mysql". and Changed the ownership to the 'mysql' user. Modified the /etc/my.cnf specifying the desired data directory. when i tried to start the mysql service i got the following error "Starting MySQL.Manager of pid-file quit without updating fi[FAILED]" the logfile details are 081009 18:10:55 mysqld_safe Starting mysqld daemon with databases from /home/mysql/ 081009 18:10:55 mysqld_safe mysqld from pid file /home/mysql//localhost.localdomain.pid ended I am running mysql on CentOS 5.2 VMWare. I have tried the same procedure on FC 6 VMWare and succeded.
Posted: October 22, 2008 06:16AM
View 2 Replies!
View Related
Centos - Mysql Dump Runs, But Does Nothing?
I am trying to restore a database using mysqldump, but nothing seems to happen. I get some output on the screen, but the program stops before it imports anything and does not report any errors.I am trying to restore a dump using the syntaxmysqldump --log-error=/root/dumplog --verbose --user=myuser mydatabasename < /root/dump.sqlI get no entries in the MySQL log, and in dumplog, all I get is this: -- Connecting to localhost... -- Disconnecting from localhost...
Posted: Mar 6 at 23:45
View 1 Replies!
View Related
Linux - Edition Install For CentOS Server?
There are different mysql install packages for differential platforms.[URL] I'm using CentOS, which install package should I download? The Generic Linux or Rethat/Oracle Enterprise Linux? PS: I cannot install it with yum because of some irregular Transation error.
Posted: Mar 7 at 10:58
View 2 Replies!
View Related
Severe Mysqldump Performance Degradation Using Centos Linux - 8GB PAE And 5.0.77
We use MySQL 5.0.77 on CentOS 5.5 on VMWare: Linux dev.ic.soschildrensvillages.org.uk 2.6.18-194.11.4.el5PAE #1 SMP Tue Sep 21 05:48:23 EDT 2010 i686 i686 i386 GNU/Linux We have recently upgraded from 4GB RAM to 8GB. When we did this the time of our mysqldump overnight backup jumped from under 10 minutes to over 2 hours. It also caused unresponsiveness on our plone based web site due to database load. The dump is using the optimized mysqldump format and is spooled directly through a socket to another server. Anything we can do to Linux config? Or do we have to add another server or go to 64-bit? We ran a previous (non-virtual) server on 6GB PAE and didn't notice a similar issue. This was on same MySQL version, but Centos 4.4. Server config file: [mysqld] port=3307 socket=/tmp/mysql_live.sock wait_timeout=31536000 interactive_timeout=31536000 datadir=/var/mysql/live/data user=mysql max_connections = 200 max_allowed_packet = 64M...............
Posted: Feb 22 at 9:59
View 1 Replies!
View Related
Execute A Database Insert From The CentOS Command-line?
Normally if you wanted to execute a MySQL command you would just open up the MySQL command-line, but I'm trying to execute the command via Windows command-line. Just got this got this code working on the Windows command-line, but also need a port of it for CentOS: echo INSERT INTO InsertTableName (Column001, Column002) VALUES('Value001', 'Value002'); | mysql -u InsertUserName -pInsertPassword InsertDatabaseName System Setup: * MySQL: 5.1.53-community MySQL Community Server (GPL) * CentOS: 5.5 (64-bit)
Posted: Mar 3 at 14:03
View 2 Replies!
View Related
Error:- No Tuples Available At This Result Index PHP-APACHE-ODBC-MYSQL-CENTOS?
I have PHP sample code which will fetch the data from the MYSQL database through ODBC driver on Linux(CentOS) machine.I have created DSN and same able to connect through following commandisql -v But when i try to same DSN through PHP code i am getting "No tuples available at this result index" due to which unable to read the data from database through PHP APACHE configuration.If anyone provides the solution,It will more helpful for me to proceed further.Below are my sample code and other details,Please correct if anything wrong on below configuration details-Below is sample PHP code: <?php $conn = odbc_connect("DSN", "username", "password"); $sql = 'select * from tablename'; $rs = odbc_exec($conn,$sql); echo "<table><tr>"; [code]....
Posted: Mar 12 at 9:59
View 1 Replies!
View Related
|
TRACKER
