Alteração de partição de dados

[RafaelMagalhaes82]

Pessoal, bom dia!

 

Me dá uma ajuda!

 

Tive que alterar a partição de dados do meu MySQL pois a partição "/" estava estourando.

 

Fiz o seguinte procedimento:

 

- Parei o MySQL

- Copiei toda a base da origem para o destino

- Dei as permissões para o usuário "mysql" do linux

- Alterei o parâmetro "datadir" do my.cnf

- Tentei inicializar o MySQL.

 

Está dando erro para inicializar:

 

root@RJMRLNX01:~# service mysql start

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

 

root@RJMRLNX01:~# systemctl status mysql.service

● mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

   Active: inactive (dead) (Result: exit-code) since seg 2016-09-12 10:10:16 BRT; 491ms ago

  Process: 50336 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)

  Process: 50328 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

 Main PID: 56049 (code=exited, status=0/SUCCESS)

 

set 12 10:10:16 RJMRLNX01 systemd[1]: Failed to start MySQL Community Server.

set 12 10:10:16 RJMRLNX01 systemd[1]: mysql.service: Unit entered failed state.

set 12 10:10:16 RJMRLNX01 systemd[1]: mysql.service: Failed with result 'exit-code'.

set 12 10:10:16 RJMRLNX01 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.

set 12 10:10:16 RJMRLNX01 systemd[1]: Stopped MySQL Community Server.

set 12 10:10:16 RJMRLNX01 systemd[1]: mysql.service: Start request repeated too quickly.

set 12 10:10:16 RJMRLNX01 systemd[1]: Failed to start MySQL Community Server.

 

root@RJMRLNX01:/etc/mysql/mysql.conf.d# journalctl -xe
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Unit entered failed state.
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Failed with result 'exit-code'.
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
set 12 11:07:32 RJMRLNX01 systemd[1]: Stopped MySQL Community Server.
-- Subject: A unidade mysql.service concluiu o desligamento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service concluiu o desligamento.
set 12 11:07:32 RJMRLNX01 systemd[1]: Starting MySQL Community Server...
-- Subject: Unidade mysql.service sendo iniciado
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service está sendo iniciada.
set 12 11:07:32 RJMRLNX01 audit[4360]: AVC apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/mysqld" pid=4360 comm="apparmor
set 12 11:07:32 RJMRLNX01 kernel: audit: type=1400 audit(1473689252.755:98): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sb
set 12 11:07:32 RJMRLNX01 mysqld[4363]: Initialization of mysqld failed: 0
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Control process exited, code=exited status=1
set 12 11:07:32 RJMRLNX01 systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Unit entered failed state.
set 12 11:07:32 RJMRLNX01 systemd[1]: mysql.service: Failed with result 'exit-code'.
set 12 11:07:33 RJMRLNX01 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
set 12 11:07:33 RJMRLNX01 systemd[1]: Stopped MySQL Community Server.
-- Subject: A unidade mysql.service concluiu o desligamento
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service concluiu o desligamento.
set 12 11:07:33 RJMRLNX01 systemd[1]: mysql.service: Start request repeated too quickly.
set 12 11:07:33 RJMRLNX01 systemd[1]: Failed to start MySQL Community Server.
-- Subject: A unidade mysql.service falhou
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- A unidade mysql.service falhou.
--
-- O resultado é failed.
set 12 11:09:01 RJMRLNX01 CRON[4372]: pam_unix(cron:session): session opened for user root by (uid=0)
set 12 11:09:01 RJMRLNX01 CRON[4371]: pam_unix(cron:session): session opened for user root by (uid=0)
set 12 11:09:01 RJMRLNX01 CRON[4373]: (root) CMD (  [ -x /usr/lib/php/sessionclean ] && /usr/lib/php/sessionclean)
set 12 11:09:01 RJMRLNX01 CRON[4374]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)
set 12 11:09:01 RJMRLNX01 CRON[4371]: pam_unix(cron:session): session closed for user root
set 12 11:09:01 RJMRLNX01 CRON[4372]: (CRON) info (No MTA installed, discarding output)
set 12 11:09:01 RJMRLNX01 CRON[4372]: pam_unix(cron:session): session closed for user root
 

 

O que fiz de errado?

Editado Setembro 12, 2016 por RafaelMagalhaes82

[Paulo Porto]

Bom dia Rafael

1° Alteração feita no datadir

2° Alteração do caminho no arquivo my.cnf

3° Reniniciar o servidor para reconhecimento dos novos parâmetros.

você parou o servidor e iniciou novamente os serviços, ou você reiniciou os serviços?