Server :: MySQL Datadir From Previous Install?

Jun 22, 2010

I was running Ubuntu 9.10 and had the MySQL datadir moved to a different directory, /store/mysql. Due to a filesystem problem on the upgrade to Ubuntu 10.04, I was forced to reinstall. My /store/mysql was copied back over, changes to /etc/mysql/my.cnf and /etc/apparmor.d/usr.sbin.mysqld, but MySQL hangs when I go to start it and nothing is showing up in any of the logs. How do I get MySQL to recognize the datadir from the previous install?

View 1 Replies


ADVERTISEMENT

Server :: MySQL With Alternative Datadir?

Dec 22, 2010

After several hours of searching web I give up. Problem: I want to run mysqld with datadir option.When I run it manually without --datadir everything is fine I have added required lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor

Quote:
/sys/devices/system/cpu/ r,
/disk0/mysql r,
/disk0/mysql/** rwk,

Then I copy /var/lib/mysql to my location, carefully, 10 times checking all the permissions and run. But daemon exits immediately after running.

[Code]...

View 2 Replies View Related

Fedora Servers :: Changing MySQL Datadir?

Aug 16, 2009

Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:

1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)

[Code]...

View 7 Replies View Related

Ubuntu Servers :: Changing The Datadir In My.cnf Stops Mysql To Restart On 9.10

Feb 9, 2010

I am trying to change the datadir in my.cnf and try to point it to different location where my database are residing.I have the permission to write on this directory.

datadir = /home/glucose/mysql
#datadir = /var/lib/mysql

if I do ls on my database location.Here is the result

root@bilal-laptop:~# ls -la /home/glucose/mysql
total 20512
drwxr-xr-x 7 mysql mysql 4096 2010-02-09 16:30 .

[Code]....

Because of which I am not able to start mysql. I am not able to locate actual log file as well.I looked at few log files they don't seem to tell me anything.But I am not sure which one I should be looking at as there are quite a few related to mysql.

View 3 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

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

View 6 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

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.

View 9 Replies View Related

Red Hat / Fedora :: Trying To Install Mysql-server ?

Feb 23, 2010

I am trying to install mysql-server using the command

But get the following error:

View 5 Replies View Related

Server :: Can Not Install Php-mysql / Resolve This?

Jul 9, 2011

I have just updated PHP from 5.1.6 to 5.3.6
on CentOS 5.6, After reboot I have tried to install php-mysql
but I got error says code...

View 2 Replies View Related

Debian Installation :: Install SSH On Server But Not For MySQL

Sep 1, 2014

I would like to enable SSH on my debian server but not for MySQL. For MySQL, I want to connect normally.

View 7 Replies View Related

Fedora :: Sudo Apt-get Install Mysql-server ?

Jan 16, 2011

What is sudo? I tried to do this : sudo apt-get install mysql-server

And then it gave me this :

We trust you have received the usual lecture from the local System

Administrator. It usually boils down to these three things:

1) Respect the privacy of others.
2) Think before you type.
3) With great power comes great responsibility.

[sudo] password for mlocicero: mlocicero is not in the sudoers file. This incident will be reported.

View 4 Replies View Related

Ubuntu :: Mysql Server Install Error

May 15, 2011

I'm trying to install the squeezebox server software in Ubuntu 9.10 and I'm getting an error when it tries to install mysql-server. Seems like people have run into this before [URL]... but so far, I can't find a solution.

[code]...

View 1 Replies View Related

Ubuntu Servers :: Can't Install Mysql-server

Jun 3, 2011

i'm trying to install mysql-server on my pc. so i type this on my terminal:

Code:
sudo apt-get install mysql-server

it starts to download & install everything, but when it has to configure the server, it simply "freeze" and does nothing!

how can i solve that? i've tried to purge and reinstall, but it was no use!

View 6 Replies View Related

Software :: Install Mysql-server Into A Pendrive ?

Nov 16, 2010

I need to install mysql-server into a pendrive because i want to use a database into the pendrive..

I'm using debian, and i tried to put the var/lib/mysql directory into the pendrive, then i modified the my.cnf file with this string:

But now when i write "mysql -u root -p" i receice this error:

I think because i have to install mysql into the pendrive, isn't it?

View 11 Replies View Related

CentOS 5 :: Mysql-server Fails To Install?

Feb 7, 2011

Im having a major problem with mysql-server failing to install.The installation stoppes on "Running Transactions" (have tried waiting for 10 minutes). When I use Ctrl+C an error appears:error: %pre(mysql-server-5.0.77-4.el5_5.4.x86_64) scriptlet failed, signal 2 error: install: %pre scriptlet failed (2), skipping mysql-server-5.0.77-4.el5_5.4

View 2 Replies View Related

General :: Non-Root Portable Install Of MySQL Server?

Mar 3, 2010

Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.

View 2 Replies View Related

General :: Install MySQL Server On Debian While Offline?

Aug 29, 2011

I'm a Linux newbie. I want to install mysql-5.5.15-linux2.6-x86_64.tar.gz on a Debian box offline without using the apt command. How can I do this?

View 1 Replies View Related

Ubuntu :: Unable To Install Mysql-server On Lucid?

May 11, 2010

I've tried installing mysql-server on Lucid, and I get errors that it cannot set the root password. A screenshot is attached.

I have no idea what to do. I've tried purging configuring and reinstalling. Same problem. I can't find anything in the logs.

View 2 Replies View Related

Ubuntu :: Cannot Install Mysql, Php5 And Apache2 Server On 10.04?

Aug 4, 2010

currently I am using Ubuntu 10.04.I want to install mysql, php5 and apache2 server in my machine. I have tried this- aptitude install mysql-server mysql-client

But the outcome is
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done

[Code]...

View 2 Replies View Related

CentOS 5 Server :: Apache MySQL PHP Does Not Work On New Install

Jul 17, 2010

I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.

MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...

View 5 Replies View Related

CentOS 5 Server :: How To Install Pure-ftpd WITHOUT Mysql

Apr 7, 2011

I'm trying to install Pure-FTPd. I'm going to use it via the internal file-based userlist.The problem is, when I yum install pure-ftpd from rpmforge or CentOS.Karan.Org, I also get mysql, perl-DBI and postgresql-libs as dependencies.Since I'm not intrested in DB-based authentication, I'd strongly prefer to skip these packages.Why are these listed as dependencies, since AFAIK, they are not really dependencies? Can I force yum to skip them somehow?

View 2 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

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.

View 1 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

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:

View 4 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

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

View 7 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

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

View 13 Replies View Related

CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community

Jun 4, 2009

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

View 16 Replies View Related

Ubuntu :: Reinstalling MySQL Server - Still Have My Databases At /lib/var/mysql

Jun 18, 2010

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?

View 1 Replies View Related

Ubuntu :: Remove Everything Related To Mysql / Mysql-server?

May 23, 2011

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

View 4 Replies View Related

Server :: Recover MySQL Innodb From /var/lib/mysql/ Backup?

Jan 30, 2011

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/ ?

View 1 Replies View Related

CentOS 5 Server :: MySQL On Cent OS 5.2, Error In MySQL

Mar 3, 2009

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

View 16 Replies View Related

CentOS 5 Server :: Epic Fail Mysql Install Got Horribly Wrong

Nov 20, 2010

Today I was trying to upgrade mysql and php.PhP went well, thats at the latest version, but the mysql went to 5.5x from REMI. This killed all my websites, no DB and worse.Well I typed the wrong this (totally my fault - serious EPIC FAIL)i typed yum remove mysql not downgrade...This removed plesk and a load of other stuff, and now im screwed.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved