# Restore of Database Backup

**URL:** <https://forums.percona.com/t/restore-of-database-backup/402>\
**Category:** Other MySQL® Questions\
**Created:** [August 3, 2007, 5:19am UTC](https://forums.percona.com/t/restore-of-database-backup/402 "2007-08-03T05:19:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![trivedi.nikesh](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@trivedi.nikesh](https://forums.percona.com/u/trivedi.nikesh)\
**Post date:** [August 3, 2007, 5:19am UTC](https://forums.percona.com/t/restore-of-database-backup/402/1 "2007-08-03T05:19:42Z")

</div>

Whenever we try to restore the backup of the database on same database or on another database, then it copy some objects and then it prompt this error message ‘Error occured at:2007-08-03 16:08:35  
Line no.:134  
Error Code: 1303 - Can’t create a TRIGGER from within another stored routine’ and abort the restore process. Please help me on this topic, I am very thankful to you for any kind of help on this topic.

Thanks and Regards,

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 16, 2007, 7:01am UTC](https://forums.percona.com/t/restore-of-database-backup/402/2 "2007-08-16T07:01:14Z")

</div>

Which backup ?

MySQLdump ?

Which MySQL version ?

Which command do you have on the line mentioned ?

---

<div class="post-metadata">

**Author:** ![trivedi.nikesh](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@trivedi.nikesh](https://forums.percona.com/u/trivedi.nikesh)\
**Post date:** [August 16, 2007, 7:55am UTC](https://forums.percona.com/t/restore-of-database-backup/402/3 "2007-08-16T07:55:06Z")

</div>

Which backup ? Backup of a Same database which again I want to restore it on it or to other database.

MySQLdump ? Actually I am using SQLYog and this backup is taken from there of a database.

Which MySQL version ? its 5.1

Which command do you have on the line mentioned ? I am not using any command, I am performing this with help of SQLYog.

First of all I like to say thanks for this considaration, with hope of reply.