Advertisement
scriptz-team

[TUT] DiSABLiNG iNNODB ViA SSH

Jun 12th, 2012
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. _____ _____ _ _____ _____ _____ _____ _____ _____
  2. ___| | __ |_| _ |_ _|___ ___|_ _| __| _ | |
  3. |_ -| --| -| | __| | | |- _|___| | | | __| | | | |
  4. |___|_____|__|__|_|__| |_| |___| |_| |_____|__|__|_|_|_|
  5. |s C R i P T z - T E A M . i N F O|████████████████████████████
  6.  
  7. - iNfO -
  8.  
  9. [TUT] DiSABLiNG iNNODB ViA SSH
  10.  
  11. - NOtIcE -
  12.  
  13. # LOGiN iNTO YOUR SSH CONSOLE
  14.  
  15. Login into mysql:
  16. mysql -u root -p
  17.  
  18. Show engines:
  19. show engines;
  20.  
  21. Quit:
  22. quit
  23.  
  24.  
  25. You will see now:
  26. | InnoDB | Yes | Supports transactions, row-level locking, and foreign keys |
  27.  
  28. So now:
  29. vi /etc/my.cnf
  30.  
  31. Add:
  32. skip-innodb
  33.  
  34. Will looks like:
  35. [mysqld]
  36. datadir=/var/lib/mysql
  37. socket=/var/lib/mysql/mysql.sock
  38. skip-innodb
  39.  
  40. Save:
  41. :w
  42.  
  43. Quit:
  44. :q
  45.  
  46. Restart MySql:
  47. service mysqld restart
  48.  
  49. Now do again:
  50. mysql -u root -p
  51.  
  52. Then:
  53. show engines;
  54.  
  55. And tadaaa:
  56. | InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement