Yep, sure do:

mysql> show create table BlogPostsView\G
*************************** 1. row ***************************
                View: BlogPostsView
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `BlogPostsView` AS select `BlogPosts`.`postID` AS `postid`,`BlogPosts`.`title` AS `title`,`BlogPosts`.`body` AS `body`,`BlogCategories`.`name` AS `category`,`BlogMoods`.`name` AS `mood`,`BlogPosts`.`postTime` AS `posttime`,`BlogPosts`.`lastModified` AS `lastmodified`,`BlogPosts`.`status` AS `status`,`BlogPosts`.`commentCount` AS `commentcount` from ((`BlogPosts` join `BlogMoods` on((`BlogMoods`.`moodID` = `BlogPosts`.`moodID`))) join `BlogCategories` on((`BlogCategories`.`categoryID` = `BlogPosts`.`categoryID`)))
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.01 sec)



mysql> show create table PhotoDawgPhotoView\G
*************************** 1. row ***************************
                View: PhotoDawgPhotoView
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `PhotoDawgPhotoView` AS select `PhotoDawgPhotos`.`photoID` AS `photoID`,`PhotoDawgLenses`.`lensID` AS `lensID`,`PhotoDawgPhotoDetails`.`title` AS `title`,`PhotoDawgPhotoDetails`.`caption` AS `caption`,`PhotoDawgPhotos`.`filename` AS `filename`,`PhotoDawgPhotos`.`takenOn` AS `takenOn`,`PhotoDawgPhotos`.`ranking` AS `ranking`,`PhotoDawgPhotoDetails`.`cameraMake` AS `cameraMake`,`PhotoDawgPhotoDetails`.`cameraModel` AS `cameraModel`,`PhotoDawgPhotoDetails`.`isoSpeed` AS `isoSpeed`,`PhotoDawgPhotoDetails`.`exposureTime` AS `exposureTime`,`PhotoDawgPhotoDetails`.`exposureValue` AS `exposureValue`,`PhotoDawgPhotoDetails`.`aperture` AS `aperture`,`PhotoDawgPhotoDetails`.`maxAperture` AS `maxAperture`,`PhotoDawgPhotoDetails`.`focalLength` AS `focalLength`,`PhotoDawgPhotoDetails`.`flash` AS `flash`,`PhotoDawgLenses`.`lensName` AS `lensUsed` from ((`PhotoDawgPhotos` left join `PhotoDawgPhotoDetails` on((`PhotoDawgPhotoDetails`.`photoID` = `PhotoDawgPhotos`.`photoID`))) left join `PhotoDawgLenses` on((`PhotoDawgLenses`.`lensID` = `PhotoDawgPhotoDetails`.`lensID`)))
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.00 sec)



I know these won't carry over, though. I assumed drizzledump would just ignore these?



On Oct 1, 2010, at 11:05 AM, Andrew Hutchings wrote:

> A thought occurs, do you have any VIEWS in you DB?
> 
> -- 
> Segfault when dumping schema with drizzledump
> https://bugs.launchpad.net/bugs/652990
> You received this bug notification because you are a direct subscriber
> of the bug.
> 
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications: New
> 
> Bug description:
> After figuring out my permissions issues (see https://bugs.launchpad.net/drizzle/+bug/652645), I am now getting a segmentation fault when trying to dump out my MySQL schema using 'drizzledump':
> 
> 
> root@mcp:~# drizzledump -p3306 -uroot -P<omitted>
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost    Database: moocowproductions
> -- ------------------------------------------------------
> -- Server version	5.1.41-3ubuntu12.6 (MySQL server)
> 
> Segmentation fault
> 
> 
> Here is an strace:
> 
> 
> root@mcp:~# strace drizzledump -p3306 -uroot -P<omitted>
> execve("/usr/bin/drizzledump", ["drizzledump", "-p3306", "-uroot", "-PtD2sMQamlWnZZuCd", "moocowproductions"], [/* 14 vars */]) = 0
> brk(0)                                  = 0x1b27000
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd1000
> access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
> open("/etc/ld.so.cache", O_RDONLY)      = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
> mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libz.so.1", O_RDONLY)        = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\"\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=92752, ...}) = 0
> mmap(NULL, 2187792, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c79c000
> mprotect(0x7fb76c7b2000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c9b1000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76c9b1000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libdrizzle.so.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240Q\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=80744, ...}) = 0
> mmap(NULL, 2175856, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c588000
> mprotect(0x7fb76c59b000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c79a000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x12000) = 0x7fb76c79a000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_program_options.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\v\2\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=319896, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbc1000
> mmap(NULL, 2415096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c33a000
> mprotect(0x7fb76c385000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c584000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4a000) = 0x7fb76c584000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_thread.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\260\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=88920, ...}) = 0
> mmap(NULL, 2184088, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c124000
> mprotect(0x7fb76c138000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c337000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fb76c337000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_regex.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\272\4\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=992320, ...}) = 0
> mmap(NULL, 3087928, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76be32000
> mprotect(0x7fb76bf1d000, 2097152, PROT_NONE) = 0
> mmap(0x7fb76c11d000, 28672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xeb000) = 0x7fb76c11d000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_date_time.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\231\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=76400, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbc0000
> mmap(NULL, 2171488, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76bc1f000
> mprotect(0x7fb76bc30000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76be2f000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x10000) = 0x7fb76be2f000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_filesystem.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200\227\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=84992, ...}) = 0
> mmap(NULL, 2180304, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76ba0a000
> mprotect(0x7fb76ba1d000, 2097152, PROT_NONE) = 0
> mmap(0x7fb76bc1d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fb76bc1d000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libboost_system.so.1.40.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\24\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=14560, ...}) = 0
> mmap(NULL, 2109704, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b806000
> mprotect(0x7fb76b809000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76ba08000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fb76ba08000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/librt.so.1", O_RDONLY)       = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220!\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=31744, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbf000
> mmap(NULL, 2128848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b5fe000
> mprotect(0x7fb76b605000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76b804000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x7fb76b804000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libstdc++.so.6", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\244\5\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=1044112, ...}) = 0
> mmap(NULL, 3223608, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b2ea000
> mprotect(0x7fb76b3e0000, 2097152, PROT_NONE) = 0
> mmap(0x7fb76b5e0000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf6000) = 0x7fb76b5e0000
> mmap(0x7fb76b5e9000, 81976, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76b5e9000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libm.so.6", O_RDONLY)        = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360>\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=534832, ...}) = 0
> mmap(NULL, 2629864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b067000
> mprotect(0x7fb76b0e9000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76b2e8000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x81000) = 0x7fb76b2e8000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libgcc_s.so.1", O_RDONLY)    = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200-\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=92552, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbe000
> mmap(NULL, 2188280, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76ae50000
> mprotect(0x7fb76ae66000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76b065000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76b065000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libc.so.6", O_RDONLY)        = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\355\1\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0755, st_size=1572232, ...}) = 0
> mmap(NULL, 3680296, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76aacd000
> mprotect(0x7fb76ac47000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76ae46000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x179000) = 0x7fb76ae46000
> mmap(0x7fb76ae4b000, 18472, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76ae4b000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libpthread.so.0", O_RDONLY)  = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360Y\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0755, st_size=135745, ...}) = 0
> mmap(NULL, 2212736, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76a8b0000
> mprotect(0x7fb76a8c8000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76aac7000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x7fb76aac7000
> mmap(0x7fb76aac9000, 13184, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76aac9000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libicudata.so.42", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\350\2\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=16012096, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbd000
> mmap(NULL, 18108416, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76976b000
> mprotect(0x7fb76a6b0000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76a8af000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf44000) = 0x7fb76a8af000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libicui18n.so.42", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200Y\6\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=1799848, ...}) = 0
> mmap(NULL, 3897408, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb7693b3000
> mprotect(0x7fb76955d000, 2097152, PROT_NONE) = 0
> mmap(0x7fb76975d000, 53248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1aa000) = 0x7fb76975d000
> mmap(0x7fb76976a000, 2112, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76976a000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/usr/lib/libicuuc.so.42", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200/\4\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=1413488, ...}) = 0
> mmap(NULL, 3516704, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb769058000
> mprotect(0x7fb7691a0000, 2097152, PROT_NONE) = 0
> mmap(0x7fb7693a0000, 69632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x148000) = 0x7fb7693a0000
> mmap(0x7fb7693b1000, 6432, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb7693b1000
> close(3)                                = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbc000
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbb000
> mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbb9000
> arch_prctl(ARCH_SET_FS, 0x7fb76cbb9720) = 0
> mprotect(0x7fb7693a0000, 57344, PROT_READ) = 0
> mprotect(0x7fb76975d000, 40960, PROT_READ) = 0
> mprotect(0x7fb76a8af000, 4096, PROT_READ) = 0
> mprotect(0x7fb76aac7000, 4096, PROT_READ) = 0
> mprotect(0x7fb76ae46000, 16384, PROT_READ) = 0
> mprotect(0x7fb76b065000, 4096, PROT_READ) = 0
> mprotect(0x7fb76b2e8000, 4096, PROT_READ) = 0
> mprotect(0x7fb76b5e0000, 28672, PROT_READ) = 0
> mprotect(0x7fb76b804000, 4096, PROT_READ) = 0
> mprotect(0x7fb76ba08000, 4096, PROT_READ) = 0
> mprotect(0x7fb76bc1d000, 4096, PROT_READ) = 0
> mprotect(0x7fb76be2f000, 8192, PROT_READ) = 0
> mprotect(0x7fb76c11d000, 20480, PROT_READ) = 0
> mprotect(0x7fb76c337000, 8192, PROT_READ) = 0
> mprotect(0x7fb76c584000, 12288, PROT_READ) = 0
> mprotect(0x7fb76c79a000, 4096, PROT_READ) = 0
> mprotect(0x7fb76c9b1000, 4096, PROT_READ) = 0
> mprotect(0x653000, 4096, PROT_READ)     = 0
> mprotect(0x7fb76cbd3000, 4096, PROT_READ) = 0
> munmap(0x7fb76cbc2000, 58632)           = 0
> set_tid_address(0x7fb76cbb99f0)         = 18219
> set_robust_list(0x7fb76cbb9a00, 0x18)   = 0
> futex(0x7ffff0de373c, FUTEX_WAKE_PRIVATE, 1) = 0
> futex(0x7ffff0de373c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7fb76cbb9720) = -1 EAGAIN (Resource temporarily unavailable)
> rt_sigaction(SIGRTMIN, {0x7fb76a8b5870, [], SA_RESTORER|SA_SIGINFO, 0x7fb76a8bf8f0}, NULL, 8) = 0
> rt_sigaction(SIGRT_1, {0x7fb76a8b5900, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7fb76a8bf8f0}, NULL, 8) = 0
> rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
> getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
> brk(0)                                  = 0x1b27000
> brk(0x1b48000)                          = 0x1b48000
> futex(0x7fb76b5e9b88, FUTEX_WAKE_PRIVATE, 2147483647) = 0
> open("~/.config/drizzle/drizzledump.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
> open("~/.config/drizzle/client.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
> open("/etc/drizzle/drizzledump.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
> open("/etc/drizzle/client.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
> socket(PF_NETLINK, SOCK_RAW, 0)         = 3
> bind(3, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
> getsockname(3, {sa_family=AF_NETLINK, pid=18219, groups=00000000}, [12]) = 0
> gettimeofday({1285939136, 123304}, NULL) = 0
> sendto(3, "\24\0\0\0\26\0\1\3\300\337\245L\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
> recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0\300\337\245L+G\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 168
> recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0\300\337\245L+G\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 192
> recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\300\337\245L+G\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
> close(3)                                = 0
> socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
> connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
> close(3)                                = 0
> socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
> connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
> close(3)                                = 0
> open("/etc/nsswitch.conf", O_RDONLY)    = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=475, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> read(3, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 475
> read(3, "", 4096)                       = 0
> close(3)                                = 0
> munmap(0x7fb76cbd0000, 4096)            = 0
> open("/etc/host.conf", O_RDONLY)        = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=92, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> read(3, "# The \"order\" line is only used "..., 4096) = 92
> read(3, "", 4096)                       = 0
> close(3)                                = 0
> munmap(0x7fb76cbd0000, 4096)            = 0
> futex(0x7fb76ae4e2e4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
> open("/etc/resolv.conf", O_RDONLY)      = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=47, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> read(3, "nameserver 72.3.128.240\nnameserv"..., 4096) = 47
> read(3, "", 4096)                       = 0
> read(3, "", 4096)                       = 0
> close(3)                                = 0
> munmap(0x7fb76cbd0000, 4096)            = 0
> uname({sys="Linux", node="mcp.moocowproductions.org", ...}) = 0
> open("/etc/ld.so.cache", O_RDONLY)      = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
> mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
> close(3)                                = 0
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
> open("/lib/libnss_files.so.2", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p!\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=51712, ...}) = 0
> mmap(NULL, 2147720, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb768e4b000
> mprotect(0x7fb768e57000, 2093056, PROT_NONE) = 0
> mmap(0x7fb769056000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xb000) = 0x7fb769056000
> close(3)                                = 0
> mprotect(0x7fb769056000, 4096, PROT_READ) = 0
> munmap(0x7fb76cbc2000, 58632)           = 0
> open("/etc/hosts", O_RDONLY|O_CLOEXEC)  = 3
> fcntl(3, F_GETFD)                       = 0x1 (flags FD_CLOEXEC)
> fstat(3, {st_mode=S_IFREG|0644, st_size=336, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> read(3, "127.0.0.1     localhost localhos"..., 4096) = 336
> read(3, "", 4096)                       = 0
> close(3)                                = 0
> munmap(0x7fb76cbd0000, 4096)            = 0
> open("/etc/gai.conf", O_RDONLY)         = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=2987, ...}) = 0
> fstat(3, {st_mode=S_IFREG|0644, st_size=2987, ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> read(3, "# Configuration for getaddrinfo("..., 4096) = 2987
> read(3, "", 4096)                       = 0
> close(3)                                = 0
> munmap(0x7fb76cbd0000, 4096)            = 0
> futex(0x7fb76ae4ce04, FUTEX_WAKE_PRIVATE, 2147483647) = 0
> socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 3
> connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
> getsockname(3, {sa_family=AF_INET, sin_port=htons(35014), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
> close(3)                                = 0
> socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 3
> connect(3, {sa_family=AF_INET6, sin6_port=htons(3306), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = 0
> getsockname(3, {sa_family=AF_INET6, sin6_port=htons(42320), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, [28]) = 0
> close(3)                                = 0
> socket(PF_INET6, SOCK_STREAM, IPPROTO_TCP) = 3
> setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
> setsockopt(3, SOL_SOCKET, SO_LINGER, {onoff=1, linger=10}, 8) = 0
> setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
> setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
> setsockopt(3, SOL_SOCKET, SO_SNDBUF, [32768], 4) = 0
> setsockopt(3, SOL_SOCKET, SO_RCVBUF, [32768], 4) = 0
> fcntl(3, F_GETFL)                       = 0x2 (flags O_RDWR)
> fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
> connect(3, {sa_family=AF_INET6, sin6_port=htons(3306), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = -1 EINPROGRESS (Operation now in progress)
> poll([{fd=3, events=POLLOUT}], 1, -1)   = 1 ([{fd=3, revents=POLLERR|POLLHUP}])
> close(3)                                = 0
> socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 3
> setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
> setsockopt(3, SOL_SOCKET, SO_LINGER, {onoff=1, linger=10}, 8) = 0
> setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
> setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
> setsockopt(3, SOL_SOCKET, SO_SNDBUF, [32768], 4) = 0
> setsockopt(3, SOL_SOCKET, SO_RCVBUF, [32768], 4) = 0
> fcntl(3, F_GETFL)                       = 0x2 (flags O_RDWR)
> fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
> connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EINPROGRESS (Operation now in progress)
> poll([{fd=3, events=POLLOUT}], 1, -1)   = 1 ([{fd=3, revents=POLLOUT}])
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "@\0\0\0\n5.1.41-3ubuntu12.6\0\227\1\0\0QXE/"..., 32768, 0, NULL, NULL) = 68
> sendto(3, ";\0\0\1\5\242\0\0\377\377\377\377\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 63, 0, NULL, 0) = 63
> recvfrom(3, "\7\0\0\2\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
> sendto(3, "\21\0\0\0\3SET NAMES 'utf8'", 21, 0, NULL, 0) = 21
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
> fstat(1, {st_mode=S_IFCHR|0600, st_rdev=makedev(136, 0), ...}) = 0
> mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
> write(1, "-- drizzledump 2010.09.1802 libd"..., 68-- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> ) = 68
> write(1, "--\n", 3--
> )                     = 3
> write(1, "-- Host: localhost    Database: "..., 50-- Host: localhost    Database: moocowproductions
> ) = 50
> write(1, "-- -----------------------------"..., 58-- ------------------------------------------------------
> ) = 58
> write(1, "-- Server version\t5.1.41-3ubuntu"..., 52-- Server version	5.1.41-3ubuntu12.6 (MySQL server)
> ) = 52
> write(1, "\n", 1
> )                       = 1
> sendto(3, "\22\0\0\0\2moocowproductions", 22, 0, NULL, 0) = 22
> recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
> sendto(3, "\225\0\0\0\3SELECT TABLE_NAME, TABLE_CO"..., 153, 0, NULL, 0) = 153
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\0040\0\0\2\3def\0\6TABLES\0\nTABLE_NAM"..., 32768, 0, NULL, NULL) = 1564
> brk(0x1b75000)                          = 0x1b75000
> sendto(3, "\6\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 266, 0, NULL, 0) = 266
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 1032
> brk(0x1ba4000)                          = 0x1ba4000
> sendto(3, "\26\0\0\0\3SHOW INDEXES FROM Art", 26, 0, NULL, 0) = 26
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 708
> brk(0x1bc6000)                          = 0x1bc6000
> brk(0x1bb6000)                          = 0x1bb6000
> sendto(3, "\21\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 277, 0, NULL, 0) = 277
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 726
> sendto(3, "!\0\0\0\3SHOW INDEXES FROM BlogCateg"..., 37, 0, NULL, 0) = 37
> recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 778
> sendto(3, "\17\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 275, 0, NULL, 0) = 275
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 918
> sendto(3, "\37\0\0\0\3SHOW INDEXES FROM BlogComme"..., 35, 0, NULL, 0) = 35
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 778
> sendto(3, "\f\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 272, 0, NULL, 0) = 272
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 722
> sendto(3, "\34\0\0\0\3SHOW INDEXES FROM BlogMoods", 32, 0, NULL, 0) = 32
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 715
> sendto(3, "\f\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 272, 0, NULL, 0) = 272
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 1025
> sendto(3, "\34\0\0\0\3SHOW INDEXES FROM BlogPosts", 32, 0, NULL, 0) = 32
> recvfrom(3, 0x1b316e0, 32768, 0, 0, 0)  = -1 EAGAIN (Resource temporarily unavailable)
> poll([{fd=3, events=POLLIN}], 1, -1)    = 1 ([{fd=3, revents=POLLIN}])
> recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 825
> --- SIGSEGV (Segmentation fault) @ 0 (0) ---
> +++ killed by SIGSEGV +++
> Segmentation fault
> 
> 
> 
> I suspect it may have something to do with stored procedures and triggers and being in my SQL schema. I was hoping drizzledump would just filter them out. I will do more testing to see what may be going on once I have more time, but thought I would send this along.
> 
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/652990/+subscribe
>