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
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
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
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
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
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
Feb 23, 2010
I am trying to install mysql-server using the command
But get the following error:
View 5 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
