MySQL Forums
Forum List  »  MySQL Administrator

Restore of views fails with errors
Posted by: Mike Lush
Date: October 07, 2005 03:30PM

MySQL Newbie question

Using MySQL v5.0.13-rc-nt via TCP/IP on Windows XP Pro SP2, MySQL Administrator 1.1.3 login as `root`

Having run a backup to file of database (simple single table and a series of views. A full restore from backup was tested.

The table is restored complete and without error.

But ... none of the views are restored.

As the SQL was generated by the backup why / where is it in error?:

Error message (similar repeated for each view):
<==
Warning: Do not know how to handle this statement at line xxxx:
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tadman`.`v_not_transferred` AS select `tadman`.`tad_transfers`.`clientid` AS `clientid`,`tadman`.`tad_transfers`.`clientcode` AS `clientcode`,`tadman`.`tad_transfers`.`clientname` AS `clientname`,`tadman`.`tad_transfers`.`entity` AS `entity`,`tadman`.`tad_transfers`.`contactname` AS `contactname`,`tadman`.`tad_transfers`.`clientaddress` AS `clientaddress`,`tadman`.`tad_transfers`.`phone` AS `phone`,`tadman`.`tad_transfers`.`mobile` AS `mobile`,`tadman`.`tad_transfers`.`approval` AS `approval`,`tadman`.`tad_transfers`.`contactdate` AS `contactdate`,`tadman`.`tad_transfers`.`contactnote` AS `contactnote` from `tadman`.`tad_transfers` where (`tadman`.`tad_transfers`.`approval` = _latin1'Unknown') order by `tadman`.`tad_transfers`.`clientcode`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
==>
Does this warrant a bug report?

Options: ReplyQuote


Subject
Written By
Posted
Restore of views fails with errors
October 07, 2005 03:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.