مشکل در رستور کردن بک آپ تبدیل شده

[m2sh2]

سلام دوستان و اساتید عزیز

من یه فول بک آپ از cpanel از یکی از سایت ها گرفتم وحالامیخوام روی دایرکت ادمین رستور کنم با اسکریپت cp2da تبدیل کردم این خطا رو هنگام رستور میده چه کنم ؟

set_collation: DB adminsor_modirbl does not have any collation information in the backup. Skipping
set_collation: DB adminsor_modirdb does not have any collation information in the backup. Skipping
Unable to restore database adminsor&#95modirdb.sql to adminsor_modirdb : ERROR 2006 (HY000) at line 4136 in file: '/home/adminsor/backups/backup/adminsor_modirdb.sql': MySQL server has gone away

set_collation: DB adminsor_omid does not have any collation information in the backup. Skipping
set_collation: DB adminsor_adminsor_ebQ2A9iwhlSJhLgg does not have any collation information in the backup. Skipping
Unable to restore database cptmpdb&#95adminsor&#95ebQ&#50A&#57iwhlSJhLgg.sql to adminsor_adminsor_ebQ2A9iwhlSJhLgg : ERROR at line 1: Failed to open file '/home/adminsor/backups/backup/cptmpdb_adminsor_ebQ2A9iwhlSJhLgg.sql', error: 2

و بدون تبدیل کردن بصورت دستی که میخوام منتقل کنم این خطا رو میده

Static analysis:

1 errors were found during analysis.

    Unrecognized keyword. (near "ON" at position 25)

SQL query: Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation
#2006 - MySQL server has gone away

Warning in ./libraries/dbi/DBIMysqli.class.php#261
Error while sending QUERY packet. PID=10326

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'INSERT INTO `language` (`languageid`, `title`, `userselect`,  `options`, `languagecode`, `charset`, `imagesoverride`, `dateoverride`,  `timeoverride`, `registereddateoverride`, `calformat1override`,  `calformat2override`, `logdateoverride`, `locale`, `decimalsep`,  `thousandsep`, `phrasegroup_global`, `phrasegroup_cpglobal`,  `phrasegroup_cppermission`, `phrasegroup_forum`, `phrasegroup_calendar`,  `phrasegroup_attachment_image`, `phrasegroup_style`,  `phrasegroup_logging`, `phrasegroup_cphome`, `phrasegroup_promotion`,  `phrasegroup_user`, `phrasegroup_help_faq`, `phrasegroup_sql`,  `phrasegroup_subscription`, `phrasegroup_language`,  `phrasegroup_bbcode`, `phrasegroup_stats`, `phrasegroup_diagnostic`,  `phrasegroup_maintenance`, `phrasegroup_profilefield`,  `phrasegroup_thread`, `phrasegroup_timezone`, `phrasegroup_banning`,  `phrasegroup_reputation`, `phrasegroup_wol`, `phrasegroup_threadmanage`,  `phrasegroup_pm`, `phrasegroup_cpuser`, `phrasegroup_accessmask`,  `phrasegroup_cron`, `phrasegroup_moderator`, `phrasegroup_cpoption`,  `phrasegroup_cprank`, `phrasegroup_cpusergroup`, `phrasegroup_holiday`,  `phrasegroup_posting`, `phrasegroup_poll`, `phrasegroup_fronthelp`,  `phrasegroup_register`, `phrasegroup_search`, `phrasegroup_showthread`,  `phrasegroup_postbit`, `phrasegroup_forumdisplay`,  `phrasegroup_messaging`, `phrasegroup_inlinemod`, `phrasegroup_plugins`,  `phrasegroup_cprofilefield`, `phrasegroup_reputationlevel`,  `phrasegroup_infraction`, `phrasegroup_infractionlevel`,  `phrasegroup_notice`, `phrasegroup_prefix`, `phrasegroup_prefixadmin`,  `phrasegroup_album`, `phrasegroup_socialgroups`,  `phrasegroup_advertising`, `phrasegroup_tagscategories`,  `phrasegroup_contenttypes`, `phrasegroup_vbblock`,  `phrasegroup_vbblocksettings`, `phrasegroup_vbblogadmin`,  `phrasegroup_vbblogcat`, `phrasegroup_vbblogglobal`,  `phrasegroup_vbhosting_admincp`, `phrasegroup_vbhosting_create`,  `phrasegroup_vbhosting_hostingcp`, `phrasegroup_cpcms`,  `phrasegroup_vbcms`, `phrasegroup_widgettypes`, `phrasegroupinfo`,  `phrasegroup_ckeditor`, `phrasegroup_activitystream`) VALUES (2,\'Farsi  Forum Lang\',1,0,\'

البته من همون 2 3 خط اول رو گذاشتم

ممنونم

[m2sh2]

دوستان کسی نیست جواب بده ؟

[shivahost]

به نطر من یکبار دیگه در سرور اول بکاپ بگیرید و قبل از بکاپ گرفتن هم یکبار دیتابیس ها را repair کنید.

[compiler]

اول از سالم بودن دیتابیس های Dump شده اطمینان حاصل کنید و پس از اون هم دیتابیس رو دستی ریستور کنید .