5

How to change database directory to another directory

view full story
linux-howto

http://www.unix.com – Hi, I Installed mysql on my CentOS 6.2 Server. But when I tried to change the location of /var/lib/mysql to another directory. I can't start the mysql. Below is what I've done Code: yum install mysql mysql-server mysql-devel mkdir /path/to/new/ cp -R /var/lib/mysql /path/to/new chown -R mysql.mysql /path/to/new vi /etc/my.cnf change datadir=/var/lib/mysql to datadir=/path/to/new Code: service mysqld start MySQL Daemon failed to start. Starting mysqld:                                  &nb (HowTos)

Shoutmeloud's picture
Submitted by Shoutmeloud on 10/31/2012 – Made popular on 10/31/2012

Stories similar to How to change database directory to another directory

Mysql error when starting 3 years 22 weeks ago

Well i have had a server for about 2 months now, and im still finding out new stuff about it, so i started coding a lil php & JS, and i wanted to make a DB for it with mysql, anyway this is not the point :P. The point is that i get an error when i try starting my mysql services.

When i do

Code: /etc/init.d/mysql start this is the output i get

Hello.

Running 10.04 server and mysql 5.01.

I experimendted innobackup which made a one backup file of all databases.

Tested restoring the database by first stopping mysql service (stop mysql), extracting the backup to a new dir (/var/lib/data), modified the /etc/mysql/my.cnf to point there and to check the mysqld.sock to point to /var/run/mysqld/mysqld.sock .

Code: [client] port

hi, i'm new to Debian os and currently want to install php5 apache2 and mysql 5.1.

I have a server with these specs :

PHP Code:

Last login: Fri Aug 24 13:26:37 2012 from 118.71.57.107 [root@localhost ~]# free              total       used       free     sh

Extremely slow machine 3 years 16 weeks ago

Hello,

I run F12. Since some days my laptop has become very sluggish. In Mozilla, switching between the tabs takes like seconds instead of fraction of a second. Also minimizing and mximizing windows takes long. Switching between the windows too takes long. Now I can't see the cursor while typing this post.

I was trying to install mySQL and i ran a few commands that maybe i shouldn;t have.

Code: [pgar23@python ~]$ su Password: [root@python pgar23]# history #Trying to get rid of everything mysql  541  rm -rf *mysql   542  rm -rf *.mysql   543  rm -rf *mySQL   544  rm -rf *.mySQL

anomalous overload of vps 38 weeks 1 day ago

I have a vps with cpanel 11.32.3 and from about 20 hours it go in overload but I dont see reasons, the vps dont reveice many requests and manages very little traffic.

I stopped mysql and apache services but not solved then deduce that does not depend on these

PHP Code:

  1  [||              &n

PHP and Mysql in FC17 33 weeks 4 days ago

Hello, In the past, with previous Fedora versions, I successfully have worked with PHP and Mysql. After a new installation of FC17, I like to work with it again. But after installing both, now I cannot work with it. Please what can be the reason why I can not start it? Many thanks in advance for helping. Gaston Verhulst.

Code: [gastonv@gastonv ~]$ yum list installed | grep php php.i6

have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock.

I am trying to run the same server on /var/run/mysqld/mysqld1.sock.