I installed mysql on Debian upon restarting the mysql
I got following error
Code:
# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_138e_0.MYI'; try to repair it
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
We have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.
when installing mysql-server by this command sudo apt-get install mysql-server. Installaton is complete but i cant get a my.cnf file. Can anyone tell, what is the mistake i did and how to overcome from this error. Here, i am posting the results
sam-osm@dhcppc4:~$ sudo nano /etc/mysql/
conf.d/ debian.cnf
i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies View RelatedI am trying to read a file uploaded by a simple <input type="file"> form and directly write it to a mysql blob - without saving it to the filesystem.
I tryed something like:
Code:
It writes some few Bytes to the DB and there is no error, but it's not the actual file that is being written.
We have been struggling with a problem with the mysql-server package. This might be in the wrong category because our problems are with it on x86_64. Where the problem happens variables that should populate from the my.cnf don't, on other servers, they do, the my.cnf files are identical except for the server-id
The problem occurs on some of our machines but not others. All are using the mysql-server-5.0.45-7.el5.x86_64 The ones that work, when you connect with a client respond with server version 5.0.45-log source distribution The ones that don't work respond with 5.0.45 source distribution
It's unclear what the differences are between the two source versions and how we wind up with two different versions. One thing that might be involved, the mysql package is installed with both the i386 and x86_64
I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 Replies View RelatedWhen i load the local .csv file into mysql server the date format varies.Its mis matching.How to solve and match this.
View 1 Replies View RelatedI thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedI've got a problem with squid_radius_auth. Each time squid tries to authenticate, it sends incorrect password. Somebody already asked this here on LQ, he had incorrect shared secret set... but I'm quite sure the secret is correct, yet it cannot authenticate. /usr/local/squid/etc/squid_radius_auth.conf
Code:
Code:
Recordedseek became corrupted and couldn't be fixed no matter what I tried, so I went in, truncated the table and rebuilt it with mythcommflag. I also did some myisamchk repairs on a couple of other tables (settings and eit_cache). Now myisamchk tells me all the tables are fine. But when I restart the database I'll get an error like: ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_2506_0.MYI'; try to repair it
In terms of the effect, I have lost all my recordings. Listings seems fine (although it has crashed a couple of times, I think I've fixed whatever was wrong), recording schedules seems fine, but even though there is stuff due to record upcoming recordings is empty. Mysqlcheck isn't showing any problems, I'm at a loss as to where to go from here.
I cant figure out why my server running fc14 keeps saying login incorrect 530. I am using gproftpd. I know that the login is correct though. For instance:
Lets say my user is "goober" and my pass is "fedora" and I go and type that in when I try and login to the ftp it says login incorrect.
One of my servers is displaying the error as login incorrect even after giving the correct password. Once I restarted the Virtual Machine and after that it is accepting the same password to login. I am not able to find out the problem, why the server is not able to validate the password until the virtual machine gets rebooted.
View 2 Replies View RelatedI am trying to backup my webmin configuration but I'm getting this error message:
Restore failed : Incorrect Webmin PID 31266
I am fairly inexperienced as far as Linux is concerned, so if anybody could tell me how I could solve this.
I am attempting to connect to VSFTPD via Filezilla from a windows machine, but regardless of which user name I use I get a "530 Login incorrect" error. I have tried turning off the firewalls on both the CentOS and Windows side of things with no result. I disabled the SSL/TLS commands in the config file, also with no change. I tried a couple of different FTP clients, but got similar results regardless of which client I used. I have been going over man pages and documentation for a couple of days now, but cannot come up with an answer. I suspect it lies in my configuration, but I got the same results when I reverted my config file back to the original. what else I can do? One other note is that I am attempting to connect via a LAN, at this point I don't care if it works across the WAN as I only intend to use it to upload files to my web server.
[Code]....
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 3 Replies View RelatedI'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....