Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql -h "$databaseHost" -u "$username" --password="$password" "$databaseName" < /path/to/project/log.sql
- start transaction;
- insert into demo_table values('abc');
- insert just for to create an error;
- insert into demo_table values('xyz');
- commit;
- rollBack () {
- if [ $mysql_error -eq 1 ]; then
- mysql -h "$databaseHost" -u "$username" --password="$password" "$databaseName" -e "rollback;";
- exit 0;
- fi
- }
- mysql -h "$databaseHost" -u "$username" --password="$password" "$databaseName" < /path/to/project/log.sql|| if [ "$?" -ne 0 ]; then mysql_error=1; rollBack; fi
- DELIMITER $$
- CREATE PROCEDURE sp_exec_dumpfile(
- IN in_file VARCHAR(1024)
- )
- BEGIN
- DECLARE EXIT HANDLER FOR SQLEXCEPTION
- BEGIN
- ROLLBACK;
- END ;
- START TRANSACTION;
- SOURCE in_file;
- COMMIT;
- END $$
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement