-
mysql on startup
Hi All,
I've created a remastered version of Knoppix 3.9 with apache, php and mysql 4.1 . I'm having a strange problem on startup, Apache starts up OK but when I try to startup mysql it requires four commands (one at boot time) before it will actually start up i.e.
TRY 1
root@0[~]# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
TRY 2
root@0[~]# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
TRY 3
root@0[~]# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
root@0[~]#
Then mysql starts OK
with mysqld I get
TRY 1
root@1[~]# mysqld
InnoDB: Unable to lock ./ib_logfile0, error: 9
InnoDB: Error in opening ./ib_logfile0
050819 11:40:59 [ERROR] Can't init databases
050819 11:40:59 [ERROR] Aborting
050819 11:41:00 [Note] mysqld: Shutdown complete
TRY 2
root@1[~]# mysqld
InnoDB: Unable to lock ./ib_logfile1, error: 9
InnoDB: Error in opening ./ib_logfile1
050819 11:41:06 [ERROR] Can't init databases
050819 11:41:06 [ERROR] Aborting
050819 11:41:07 [Note] mysqld: Shutdown complete
TRY 3
root@1[~]# mysqld
050819 11:41:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050819 11:41:13 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43782.
InnoDB: Doing recovery: scanned up to log sequence number 0 43782
InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin.000010
050819 11:41:13 InnoDB: Flushing modified pages from the buffer pool...
050819 11:41:13 InnoDB: Started; log sequence number 0 43782
mysqld: ready for connections.
Version: '4.1.11-Debian_4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution
mysql start OK
I managed to overcome the problem on startup by having 4 startup scripts, but this extends the startup time by quite a bit so I would like to find a better fix. Has anyone seen this before or know of a fix.
Thanks
-
Junior Member
registered user
I did the mysql start like this:
in /KNOPPIX/knoppix.sh I added
/etc/init.d/mysql stop
chown -R mysql:mysql /var/lib/mysql
chmod ugo+rwx /var/lib/mysql/*
chmod -R ugo+rw /var/lib/mysql
touch /var/log/mysql/mysql.log
chown mysql:adm /var/log/mysql/mysql.log
sleep 5
/etc/init.d/mysql start
cat /cdrom/[MyFolder]/sqldb.sql | /usr/bin/mysql -p[TheRootPasswd]
-
Thanks for the reply, is it a permissions problem then. If so, how come it starts up after a few tries?
-
Senior Member
registered user
mysqld_safe may be useful for you to start mysql
see
http://dev.mysql.com/doc/mysql/en/mysqld-safe.html
In the past I used
rm -rf /var/lib/mysql
cp -rp /KNOPPIX/var/lib/mysql /var/lib
mysqld_safe &
which worked for Knoppix 3.3, but whether it works for 3.9 I don't know.
The p option to the cp command preserves permissions.
Regards,
Mark
Similar Threads
-
By seballa in forum Hdd Install / Debian / Apt
Replies: 0
Last Post: 06-08-2009, 04:47 PM
-
By kjackson7_93 in forum General Support
Replies: 12
Last Post: 02-03-2007, 11:39 PM
-
By jagodragon in forum General Support
Replies: 0
Last Post: 12-11-2006, 03:34 AM
-
By Coume in forum General Support
Replies: 5
Last Post: 08-06-2003, 06:42 AM
-
By Terry@nz in forum General Support
Replies: 3
Last Post: 06-09-2003, 10:01 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Seagate Exos X16 ST14000NM001G 14TB 512E SATA 6Gb/s 3.5" Enterprise Hard Drive
$157.99
WD 16TB Elements Desktop, Certified Refurbished Hard Drive - RWDBWLG0160HBK-NESN
$174.99
WD 2TB Certified Refurbished Elements, External Hard Drive - RWDBU6Y0020BBK-WESN
$49.99
Seagate ST9450404SS 9PY066-080 Savvio 450GB 10K 10k 2.5" 6G SAS Hard Drive
$15.00
Seagate Exos 7E10 ST2000NM000B 2TB 7200RPM SATA 6.0Gb/s 3.5" Internal Hard Drive
$29.99
HGST Ultrastar DC HC520 12TB SATA 6Gb 256MB 3.5" Enterprise HDD- HUH721212ALE601
$82.99
HGST Ultrastar HE10 HUH721010ALE600 10TB SATA 6Gb/s 7200RPM 3.5" Enterprise HDD
$74.99
2 PACK Seagate ST1000LM035 Mobile HDD 1TB 2.5" SATA III Laptop Hard Drive
$27.49
WD 4TB Certified Refurbished Elements, External Hard Drive - RWDBU6Y0040BBK-WESN
$69.99
HDD 3.5" SATA Hard Drive with Windows 7/Win 10 Installed Legacy
$35.99