Friday, January 1, 2021

Home / Unlabelled / Error: Couldn't read status information for table name

Error: Couldn't read status information for table name

by on

 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:


You May Also Like:
By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • DROP KEY CONSTRAINT IN MYSQL
    Step1 : Firstly you have to take backup current table . create table tb_old like tb_new insert into tb_new select * from tb_old ...
  • MYSQL Case function
        I have one table Student .So i want to fetch data according to percentage  and give remark according to position . set @no=0 ; select @n...
  • How to install mysql in centos
       Step 1: rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm Step 2: sed -i 's/enabled=1/enabled=0/' /etc/y...

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...