From 1ac9ea1f06e66cac4ef2557b95660fdcfa2fd176 Mon Sep 17 00:00:00 2001 From: Frederik Ramm Date: Mon, 24 Sep 2007 09:32:16 +0000 Subject: [PATCH] removed LOCAL from LOAD DATA INFILE --- db/migrate/008_remove_segments.rb | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/db/migrate/008_remove_segments.rb b/db/migrate/008_remove_segments.rb index cfa99adad..8c049b62a 100644 --- a/db/migrate/008_remove_segments.rb +++ b/db/migrate/008_remove_segments.rb @@ -56,9 +56,9 @@ class RemoveSegments < ActiveRecord::Migration tempfiles.each { |fn| File.chmod 0644, fn } if have_segs if have_segs - execute "LOAD DATA LOCAL INFILE '#{ways}' INTO TABLE ways #{csvopts} (id, user_id, timestamp) SET visible = 1, version = 1" - execute "LOAD DATA LOCAL INFILE '#{way_nodes}' INTO TABLE way_nodes #{csvopts} (id, node_id, sequence_id) SET version = 1" - execute "LOAD DATA LOCAL INFILE '#{way_tags}' INTO TABLE way_tags #{csvopts} (id, k, v) SET version = 1" + execute "LOAD DATA INFILE '#{ways}' INTO TABLE ways #{csvopts} (id, user_id, timestamp) SET visible = 1, version = 1" + execute "LOAD DATA INFILE '#{way_nodes}' INTO TABLE way_nodes #{csvopts} (id, node_id, sequence_id) SET version = 1" + execute "LOAD DATA INFILE '#{way_tags}' INTO TABLE way_tags #{csvopts} (id, k, v) SET version = 1" execute "INSERT INTO current_ways SELECT id, user_id, timestamp, visible FROM ways" execute "INSERT INTO current_way_nodes SELECT id, node_id, sequence_id FROM way_nodes" @@ -69,9 +69,9 @@ class RemoveSegments < ActiveRecord::Migration add_index :current_way_nodes, [:node_id], :name => "current_way_nodes_node_idx" if have_segs - execute "LOAD DATA LOCAL INFILE '#{relations}' INTO TABLE relations #{csvopts} (id, user_id, timestamp) SET visible = 1, version = 1" - execute "LOAD DATA LOCAL INFILE '#{relation_members}' INTO TABLE relation_members #{csvopts} (id, member_type, member_id, member_role) SET version = 1" - execute "LOAD DATA LOCAL INFILE '#{relation_tags}' INTO TABLE relation_tags #{csvopts} (id, k, v) SET version = 1" + execute "LOAD DATA INFILE '#{relations}' INTO TABLE relations #{csvopts} (id, user_id, timestamp) SET visible = 1, version = 1" + execute "LOAD DATA INFILE '#{relation_members}' INTO TABLE relation_members #{csvopts} (id, member_type, member_id, member_role) SET version = 1" + execute "LOAD DATA INFILE '#{relation_tags}' INTO TABLE relation_tags #{csvopts} (id, k, v) SET version = 1" # FIXME: This will only work if there were no relations before the # migration! -- 2.39.5