Hello, Can I request help from any mariadb/mysql Guru's pls.
I am new to mariadb administration but have been doing db2 and oracle for quite some time.
I am trying to import a database from a zippedbackup done by mysqldump and is getting the below error.
ERROR 1146 (42S02) at line 4160: Table 'xxx.yyy' doesn't exist
Command I am using is: nohup gunzip < /data/bkups/mysqlbkp-20190916.sql.gz | mysql -u root -p
Mariadb version is: 10.4.7 (latest download)
Backup is made on mariadb version: 10.1.17
The import fails after creating around 15 tables that has over 10k rows in each.
So far - 1. I have run mysqlcheck on the source table xxx.yyy and it came back ok indicating no corruption. 2. I dropped and recreated the table and then took the mysqldump assuming there is some char that is causing the problem. That didnt help either. I also dont see the anything related/usefull to this error in the mariadb documentation.
Please help. Tx