قريتي نت
22-09-2006, 03:00 AM
بسمه تعالى
أخواني
أنا شريت قاعدة بيانات بمبلغ جامد
والآن لما أحاول الدمج
عبر bigdump
أخترت القاعدة اللي أبيها
ظغطت
start import
مع بداية الدمج
يطلع لي خطأ
يقول
BigDump: Staggered MySQL Dump Importer ver. 0.19b
Processing file: user.sql
Starting at the line: 1
Error at the line 53: ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
Query: CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `usergroupid` smallint(5) unsigned NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(32) NOT NULL default '', `email` varchar(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `parentemail` varchar(50) NOT NULL default '', `homepage` varchar(100) NOT NULL default '', `icq` varchar(20) NOT NULL default '', `aim` varchar(20) NOT NULL default '', `yahoo` varchar(32) NOT NULL default '', `usertitle` varchar(250) NOT NULL default '', `customtitle` smallint(6) NOT NULL default '0', `joindate` int(10) unsigned NOT NULL default '0', `daysprune` smallint(6) NOT NULL default '0', `lastvisit` int(10) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastpost` int(10) unsigned NOT NULL default '0', `posts` int(10) unsigned NOT NULL default '0', `timezoneoffset` varchar(4) NOT NULL default '', `pmpopup` smallint(6) NOT NULL default '0', `avatarid` smallint(6) NOT NULL default '0', `options` int(10) unsigned NOT NULL default '0', `birthday` varchar(10) NOT NULL default '0000-00-00', `maxposts` smallint(6) NOT NULL default '-1', `startofweek` smallint(6) NOT NULL default '1', `ipaddress` varchar(15) NOT NULL default '', `referrerid` int(10) unsigned NOT NULL default '0', `pmtotal` smallint(5) unsigned NOT NULL default '0', `pmunread` smallint(5) unsigned NOT NULL default '0', `passworddate` date NOT NULL default '0000-00-00', `salt` char(3) NOT NULL default '', `showvbcode` smallint(5) unsigned NOT NULL default '0', `msn` varchar(100) NOT NULL default '', `avatarrevision` int(10) unsigned NOT NULL default '0', `membergroupids` varchar(250) NOT NULL default '', `displaygroupid` smallint(5) unsigned NOT NULL default '0', `reputation` int(11) NOT NULL default '10', `reputationlevelid` int(10) unsigned NOT NULL default '1', `languageid` smallint(5) unsigned NOT NULL default '0', `threadedmode` smallint(5) unsigned NOT NULL default '0', `emailstamp` int(10) unsigned NOT NULL default '0', `autosubscribe` smallint(6) NOT NULL default '-1', `birthday_search` date NOT NULL default '0000-00-00', `importuserid` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`), KEY `usergroupid` (`usergroupid`), KEY `username` (`username`), KEY `birthday` (`birthday`), KEY `birthday_search` (`birthday_search`) ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 52
Stopped on error
قلت ربما الخطأ من القاعدة شريت قاعد اخرى ونفس الخطأ ياليت يا شباب تعطوني حل
اللي يعطيني الحل راح أعطيه قاعدة 87.000 عضو
من سعيد الحظ
أخواني
أنا شريت قاعدة بيانات بمبلغ جامد
والآن لما أحاول الدمج
عبر bigdump
أخترت القاعدة اللي أبيها
ظغطت
start import
مع بداية الدمج
يطلع لي خطأ
يقول
BigDump: Staggered MySQL Dump Importer ver. 0.19b
Processing file: user.sql
Starting at the line: 1
Error at the line 53: ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
Query: CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `usergroupid` smallint(5) unsigned NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(32) NOT NULL default '', `email` varchar(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `parentemail` varchar(50) NOT NULL default '', `homepage` varchar(100) NOT NULL default '', `icq` varchar(20) NOT NULL default '', `aim` varchar(20) NOT NULL default '', `yahoo` varchar(32) NOT NULL default '', `usertitle` varchar(250) NOT NULL default '', `customtitle` smallint(6) NOT NULL default '0', `joindate` int(10) unsigned NOT NULL default '0', `daysprune` smallint(6) NOT NULL default '0', `lastvisit` int(10) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastpost` int(10) unsigned NOT NULL default '0', `posts` int(10) unsigned NOT NULL default '0', `timezoneoffset` varchar(4) NOT NULL default '', `pmpopup` smallint(6) NOT NULL default '0', `avatarid` smallint(6) NOT NULL default '0', `options` int(10) unsigned NOT NULL default '0', `birthday` varchar(10) NOT NULL default '0000-00-00', `maxposts` smallint(6) NOT NULL default '-1', `startofweek` smallint(6) NOT NULL default '1', `ipaddress` varchar(15) NOT NULL default '', `referrerid` int(10) unsigned NOT NULL default '0', `pmtotal` smallint(5) unsigned NOT NULL default '0', `pmunread` smallint(5) unsigned NOT NULL default '0', `passworddate` date NOT NULL default '0000-00-00', `salt` char(3) NOT NULL default '', `showvbcode` smallint(5) unsigned NOT NULL default '0', `msn` varchar(100) NOT NULL default '', `avatarrevision` int(10) unsigned NOT NULL default '0', `membergroupids` varchar(250) NOT NULL default '', `displaygroupid` smallint(5) unsigned NOT NULL default '0', `reputation` int(11) NOT NULL default '10', `reputationlevelid` int(10) unsigned NOT NULL default '1', `languageid` smallint(5) unsigned NOT NULL default '0', `threadedmode` smallint(5) unsigned NOT NULL default '0', `emailstamp` int(10) unsigned NOT NULL default '0', `autosubscribe` smallint(6) NOT NULL default '-1', `birthday_search` date NOT NULL default '0000-00-00', `importuserid` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`), KEY `usergroupid` (`usergroupid`), KEY `username` (`username`), KEY `birthday` (`birthday`), KEY `birthday_search` (`birthday_search`) ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 52
Stopped on error
قلت ربما الخطأ من القاعدة شريت قاعد اخرى ونفس الخطأ ياليت يا شباب تعطوني حل
اللي يعطيني الحل راح أعطيه قاعدة 87.000 عضو
من سعيد الحظ