Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Restore of Database Backup
icon3.gif  Restore of Database Backup [message #1571] Fri, 03 August 2007 06:49 Go to next message
trivedi.nikesh is currently offline 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 Go to previous messageGo to next message
Peter is currently offline 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 Go to previous messageGo to next message
trivedi.nikesh is currently offline 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 Go to previous message
Peter is currently offline 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:
  

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

Current Time: Thu Jul 9 20:18:14 EDT 2009

Total time taken to generate the page: 0.00738 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.