MYSQL: ERROR 1049 (42000): Unknown database ‘mysql’
ERROR 1812 (HY000) at line 14534: InnoDB: A general tablespace named `mysql` cannot be found.
#1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
Collation is the assembly of written information into a standard order
dump.sql file in Notepad and hit CTRL+H to find and replace the string “utf8mb4_0900_ai_ci” and replaced it with “utf8mb4_general_ci“
834MB emeditor
7 string were replaced in 0.5seconds 800Mb file.
not responded by notepad or wordpad
upto 500MB 50MB notepad
Notepad ++ to large to open
https://www.emeditor.com/
or sqldumpsplitter
.idb file missing
[Warning] [MY-012049] [InnoDB] Cannot calculate statistics for table `king`.`wp_b3vaaca4kz_options` because the .ibd file is missing
Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting.html for how to resolve the issue.
* Drop the table from the mysql server
* Create a table with similar structure
* alter table discard tablespace
* Move the cfg and ibd files into the data directory(that you have copied from another server)
* Alter table import tablespace
Tablespace is missing for table `king`.`wp_b3vaaca…
king.wp_b3vaaca4kz_afap_logs
repair
error
Corrupt
how to repair corrupt innodb table in mysql?
no idb & db folder in datadirectory
mysqlcheck -c -u root -p –all-databases
king.wp_b3vaaca4kz_redirection_logs
Warning : InnoDB: Tablespace is missing for table king/wp_b3vaaca4kz_redirection_logs.
Warning : InnoDB: Tablespace is missing for table king/wp_b3vaaca4kz_afap_logs.
Error : Tablespace is missing for table `king`.`wp_b3vaaca4kz_afap_logs`.
error : Corrupt
mysql.service: Main process exited, code=exited, status=1/FAILURE
/var/log/mysql
/var/lib/mysql
Cannot load from mysql.proxies_priv. The table is probably corrupted
apparmor=”DENIED” operation=”open” profile=”/usr/sbin/mysqld” name=”/etc/ssl/openssl.cnf”
nano /etc/apparmor.d/usr.sbin.mysqld
/etc/mysql/** r,
/etc/ssl/ r,
/etc/ssl/** r,
1. apparmor_parser -r /etc/apparmor.d/usr.sbin.mysqld
systemctl restart apparmor.service
systemctl stop apparmor.service
service mysql start
SHOW VARIABLES LIKE ‘%ssl%’;
he have_openssl and have_ssl variables are both marked as DISABLED. This means that SSL functionality has been compiled into the server, but that it is not yet enabled.
Check the status of our current connection to confirm:
* \s
1. mysqldump –all-databases –add-drop-database –add-drop-table > databases.sql
GRANT ALL PRIVILEGES ON
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘tolkien’@’%’;
mysql> GRANT ALL PRIVILEGES ON database_name.* TO ‘username’@’localhost’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’;
