Tarea Respaldo y Restauracion Remota

1.Respaldar una tabla de una Base de datos Remotamente con estructura.
2.Restaurar la BD a otro servidor.
3.Respaldar una tabla de una BD remota sin estructura.
4.Restaurar la información de dicha tabla de la BD a otro servidor.

Creacion de usuarios

1.-grant all on fiesta to administrador@'localhost' identified by '1234';

2.-grant update, select on fiesta.apoderado to apoderado@'localhost' identified by '12345';
grant insert, delete on fiesta.torero to apoderado@'localhost' identified by '12345';

3.-grant insert, delete on fiesta.ganaderia to ganadero@'localhost' identified by '123456';

4.-grant insert, update, delete on fiesta.corrida to organizador@'localhost' identified by '1234567';

Tarea. Vistas

1.- create view toreropre as select a.Nombre,b.Nom_feria,
b.Orejas,b.Rabo,b.Salida from torero a, premio b where a.RFC_torero=b.RFC_torero order by b.Nom_feria;

2.-create view ganade as select a.Cod_ganaderia,b.Nom_ganaderia,a.Nom_feria,count(*) as Total from toro a, ganaderia b where a.Cod_ganaderia=b.Cod_ganaderia
group by a.Cod_ganaderia,a.Nom_feria order by a.Nom_feria;

3.-create view apodado as select c.RFC_apoderado,c.Nombre,a.Nom_feria,count(*) as Total from premio a, torero b, apoderado c
where a.RFC_torero=b.RFC_torero and b.RFC_apoderado=c.RFC_apoderado group by a.Nom_feria, c.RFC_apoderado order by a.Nom_feria;

4.- create view edad as select Nombre,
(year(Anio)- year (Anio_nacimiento)) -(right(Anio,5) as Edad,month(Anio_nacimiento) as Mes from toro;

5.-create view padrino as select a.RFC_torero,a.Nombre,b.Nombre as Nombre_padrino from torero a, torero b where
b.RFC_torero=a.RFC_padrino group by a.Nombre,b.RFC_torero;