Overclock.net › Forums › Specialty Builds › Servers › How To: Enable InnoDB on startup
New Posts  All Forums:Forum Nav:

How To: Enable InnoDB on startup

post #1 of 2
Thread Starter 
If InnoDB isn't starting up on start up then navigate to the /etc folder.

In there open up with your favourite editor, the file 'my.ini' or 'my.cnf'.

Or for short:
nano /etc/my.cnf

Once you are in there search for 'skip-innodb'.

If it is there then delete the line & restart MySQL:

/sbin/service mysql restart

To check if it is enabled:

mysql

Then type:

show engines;

Support = "YES". This means InnoDB is enabled.

CentOS.
DavidE-PC
(14 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X6 1055T 3.5Ghz Asus M4A88T-V EVO USB3 XFX ATI Radeon HD 4890 1GB HD4890 GDDR5 PCI-E Corsair Vengeance 2x4GB (8GB) 1600MHz 9-9-9-24 ... 
Hard DriveOptical DriveOSMonitor
WD Caviar - 7,200RPM 16MB Cache - SATA 2 - 320GB Sony Optiarc DVD-RW SATA Windows 7 Ultimate 64-bit SP1 LG Flatron E2260 
KeyboardPowerCaseMouse
Microsoft Sidewinder x6 Arctic Power 700W Antec 902 Microsoft Wireless Laser Desktop 6000 v3 
Mouse PadAudio
N/A Panasonic SC-PT870 1000w Home Cinema 
  hide details  
Reply
DavidE-PC
(14 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X6 1055T 3.5Ghz Asus M4A88T-V EVO USB3 XFX ATI Radeon HD 4890 1GB HD4890 GDDR5 PCI-E Corsair Vengeance 2x4GB (8GB) 1600MHz 9-9-9-24 ... 
Hard DriveOptical DriveOSMonitor
WD Caviar - 7,200RPM 16MB Cache - SATA 2 - 320GB Sony Optiarc DVD-RW SATA Windows 7 Ultimate 64-bit SP1 LG Flatron E2260 
KeyboardPowerCaseMouse
Microsoft Sidewinder x6 Arctic Power 700W Antec 902 Microsoft Wireless Laser Desktop 6000 v3 
Mouse PadAudio
N/A Panasonic SC-PT870 1000w Home Cinema 
  hide details  
Reply
post #2 of 2
put the command you want to auto start in /etc/rc.local upon system boot
up all commands/script you put there will be automatically executed before it
reaches the login.


hth
Athena
(14 items)
 
Achilles
(9 items)
 
 
CPUMotherboardGraphicsHard Drive
[Intel] i5 2500k  [ASUS] p8p67 Evo B3 [EVGA] GTX 680 [Samsung] 1TB 
CoolingOSMonitorKeyboard
[Noctua] NH-D14 [Micro$oft] Win7 64-bit/Linux [HP] 2311x [Logitech] G510 
PowerCaseMouse
[XFX] 650W [Cooler Master] HAF X [Logitech] G400 
CPUMotherboardGraphicsRAM
990X 6.5Ghz EVGA X58 3 way SLI classified XFX GT 240/modded 8800GTS/8800GTX/5870/4980/FIR... Corsair Dominator PSC  
CoolingOSMonitorCase
F1 Extreme Dark, DICE and LN2!! XPeeeee and Win 7 Old CRT Open 
  hide details  
Reply
Athena
(14 items)
 
Achilles
(9 items)
 
 
CPUMotherboardGraphicsHard Drive
[Intel] i5 2500k  [ASUS] p8p67 Evo B3 [EVGA] GTX 680 [Samsung] 1TB 
CoolingOSMonitorKeyboard
[Noctua] NH-D14 [Micro$oft] Win7 64-bit/Linux [HP] 2311x [Logitech] G510 
PowerCaseMouse
[XFX] 650W [Cooler Master] HAF X [Logitech] G400 
CPUMotherboardGraphicsRAM
990X 6.5Ghz EVGA X58 3 way SLI classified XFX GT 240/modded 8800GTS/8800GTX/5870/4980/FIR... Corsair Dominator PSC  
CoolingOSMonitorCase
F1 Extreme Dark, DICE and LN2!! XPeeeee and Win 7 Old CRT Open 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › How To: Enable InnoDB on startup