PHPMYADMIN main SQL DB Import main Problem

[iTHero]

Asalamaalekum
iTH Hazir Hai aik Bohut Hi important Problem Ke sath Howa khuch yun ke main apne forum ki DB ko Mere Local Server Ke phpmyadmin main import kar raha tha to sirf 8 table hi import howy or nechy dia howa error show howa hai.
Error

SQL query:

#
# Dumping data in `smf_boards`
#
INSERT INTO `smf_boards` (
`ID_BOARD` ,
`ID_CAT` ,
`childLevel` ,
`ID_PARENT` ,
`boardOrder` ,
`ID_LAST_MSG` ,
`ID_MSG_UPDATED` ,
`memberGroups` ,
`name` ,
`description` ,
`numTopics` ,
`numPosts` ,
`countPosts` ,
`ID_THEME` ,
`permission_mode` ,
`override_theme`
)
VALUES ( 1, 1, 0, 0, 1, 966, 966, '-1,0,2,4,5,6,7,8,9', '<font color=\"blue\">Announcements ', 'All important Notices New service Announcements.<font size=\"3\"><marquee direction=\"right\" style=\"color: #FF0000; font-weight: bold\">\r\nآئی ٹی ایچ کی نئی سرویسز اور اعلا نات اس سیکشن میں دیکھیے۔\r\n</h4></marquee></font>', 9, 15, 0, 0, 0, 0 ) , ( 4, 2, 0, 0, 2, 1012, 1012, '-1,0,2,4,5,6,7,8,9', 'Computer Hardware Education', 'Talk about all Computer Hardware , Like Asembling, Troubleshooting, Installation, Repairing,DM,Windows Security ETC\r\n<h4>\r\nکمپیو ٹر ہارڈوئیر سے متعلق تمام تر معلو مات کے لیے یہ سیکشن دیکھیے\r\n<h4>', 13, 15, 0, 0, 0, 0 ) , ( 110, 2, 1, 4, 3, 795, 795, '-1,0,2,4,5,6,7,8,9', 'BIOS', '', 3, 3, 0, 0, 0, 0 ) , ( 111, 2, 1, 4, 4, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Drivers', '', 0, 0, 0, 0, 0, 0 ) , ( 112, 2, 1, 4, 5, 774, 774, '-1,0,2,4,5,6,7,8,9', 'Installation', '', 1, 1, 0, 0, 0, 0 ) , ( 64, 2, 1, 4, 6, 20, 20, '-1,0,2,4,5,6,7,8,9', 'Asembling', '', 1, 4, 0, 0, 0, 0 ) , ( 65, 2, 1, 4, 7, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Torubleshooting', '', 0, 0, 0, 0, 0, 0 ) , ( 66, 2, 1, 4, 8, 671, 671, '-1,0,2,4,5,6,7,8,9', 'Hardware Errors', '', 4, 4, 0, 0, 0, 0 ) , ( 67, 2, 1, 4, 9, 980, 980, '-1,0,2,4,5,6,7,8,9', 'Repairing', '', 14, 16, 0, 0, 0, 0 ) , ( 68, 2, 1, 4, 10, 697, 697, '-1,0,2,4,5,6,7,8,9', 'Windows Security', '', 6, 7, 0, 0, 0, 0 ) , ( 85, 2, 1, 4, 11, 298, 298, '-1,0,2,4,5,6,7,8,9', 'Hardware in Urdu', '', 38, 38, 0, 0, 0, 0 ) , ( 124, 2, 1, 4, 12, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Miscellaneous', '', 0, 0, 0, 0, 0, 0 ) , ( 89, 2, 0, 0, 13, 968, 968, '-1,0,2,4,5,6,7,8,9', 'Branded &amp; Unbranded Computers', 'The Full detail of Branded and Unbranded Computers in the World\r\n<h4>\r\nکمپیو ٹر ہارڈ وئیر میں برانڈڈ اور ان برانڈڈ کمپیو ٹرز کی معلو مات کے لیے یہ سیکشن دیکھیے۔\r\n</h4>', 2, 3, 0, 0, 0, 0 ) , ( 102, 2, 0, 0, 14, 638, 638, '-1,0,2,4,5,6,7,8,9', 'Galaxy Lattest Computers Prices', 'Pakistan\'s best computer prices Website is updated daily and it contains not only the prices of the products but also useful links and configurations by which it's easier for the customers to choose the right product.\r\n<h4>\r\nپاکستان کی کمپیو ٹر مارکیٹ میں کمپیو ٹرز کے موجودہ قیمتیں دیکھنے کے لیے یہ سیکشن دیکھیے۔\r\n</h4>', 2, 3, 0, 0, 0, 0 ) , ( 126, 2, 1, 102, 15, 0, 0, '-1,0,2,4,5,6,7,8,9', 'New Systems', '', 0, 0, 0, 0, 0, 0 ) , ( 127, 2, 1, 102, 16, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Used Systems', '', 0, 0, 0, 0, 0, 0 ) , ( 128, 2, 1, 102, 17, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Accessories', '', 0, 0, 0, 0, 0, 0 ) , ( 3, 9, 0, 0, 18, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Website Design &amp; Development ', 'HTML, CSS, DHTML, Javascript Graphics designing, ASP and PHP, SQL, Content Management and other issues related to website managment\r\n<h4>\r\nویب سائیٹ بنا نے کی تمام تر معلو مات کے لیے یہ سیکشن دیکھیے\r\n</h4>', 0, 0, 0, 0, 0, 0 ) , ( 40, 9, 1, 3, 19, 990, 990, '-1,0,2,4,5,6,7,8,9', 'Networking', '', 5, 7, 0, 0, 0, 0 ) , ( 74, 9, 1, 3, 20, 614, 614, '-1,0,2,4,5,6,7,8,9', 'Bluevoda', '', 1, 1, 0, 0, 0, 0 ) , ( 73, 9, 1, 3, 21, 47, 47, '-1,0,2,4,5,6,7,8,9', 'Macromedia Dreamviewer', '', 1, 1, 0, 0, 0, 0 ) , ( 83, 9, 1, 3, 22, 958, 958, '-1,0,2,4,5,6,7,8,9', 'Java Script', '', 10, 10, 0, 0, 0, 0 ) , ( 84, 9, 1, 3, 23, 987, 987, '-1,0,2,4,5,6,7,8,9', 'PHP', '', 3, 6, 0, 0, 0, 0 ) , ( 86, 9, 1, 3, 24, 982, 982, '-1,0,2,4,5,6,7,8,9', 'Flash Assignments', '', 4, 4, 0, 0, 0, 0 ) , ( 123, 9, 1, 3, 25, 945, 945, '-1,0,2,4,5,6,7,8,9', 'HTML', '', 9, 11, 0, 0, 0, 0 ) , ( 5, 3, 0, 0, 26, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Courses &amp; Tutorials ', 'Step to step instructions with screen shots on how to perform different computing tasks including use of Urdu fonts and Urdu softwares. All tutorials posted in this section must be in urdu script.\r\n<h4>\r\nکمپیوٹر کے تمام تر کورسز اور ٹیو ٹوریل سیکھنے کےلیے یہ سیکشن دیکھیے\r\n</h4>', 0, 0, 0, 0, 0, 0 ) , ( 6, 3, 1, 5, 27, 667, 667, '-1,0,2,4,5,6,7,8,9', 'Windows XP', '', 25, 51, 0, 0, 0, 0 ) , ( 7, 3, 1, 5, 28, 305, 305, '-1,0,2,4,5,6,7,8,9', 'Microsoft Word', '', 10, 10, 0, 0, 0, 0 ) , ( 8, 3, 1, 5, 29, 749, 749, '-1,0,2,4,5,6,7,8,9', 'Microsoft Excel', '', 2, 2, 0, 0, 0, 0 ) , ( 9, 3, 1, 5, 30, 554, 554, '-1,0,2,4,5,6,7,8,9', 'Microsoft Access', '', 1, 1, 0, 0, 0, 0 ) , ( 10, 3, 1, 5, 31, 555, 555, '-1,0,2,4,5,6,7,8,9', 'Microsoft Powerpoint', '', 2, 2, 0, 0, 0, 0 ) , ( 35, 3, 1, 5, 32, 0, 0, '-1,0,2,4,5,6,7,8,9', 'Microsoft Frontpage', '', 0, 0, 0, 0, 0, 0 ) , ( 36, 3, 1, 5, 33, 811, 811, '-1,0,2,4,5,6,7,8,9', 'Inpage Urdu', '', 5, 5, 0, 0, 0, 0 ) , ( 37, 3, 1, 5, 34, 633, 633, '-1,0,2,4,5,6,7,8,9', 'Corel Draw', '', 2, 3, 0, 0, 0, 0 ) , ( 38, 3, 1, 5, 35, 598, 598, '-1,0,2,4,5,6,7,8,9', 'Adobe Photoshop', '', 4, 4, 0, 0, 0, 0 ) , ( 39, 3, 1

MySQL said: Documentation
#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 '' at line 38


yani mere DB ke 61 tables thay lekin 8 hi import howy hen. Koi bhi SMf ki Urdu Community main SQL ki info rakhta hai to mera ye problem solve kar den. kiun ke SQL ki info har kisi ko nahi hai.
Kia aisa bhi ho sakta hai ke main ne apne SMF boards ke Discription main Unicode Urdu HTML tags ke sath likhi hai .
Main expert bhaiyun ke Solve Replay Ka muntizir raho ga.
Zeeshan Khan
www.itheropk.com

[Mraza]

Slam ! mere hial me ap datbase export krte waqat  sab tables ko select nahi kr rahe ho,,,, databse ko backup krne k liy ap export per click kre aur phir left side jo Export ka column hai voha per ap k sare tables show ho rahe ho giy. ager vo sab selecet nahi hai to ap "select all" per click kre  , next options vale column se "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" ko click kre, next "Save as file" or ager apka server zipped support krta hai to best hai ap gzipped option select kr k data save kre,

http://imgcentre.com/img/uploads/big/3280f5f554.png

aur phir ager import krna ho to export k sath jo import ki option hai us per click kre aur apni saved hoi database ki file ko upload kre, hope it helps

W/Slam

[iTHero]

Salam
Raza Bhai main ne PHPMYADMIN se App ke bataye howy tarikay se DB ka bakup Lene Ki Koshish Ki thi Lekin Us DB ko jab main ne import kia mere local server per to Us ne SQL Query main BUG show kia or DB import nai hoi..............or phir main ne apne SMF ke cpanel se DB ka Backup Le kar us ko import kia to aik Error Show howa lekin DB import ho gayi............ main Error Ka Screen shot yahan Post kar raha hon............ aap is ka sahi hal bata sakte hen is error ka kia maksad hai.
Ab mujhay aik bat samjh nahi aayi ke..............SMf ke Cpanel KI DB bilkul sahi import ho jati hai Lekin PHPMYADMIN se li gayi Backup import kiun nahi hoti..........Acha aik bat or........aap ne yeh nahi bataya ke Export Type.......... main kia select KArna HAi ... Insert, Update, Replace in 3 main se konsa option select hona chaye wese default insert select howa hota hai. App ko BUg Report karna aati hai to main aap ko BUG detail bhi send kar don ga.