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)
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S2 (Serious)
• Version: 5.1.17, 5.0.40
• OS: 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.