[請益] phpmyadmin的問題

看板PHP作者roger70349 (roger70349)時間17年前 (2008/09/19 01:56)推噓0(0推 0噓 1→)

留言1則, 1人參與討論串1/2 (看更多)

想請問各位，phpmyadmin有所為的SQL檔案大小載入限制，不能超過2MB，但我所拿到的資料庫檔案超過這個數字，我有去php.ini更改其設定，但在載入sql時，原本有47個資料表確只能載入17個資料表，不知道是怎麼會事。我的appserv編碼是設big5的，謝謝。錯誤可能是您的 SQL 語法出現錯誤，如 MySQL 伺服器發出錯誤信息，這可能幫助您去找出問題所在。 ERROR: 未完結的引號 (Unclosed quote) @ 2623 STR: ` SQL: -- -- ?C?X?H?U???w?????G `N_KeyWord` -- INSERT INTO `N_KeyWord` (`KeyWord`, `Num`) VALUES ('tt', 1), ('????', 2), ('?d????F', 5), ('???O', 1), ('????w?n???\', 18), ('???4), ('??q??q??q?q?q', 3), ('?裇?j???X', 1), ('?j?p?R?Y', 4), ('?P??', 6), ('', 1), ('aaa', 1), ('??@?w?n???\', 1); -- -------------------------------------------------------- -- -- ???????G `N_MailSetting` -- CREATE TABLE `N_MailSetting` ( `ItemID` int(4) NOT NULL auto_increment, `Cate` varchar(10) NOT NULL default '', `Name` varchar(100) NOT NULL default '', `Email` varchar(150) NOT NULL default '', `IsActive` tinyint(1) NOT NULL default '1', `CreateDate` date default NULL, PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- ?C?X?H?U???w?????G `N_MailSetting` -- INSERT INTO `N_MailSetting` (`ItemID`, `Cate`, `Name`, `Email`, `IsActive`, `CreateDate`) VALUES (1, 'A1', 'Anderson', 'Andersonfan@msn.com', 1, NULL), (3, 'A2', 'test', 'andersonfan@msn.com', 1, '2008-06-11'); -- -------------------------------------------------------- -- -- ???????G `N_Message` -- CREATE TABLE `N_Message` ( `ItemID` int(4) NOT NULL auto_increment, `MemNO` int(4) NOT NULL default '0', `UserName` varchar(20) NOT NULL default '', `ItemContent` text NOT NULL, `IsVisible` tinyint(1) NOT NULL default '0', `CreateDate` date NOT NULL default '0000-00-00', PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- ?C?X?H?U???w?????G `N_Message` -- -- -------------------------------------------------------- -- -- ???????G `N_News` -- CREATE TABLE `N_News` ( `ItemID` int(4) NOT NULL auto_increment, `ItemSubject` varchar(100) NOT NULL default '', `ItemSummary` text, `ItemText` text, `ItemIMG` varchar(100) NOT NULL default '', `NewsDate` date NOT NULL default '0000-00-00', `StartDate` date NOT NULL default '0000-00-00', `EndDate` date NOT NULL default '0000-00-00', `IsVisible` tinyint(1) NOT NULL default '0', `IsFixPos` tinyint(1) NOT NULL default '0', `ItemOrder` int(4) NOT NULL default '0', `VisitNum` int(11) NOT NULL default '0', `CreateUser` varchar(12) NOT NULL default '', `CreateDate` date NOT NULL default '0000-00-00', `UpdateUser` varchar(12) NOT NULL default '', `UpdateDate` date NOT NULL default '0000-00-00', PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- ?C?X?H?U???w?????G `N_News` -- INSERT INTO `N_News` (`ItemID`, `ItemSubject`, `ItemSummary`, `ItemText`, `ItemIMG`, `NewsDate`, `StartDate`, `EndDate`, `IsVisible`, `IsFixPos`, `ItemOrder`, `VisitNum`, `CreateUser`, `CreateDate`, `UpdateUser`, `UpdateDate`) VALUES (10, 'TiVo ?a?2007 IT Best Choice ??s?T', NULL, '<p class="MsoNormal" style="margin: 0cm 0cm 0pt" align="left">  SQL 語法: -- -- ?C?X?H?U???w?????G `N_KeyWord` -- INSERT INTO `N_KeyWord` (`KeyWord`, `Num`) VALUES ('tt', 1), ('????', 2), ('?d????F', 5), ('???O', 1), ('????w?n???\', 18), ('???4), ('??q??q??q?q?q', 3), ('?裇?j???X', 1), ('?j?p?R?Y', 4), ('?P??', 6), ('', 1), ('aaa', 1), ('??@?w?n???\', 1); -- -------------------------------------------------------- -- -- ???????G `N_MailSetting` -- CREATE TABLE `N_MailSetting` ( `ItemID` int(4) NOT NULL auto_increment, `Cate` varchar(10) NOT NULL default '', `Name` varchar(100) NOT NULL default '', `Email` varchar(150) NOT NULL default '', `IsActive` tinyint(1) NOT NULL default '1', `CreateDate` date default NULL, PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- ?C?X?H?U???w?????G `N_MailSetting` -- INSERT INTO `N_MailSetting` (`ItemID`, `Cate`, `Name`, `Email`, `IsActive`, `CreateDate`) VALUES (1, 'A1', 'Anderson', 'Andersonfan@msn.com', 1, NULL), (3, 'A2', 'test', 'andersonfan@msn.com', 1, '2008-06-11'); -- -------------------------------------------------------- -- -- ???????G `N_Message` -- CREATE TABLE `N_Message` ( `ItemID` int(4) NOT NULL auto_increment, `MemNO` int(4) NOT NULL default '0', `UserName` varchar(20) NOT NULL default '', `ItemContent` text NOT NULL, `IsVisible` tinyint(1) NOT NULL default '0', `CreateDate` date NOT NULL default '0000-00-00', PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- ?C?X?H?U???w?????G `N_Message` -- -- -------------------------------------------------------- -- -- ???????G `N_News` -- CREATE TABLE `N_News` ( `ItemID` int(4) NOT NULL auto_increment, `ItemSubject` varchar(100) NOT NULL default '', `ItemSummary` text, `ItemText` text, `ItemIMG` varchar(100) NOT NULL default '', `NewsDate` date NOT NULL default '0000-00-00', `StartDate` date NOT NULL default '0000-00-00', `EndDate` date NOT NULL default '0000-00-00', `IsVisible` tinyint(1) NOT NULL default '0', `IsFixPos` tinyint(1) NOT NULL default '0', `ItemOrder` int(4) NOT NULL default '0', `VisitNum` int(11) NOT NULL default '0', `CreateUser` varchar(12) NOT NULL default '', `CreateDate` date NOT NULL default '0000-00-00', `UpdateUser` varchar(12) NOT NULL default '', `UpdateDate` date NOT NULL default '0000-00-00', PRIMARY KEY (`ItemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- ?C?X?H?U???w?????G `N_News` -- INSERT INTO `N_News` (`ItemID`, `ItemSubject`, `ItemSummary`, `ItemText`, `ItemIMG`, `NewsDate`, `StartDate`, `EndDate`, `IsVisible`, `IsFixPos`, `ItemOrder`, `VisitNum`, `CreateUser`, `CreateDate`, `UpdateUser`, `UpdateDate`) VALUES (10, 'TiVo ?a?2007 IT Best Choice ??s?T', NULL, ' MySQL 傳回： #1064 - 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 '; -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 123.192.195.241