After adding new vhost and some time (i come today and its just dead, maybe not only "just dead" - other coder creates some new bases two days ago, but SQL server dies only after xampp restarting) - Starting XAMPP for Linux 1.7.7... XAMPP: Starting Apache with SSL (and PHP5)... XAMPP: Starting MySQL... Warning: World-writable config file '/opt/lampp/etc/my.cnf' is ignored XAMPP: Couldn't start MySQL! XAMPP: Starting ProFTPD... XAMPP for Linux started.
I used command from another topic - [root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf -rwxrwxrwx 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf [root@gn141 ~]# chmod 644 /opt/lampp/etc/my.cnf [root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf -rw-r--r-- 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf
(my.cnf wasnt modified since install) and now it just XAMPP: Couldn't start MySQL!
Error log - gn141.zone.eu.err
120507 10:48:14 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql 120507 10:48:14 [Note] Plugin 'FEDERATED' is disabled. /opt/lampp/sbin/mysqld: Table 'mysql.plugin' doesn't exist 120507 10:48:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120507 10:48:14 InnoDB: The InnoDB memory heap is disabled 120507 10:48:14 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120507 10:48:14 InnoDB: Compressed tables use zlib 1.2.3 120507 10:48:14 InnoDB: Initializing buffer pool, size = 16.0M 120507 10:48:14 InnoDB: Completed initialization of buffer pool 120507 10:48:14 InnoDB: highest supported file format is Barracuda. 120507 10:48:14 InnoDB: Waiting for the background threads to start 120507 10:48:15 InnoDB: 1.1.8 started; log sequence number 627359224 120507 10:48:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 120507 10:48:15 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/gn141.zone.eu.pid ended
Also a httpd.pid file near the log with 11862 inside
What it can be? (And/or how i can reinstall xampp and save DBs and other stuff? And any good autobackup tool for xampp please.)
I'm sure you are aware you should fix your database(s) with the correct tools. LOL, as a System Architect that designs ground-up databases then integrates them with frameworks, I know that is easier said than done.