From 28099f340b36fcde5a42a13328aea6a39de44460 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 9 Mar 2018 11:30:16 +0100 Subject: bin/db-update: columns are separated by space! --- bin/db-update | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bin/db-update b/bin/db-update index ca52688..f87000a 100755 --- a/bin/db-update +++ b/bin/db-update @@ -264,7 +264,7 @@ for source_stability in 'testing' 'staging'; do { printf 'CREATE TEMPORARY TABLE `replaced_binary_packages` (`id` BIGINT, UNIQUE KEY (`id`));\n' printf 'CREATE TEMPORARY TABLE `moved_binary_packages` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));\n' - printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s`;\n' \ + printf 'LOAD DATA LOCAL INFILE "%s" INTO TABLE `%s` COLUMNS TERMINATED BY " ";\n' \ "${tmp_dir}/mv.id" 'moved_binary_packages' \ "${tmp_dir}/rm.id" 'replaced_binary_packages' printf 'DELETE `binary_packages` FROM `binary_packages`' -- cgit v1.2.3-70-g09d2