مشکل در رستور کردن بک آپ تبدیل شده
سلام دوستان و اساتید عزیز
من یه فول بک آپ از 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 خط اول رو گذاشتم
ممنونم
پاسخ : مشکل در رستور کردن بک آپ تبدیل شده
دوستان کسی نیست جواب بده ؟
پاسخ : مشکل در رستور کردن بک آپ تبدیل شده
به نطر من یکبار دیگه در سرور اول بکاپ بگیرید و قبل از بکاپ گرفتن هم یکبار دیتابیس ها را repair کنید.
پاسخ : مشکل در رستور کردن بک آپ تبدیل شده
اول از سالم بودن دیتابیس های Dump شده اطمینان حاصل کنید و پس از اون هم دیتابیس رو دستی ریستور کنید .
