Friday, January 1, 2021

Error: Couldn't read status information for table name

 Table is not found in Database. How to skip table is not exist in database.

mysqldump  -u db_user -p -h 192.168.xx.xx  --routines --column_statistics=0       --no-create-info --no-data --no-create-db --skip-opt  --ignore-table=test.audit  --ignore-table=test.audit_old test --ignore-table=test.blog > test_db_live_proc_funaction_56.sql
Enter password:


No comments:

Post a Comment

How to Find the Third highest salary in mysql

  set @b:=0; set @b1:=3;   # #select distinct salary,@b:=@b+1 as Row_no from emp select  * from emp where salary=( select salary from ( sele...