-
The problem was that the MySQL server attempted to start, then failed to start -- thus causing the error. The solution was a bit complicated and required remastering several times, but the basic information needed for the solution was found in these two threads. (UnderScore's information was pretty much on target for my needs ... UnderScore, if you read this - Thanks!)
http://www.knoppix.net/forum/viewtopic.php?t=17570
http://www.knoppix.net/forum/viewtopic.php?t=17509
1st) PROBLEM: After apt-get install of MySQL 4.1,the mysql server failed to start when burned to CD.
1st) SOLUTION: The upgraded to MySQL apparently changed the InnoDB configuration. While the databases contained in /var/lib/mysql were copied over to the ram disk and were readable, the new file(s) with ibdata1...3 was a symlink to the /KNOPPIX/var/lib/mysql/ibdata1 and was read only. So I went in to the minirt24 file using the instructions in the above two threads and copied the 'ibdata' file(s) over to the ram disk.
2nd) PROBLEM: Same problem different solution. Now the /var/mysql/log directory didn't exist on the read-only file system, and also wasn't copied over to the writable ram disk.
2nd) SOLUTION: Similar to the first except that instead of copying files I created the needed directory and them copied over to the ram disk.
3rd) PROBLEM: Same problem but now the solution was permissions. The /var/mysql/log directory was owned by root and MySQL couldn't write to them even when on the ramdisk.
3rd) SOLUTION: I tried several times to change the owner and group within the minirt24 file, but the mysql user hasn't been created yet, so attempts to chown/chgrp errored. So I changed the permissions to 777. A more secure solution to a world readable/writable directory would have been to just add the directory when chroot'ed. I just wasn't in the mood and didn't have the time to create an all new compressed file system, and just changing the minirt24 script I only needed to update the md5sums. 
So, putting all this together ... the 4.1 upgrade apparently added some additional logging features and changed the InnoDB configuration which needed to be adjusted for the LiveCD environment.
InnoDB info
http://mysql.netvisao.pt/doc/mysql/e...iguration.html
Similar Threads
-
By adriang in forum Hdd Install / Debian / Apt
Replies: 18
Last Post: 10-28-2005, 09:50 AM
-
By tr in forum Customising & Remastering
Replies: 1
Last Post: 10-02-2005, 07:40 PM
-
By Decibels in forum Customising & Remastering
Replies: 9
Last Post: 01-31-2005, 06:34 AM
-
By lueckmw in forum Customising & Remastering
Replies: 2
Last Post: 10-24-2003, 11:29 PM
-
By mabhatter in forum General Support
Replies: 2
Last Post: 03-14-2003, 12:27 AM
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

TP-Link 5-Port Gigabit Unmanaged Ethernet Switch Network Expansion TL-SG105
$19.95

5Ports Gigabit Network Switch w/ 4 PoE+ Ports Total 52W each port 30W Plug&Play
$31.99

YuanLey 8-Port 10G Ethernet Switch, 6 x 10Gbps RJ45 Ports, 2X 10Gbe SFP+ Ports
$149.99

Cisco Catalyst 2960-48TT-L 48-Port Fast Ethernet Managed Rackmount Switch
$46.99

TP-LINK TL-SG108 8-Port Gigabit Unmanaged Desktop Switch RJ-45 New in Box
$23.99

Netgear PROSAFE 8-Port 10 Gigabit/Multi-Gigabit Ethernet Switch XS508M
$229.99

Linksys 8-Port Managed Gigabit PoE+ Switch 110W w/ 2 Uplink Gigabit - LGS310MPC
$49.05

Arista DCS-7010T-48-R 48P 1GbE 4P 10GbE SFP+ RA Switch with rack mounts
$69.00

NETGEAR 5-Port Gigabit Ethernet Unmanaged Switch (Gs305) - Desktop Quiet Fanless
$22.00

10-Port Gigabit PoE Network Switch with 8 PoE+ Ports with 2 Combo SFP Slots 125W
$39.99