Respaldar Y Restaurar BD

URL DEL VIDEO: http://www.youtube.com/watch?v=cpJ218wrMnM

Profe disculpe por la tardanza de mi subir mi video s q tuve problemas con mysql y luego con la base de datos asi que tuve que corregirlos para que pueda funcionar pero al fin lo termine y pues el link del video es el que esta arriba.

Codigo Para Crear Usuarios Y Respaldar BD

grant all privileges on corrida.toros to jordan@'%' identified by 'jordan';
grant lock tables on corrida.* to jordan@'%' identified by 'jordan';
grant select on corrida.toreros to juan@'%' identified by 'juan';
grant lock tables on corrida.* to juan@'%' identified by 'juan';

mysqldump -u jordan -pjordan -h 192.168.210.73 corrida[toros] >D:respaldo.sql
mysqldump -u juan -pjuan -h 192.168.210.73 corrida[toreros] >D:respaldo1.sql

Script Para Insertar Las Fiestas En La BD

insert into fiestas values(1,002,003,001);
insert into fiestas values(8,002,003,001);
insert into fiestas values(14,002,004,001);
insert into fiestas values(9,002,004,001);
insert into fiestas values(7,002,001,001);
insert into fiestas values(5,002,001,001);
insert into fiestas values(2,001,001,002);
insert into fiestas values(11,001,001,002);
insert into fiestas values(4,001,002,002);
insert into fiestas values(18,001,002,002);
insert into fiestas values(3,001,004,002);
insert into fiestas values(16,001,004,002);
insert into fiestas values(13,002,005,003);
insert into fiestas values(10,002,005,003);
insert into fiestas values(6,002,002,003);
insert into fiestas values(17,002,002,003);
insert into fiestas values(15,002,003,003);
insert into fiestas values(12,002,003,003);
insert into fiestas values(19,002,003,003);

Triggers De La BD

delimiter //
create trigger bdganaderia before delete on ganaderia for each row
begin
delete from toros where id_ganaderia=OLD.id_ganaderia;
end //

delimiter //
create trigger bdapoderado before delete on apoderado for each row
begin
delete from torero where id_apoderado=OLD.id_apoderado;
end //

Script De Para Insertar Apoderados, Toreros, Plazas Y Padrinos A La BD

insert into apoderado values(001,"BARV650909","Vicente Barrera","Torre Sur 41071","95-556-92-46");
insert into apoderado values(002,"VENJ761021","Jose Carlos Venegas","Pontevedra Plaza De España 36002","95-556-21-38");

insert into torero values(001,001,"ROPJ891002","Jose Antonio Rodriguez Perez","Jose Antonio Campuzano",0);
insert into torero values(002,001,"PERJ781212","Jose Miguel Perez","Joselillo",0);
insert into torero values(003,001,"LODE690124","Eulalio Lopez Diaz","El Zotoluco",1);
insert into torero values(004,002,"RURJ910131","Juan Antonio Ruiz Roman","Espartaco",0);
insert into torero values(005,002,"ROSM881122","Manuel Rodriguez Sanchez","Manolete",1);

insert into plazas values(001,"Plaza De Toros De Pinos Puente","Granada,España","San Jeronimo 27",3000);
insert into plazas values(002,"Plaza Monumental De Barcelona","Barcelona,España","Gran Via Corts Catalanes,749",19582);

insert into padrino values("2001-03-05",null,003);
insert into padrino values("2008-08-21",003,005);

Script De Para Insertar Ganaderias Y Toros A La BD

insert into ganaderia values(1,"LAHERRADURRA","Granada","2000-01-01");
insert into ganaderia values(2,"ENCINO","Sevilla","1997-05-28");
insert into ganaderia values(3,"VALLADOLID","Barcelona","2002-03-13");

insert into toros values(1,1,2007,"Pajarito","Negro",1);
insert into toros values(2,1,2008,"Bravo","Cafe",2);
insert into toros values(3,1,2008,"Luz","Gris",3);
insert into toros values(4,1,2007,"Toribio","Negro",4);
insert into toros values(5,1,2008,"Negro","Negro",5);

insert into toros values(6,2,2008,"Solitario","Negro",6);
insert into toros values(7,2,2010,"Loco","Gris",7);
insert into toros values(8,2,2007,"Expo","Negro",8);
insert into toros values(9,2,2008,"Maltrata","Gris",9);
insert into toros values(10,2,2009,"Sevilla","Cafe",10);
insert into toros values(11,2,2008,"Tarado","Negro",11);
insert into toros values(12,2,2007,"Pinto","Cafe",12);

insert into toros values(13,3,2008,"Tieso","Gris",13);
insert into toros values(14,3,2009,"Testa","Gris",14);
insert into toros values(15,3,2008,"Minotauro","Negro",15);
insert into toros values(16,3,2009,"Chocolate","Cafe",16);
insert into toros values(17,3,2007,"Ventorrillo","Negro",17);
insert into toros values(18,3,2008,"Ymbro","Negro",18);
insert into toros values(19,3,2009,"Tajo","Negro",19);

CODIGO DE LA BASE DE DATOS

create database corrida;
show databases;
use corrida;
show tables;
create table corrida (
id_corrida tinyint(3) not null,
num_orden tinyint(3) not null,
feria char(30) not null,
ano year not null, primary key (id_corrida))engine=innodb;

create table apoderado (
id_apoderado tinyint(3) not null,
rfc char(10) not null,
nombre char(50) not null,
direccion char(40) not null,
telefono char(15), primary key (id_apoderado))engine=innodb;

create table plazas (
id_plazas tinyint(3) not null,
nombre char(30) not null,
localidad char(20) not null,
direccion char(40) not null,
aforo int, primary key (id_plazas))engine=innodb;

create table ganaderia (
id_ganaderia tinyint(3) not null,
codigo char(15) not null,
localidad char(30) not null,
antiguedad date, primary key (id_ganaderia))engine=innodb;

create table premios (
id_premios tinyint(3) not null,
orejas tinyint(3),
rabo tinyint(3),
puerta_grande bool not null, primary key (id_premios))engine=innodb;

create table torero (
id_torero tinyint(3) not null,
id_apoderado tinyint(3) not null,
rfc char(10) not null,
nombre char(50),
apodo char(15) not null,
padrino bool not null, primary key (id_torero),
index(id_apoderado),
foreign key (id_apoderado) references apoderado (id_apoderado) on delete set null on update restrict)engine=innodb;

create table padrino (
fecha_matador date not null,
id_torero tinyint(3) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update cascade)engine=innodb;

create table toros(
num_orden tinyint(3) not null,
id_ganaderia tinyiint(3) not null,
ano_nac year,
nombre char(20) not null,
color char(10),
orden_toreado tinyint(3) not null,
index (id_ganaderia),
foreign key (id_ganaderia) references ganaderia (id_ganaderia) on delete set null on update restrict)engine=innodb;

create table fiestas(
num_orden tinyint(3) not null,
index (num_orden),
foreign key (num_orden) references toros (num_orden) on delete cascade on update cascade,
id_plazas tinyint(3),
index (id_plazas),
foreign key (id_plazas) references plazas (id_plazas) on delete set null on update restrict,
id_torero tinyint(3),
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete set null on update cascade,
id_corrida tinyint(3) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;

create table premio_torero(
id_premios tinyint(3) not null,
index (id_premios),
foreign key (id_premios) references premios (id_premios) on delete cascade on update restrict,
id_torero tinyint(3) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update restrict,
id_corrida tinyint(3) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;