jueves, 18 de noviembre de 2010

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

No hay comentarios:

Publicar un comentario