The Lazy Admin Blog

Archives

InnoDB: Failed to find tablespace for table `X` in the cache

September 30, 2022 MySQL 1 Comment

MySQL service fails to start with the error “InnoDB: Failed to find tablespace for table `X` in the cache” – 2021-02-15 22:00:01 8 [ERROR] InnoDB: Failed to find tablespace for table `X`.`Y` in the cache. Attempting to load the tablespace

Continue Reading InnoDB: Failed to find tablespace for table `X` in the cache

Create MySQL database & user from cli

April 14, 2016 MySQL Leave a Comment

The following script creates a MySQL database & a user who will be assigned as a privileged user to the db. We used the following credentials for this example – Database name: mysite_db Database user: mysite_user Database password: mypassword ##

Continue Reading Create MySQL database & user from cli

Automated MySQL Installation

April 14, 2016 CentOS, MySQL Leave a Comment

Here is a nice “Copy & Paste” script that you can use for installing MySQL. This script skips the “mysql_secure_installation” part, in which you need to answer questions, and simply inserts all the needed information directly into the database. This

Continue Reading Automated MySQL Installation

Search Our Blog

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories
Apache
CentOS
CloudLinux
cPanel
Emails
ESXI
iSCSI
JetBackup
Linux
Litespeed
MySQL
NGINX
Oracle
Reduxio
Security
SSL
Uncategorized
VMware
Wordpress
XEN

Tags

apache aspx backup bash CentOS cloudlinux cPanel CXS Emails freetds google htaccess IMAP InnoDB iscsi JetBackup Libmodsecurity litespeed modsec modsecurity mssql MySQL netapp nginx odbc Oracle php php.ini phpselector rsync ssh ssmtp systemd threads VMFS WHM Wordpress xenserver

Popular Posts

  • Convert JetBackup to cPanel structure October 6, 2022
  • How To Install & Configure a Galera Cluster with MariaDB on Centos 7 February 6, 2018
  • Allow a cPanel server to run a VHOST from multiple IP addresses April 3, 2018
  • rsync without prompting for password October 10, 2022

Recent Posts

  • Understanding Why More Threads Can Sometimes Slow Down Performance October 9, 2024
  • Set up a new systemd service May 18, 2024
  • Bash Arrays November 7, 2023
  • rsync without prompting for password October 10, 2022

Recent Comments

  • Sven on rsync without prompting for password
  • TheLazyAdmin on rsync without prompting for password
  • Sven on rsync without prompting for password
  • TheLazyAdmin on Convert JetBackup to cPanel structure
  • Chris on Convert JetBackup to cPanel structure
Privacy Policy • Contact