View previous topic :: View next topic |
Author |
Message |
Kaliroxx n00b
Joined: 30 Sep 2012 Posts: 9
|
Posted: Tue Jul 30, 2013 7:07 pm Post subject: Gentoo Mysql problem |
|
|
Hi, I hope you can help me.
I had a lot of old files in the directory /var/lib/mysql/ so I decided to delete them this way:
/etc/init.d/mysql stop
/etc/init.d/apache2 stop
/etc/init.d/nginx stop
rm /var/lib/mysql/mysqld
/etc/init.d/mysql start
-> Mysql Not started (0)
chown mysql /var/lib/mysql
/etc/init.d/mysql start
-> System hangs
nano /var/log/mysql/mysqld.err
shows
Quote: |
130730 20:48:55 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a mas$
InnoDB: The InnoDB memory heap is disabled
InnoDB: use atomic builtins.
130730 20:48:55 InnoDB: Started; log sequence number 0 43965
^G/usr/sbin/mysqld: File './mysqld-bin.000267' not found (Errcode: 2)
130730 20:48:55 [ERROR] Failed to open log (file './mysqld-bin.000267', errno 2)
130730 20:48:55 [ERROR] Could not open log file
130730 20:48:55 [ERROR] Can't init tc log
130730 20:48:55 [ERROR] Aborting
130730 20:48:55 InnoDB: Starting shutdown...
130730 20:48:56 InnoDB: Shutdown completed; log sequence number 0 43965
130730 20:48:56 [Note] /usr/sbin/mysqld: Shutdown complete
|
Can you help me? |
|
Back to top |
|
|
Kaliroxx n00b
Joined: 30 Sep 2012 Posts: 9
|
Posted: Wed Jul 31, 2013 10:58 am Post subject: |
|
|
I found http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html
Quote: | If you delete all the logs in /var/log/mysql but leave the old mysql-bin.index pointing to them, mysqld will not start because it cannot find the last log file in the index.
Rename /var/log/mysql/mysql-bin.index to say mysql-bin.index.bak and retry and a new mysql-bin.index file and log file mysql-bin.000001 will be created. |
Is this the right for me? If yes, how can I "retry and a new mysql-bin.index file" ?
Update: In the folder I just see
Quote: |
mysql # ls -1
mysql.err
mysql.log
mysqld.err
|
|
|
Back to top |
|
|
jnicol n00b
Joined: 29 Jan 2003 Posts: 73 Location: Seattle, WA
|
Posted: Mon Aug 05, 2013 6:22 pm Post subject: |
|
|
ugh, does gentoo really keep binlogs in /var/log/mysql?
If you're trying to do a new clean installation, delete everything in /var/lib/mysql and /var/log/mysql. If mysql server is already installed, you may need to run /usr/bin/mysql_install_db before starting it. |
|
Back to top |
|
|
tomk Bodhisattva
Joined: 23 Sep 2003 Posts: 7221 Location: Sat in front of my computer
|
Posted: Mon Aug 05, 2013 9:11 pm Post subject: |
|
|
jnicol wrote: | ugh, does gentoo really keep binlogs in /var/log/mysql? |
No, by default the bin logs go to /var/lib/mysql/
Kaliroxx wrote: | rm /var/lib/mysql/mysqld |
I'm assuming you actually ran:
Code: | rm /var/lib/mysql/mysqld* |
Kaliroxx wrote: | I found http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html
Quote: | If you delete all the logs in /var/log/mysql but leave the old mysql-bin.index pointing to them, mysqld will not start because it cannot find the last log file in the index.
Rename /var/log/mysql/mysql-bin.index to say mysql-bin.index.bak and retry and a new mysql-bin.index file and log file mysql-bin.000001 will be created. |
Is this the right for me? If yes, how can I "retry and a new mysql-bin.index file" ?
Update: In the folder I just see
Quote: |
mysql # ls -1
mysql.err
mysql.log
mysqld.err
|
|
That is nearly correct, except the bin logs are in /var/lib/mysql so if you follow the advice above but with /var/lib/mysql/mysql-bin.index instead of /var/log/mysql/mysql-bin.index.
If you don't want binary logging you should comment out the 'log-bin' line in your /etc/mysql/my.cnf _________________ Search | Read | Answer | Report | Strip |
|
Back to top |
|
|
|