MySQL Performance: MySQL => Restore of Database Backup

Members

Help

Home

Home » Performance » MySQL » Restore of Database Backup

Show: Today's Messages :: Show Polls :: Message Navigator

Restore of Database Backup [message #1571]

Fri, 03 August 2007 06:49

trivedi.nikesh
Messages: 2
Registered: August 2007
Location: india

Junior Member

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,

Trivedi Nikesh

Database Engineer
+919911571180
www.rightwave.com

Report message to a moderator

Re: Restore of Database Backup [message #1596 is a reply to message #1571 ]

Thu, 16 August 2007 08:31

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Which backup ?

MySQLdump ?

Which MySQL version ?

Which command do you have on the line mentioned ?

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Restore of Database Backup [message #1608 is a reply to message #1596 ]

Thu, 16 August 2007 09:25

trivedi.nikesh
Messages: 2
Registered: August 2007
Location: india

Junior Member

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.

Trivedi Nikesh

Database Engineer
+919911571180
www.rightwave.com

Report message to a moderator

Re: Restore of Database Backup [message #1611 is a reply to message #1608 ]

Thu, 16 August 2007 10:41

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

I see.

It would be good to see what is in the dump created by SQLYog by at this line so we can check if this is expected error and SQLYog bug or MySQL issue.

Which 5.1 ? This is beta version so exact version is especially important.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	Sporadically slow MyISAM inserts
Next Topic:	MySQL database for genome expression studies

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 8 22:00:29 EST 2009

Total time taken to generate the page: 0.02402 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.