m2sh2
January 4th, 2016, 13:16
سلام دوستان و اساتید عزیز
من یه فول بک آپ از 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_modirdb.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_adminsor_ebQ2A9iwhlSJhLgg.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 خط اول رو گذاشتم
ممنونم
من یه فول بک آپ از 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_modirdb.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_adminsor_ebQ2A9iwhlSJhLgg.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 خط اول رو گذاشتم
ممنونم