Arkadaşlar elimde 10 bin üyenin sql dosyası mevcut bunu navicata yüklemeye calısıyorum Execute SQL File yöntemi ile fakat bu üyelikler farklı mysql tablolardan gelme yani id leri farklı bir üyenin id 1 diğerinin 32521456 buda sorun çıkartıyor yüklemiyor bu engeli nasıl aşarım örnek veriyorum.
/*
Navicat MySQL Data Transfer
Source Server : asdasd
Source Server Version : 50546
Source Host : 127.0.0.1
Source Database : account
Target Server Type : MYSQL
Target Server Version : 50546
File Encoding : 65001
Date: 2014-12-28 13:18:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(30) NOT NULL DEFAULT '',
`password` varchar(45) NOT NULL DEFAULT '',
`real_name` varchar(16) NOT NULL DEFAULT '',
`social_id` varchar(7) DEFAULT '',
`email` varchar(64) NOT NULL DEFAULT '',
`phone1` varchar(16) DEFAULT NULL,
`phone2` varchar(16) DEFAULT NULL,
`address` varchar(128) DEFAULT NULL,
`zipcode` varchar(7) NOT NULL DEFAULT '',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`question1` varchar(48) DEFAULT NULL,
`answer1` varchar(48) DEFAULT NULL,
`question2` varchar(48) DEFAULT NULL,
`answer2` varchar(48) DEFAULT NULL,
`is_testor` tinyint(1) NOT NULL DEFAULT '0',
`status` varchar(8) NOT NULL DEFAULT 'OK',
`securitycode` varchar(192) NOT NULL DEFAULT '',
`newsletter` tinyint(1) NOT NULL DEFAULT '0',
`empire` tinyint(4) NOT NULL DEFAULT '0',
`name_checked` tinyint(1) NOT NULL DEFAULT '0',
`availDt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`mileage` int(11) NOT NULL DEFAULT '0',
`cash` int(11) NOT NULL DEFAULT '0',
`gold_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`silver_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`safebox_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`autoloot_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`fish_mind_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`marriage_fast_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`money_drop_rate_expire` datetime NOT NULL DEFAULT '2020-01-24 23:59:59',
`ttl_cash` int(11) NOT NULL DEFAULT '0',
`ttl_mileage` int(11) NOT NULL DEFAULT '0',
`channel_company` varchar(30) NOT NULL DEFAULT '',
`ban_sure` varchar(30) NOT NULL,
`ban_neden` varchar(30) NOT NULL,
`ban_time` datetime NOT NULL,
`ticket_id` varchar(30) NOT NULL,
`kim_banlamis` varchar(30) NOT NULL,
`coins` int(11) NOT NULL DEFAULT '0',
`web_admin` int(1) NOT NULL DEFAULT '0',
`web_ip` varchar(15) NOT NULL,
`web_aktiviert` varchar(32) NOT NULL,
`server` int(1) NOT NULL DEFAULT '4',
`bilgi` int(11) NOT NULL DEFAULT '1',
`email_onay` int(11) NOT NULL DEFAULT '0',
`last_play` datetime DEFAULT NULL,
`banacilis` varchar(25) NOT NULL,
`dost` varchar(30) NOT NULL,
`gecici` int(11) NOT NULL DEFAULT '0',
`ysifre` varchar(255) NOT NULL,
`yemail` varchar(255) NOT NULL,
`ylogin` varchar(255) NOT NULL,
`tkod` varchar(10) NOT NULL,
`ypass` varchar(255) NOT NULL,
`durum` int(11) NOT NULL,
`davet` int(11) NOT NULL,
`davet_durum` int(1) NOT NULL,
`ip` varchar(40) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`),
KEY `social_id` (`social_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25918 DEFAULT CHARSET=big5;
-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', 'test3', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('2', 'test4', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('3', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('25915', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('25916', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('25917', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('25918', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
INSERT INTO `account` VALUES ('23234646', 'test2', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
