Friday, January 1, 2021

How to take stored procedure & function backup in mysql using command line in linux

 

We are taking backup only function & store procedure from mysql database.

[root@VMs]# mysqldump  -u db_user -p -h 192.168.101.51 --routines --column_statistics=0 --no-create-info --no-data --no-create-db --skip-opt mydb > mydb_live_proc_funaction.sql





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