Friday, January 1, 2021

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

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

by on

 

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





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