Bug #27868 Backup with views imports with errors
Submitted: 17 Apr 2007 4:38 Modified: 22 May 2007 1:50
Reporter: Jared Sullivan (Silver Quality Contributor)
Status: Closed
Category:Server: Backup Severity:S2 (Serious)
Version:5.1.17, 5.0.40 OS:Microsoft Windows (WinXP, Vista)
Assigned to: Miguel Solorzano Target Version:
Tags: MySQL, Backup, import, Views, restore

[17 Apr 2007 4:38] Jared Sullivan 
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 16:16] Miguel Solorzano 
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.
[24 Apr 2007 0:34] Jared Sullivan 
Original file = Works, but displays erros.
Dump of original file = Works with no erros.
[17 May 2007 4:59] Jared Sullivan 
Hello - anybody there?
[21 May 2007 9:20] Jared Sullivan 
+ priority
[21 May 2007 9:31] Jared Sullivan 
..
[22 May 2007 1:04] Jared Sullivan 
..
[22 May 2007 1:50] Jared Sullivan 
The views were linked to each other and there was 1 more issue with selecting null for a
integer column.