Bug #27868 Backup with views imports with errors
Submitted: 17 Apr 2007 2:38 Modified: 21 May 2007 23:50
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:5.1.17, 5.0.40 OS:Microsoft Windows (WinXP, Vista)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: Backup, import, MySQL, restore, Views

[17 Apr 2007 2:38] Jared S
Description:
Hi, I have a backup script from a 5.0 database that has 3 views, and it imports to 5.1 server with a error.  I will give you full script. 

How to repeat:
1. Load Query Browser and connect to 5.1 server
2. Open my script file attached
3. Excute scripts

RESULTS scipts runs, but with an error

Suggested fix:
Ensure that views can be imported to 5.1 server
[23 Apr 2007 14:16] MySQL Verification Team
Thank you for the bug report. Are you able to create a dump file
with mysqldump from the database with the missed views and provide
me it. Thanks in advance.
[23 Apr 2007 22:34] Jared S
Original file = Works, but displays erros.
Dump of original file = Works with no erros.
[17 May 2007 2:59] Jared S
Hello - anybody there?
[21 May 2007 7:20] Jared S
+ priority
[21 May 2007 7:31] Jared S
..
[21 May 2007 23:04] Jared S
..
[21 May 2007 23:50] Jared S
The views were linked to each other and there was 1 more issue with selecting null for a integer column.