[درس] رفع قاعدة بيانات كبيرة بدون آي سكريت

[فارس الإعلاميات]

?????? ????? ????? ???? ???????

??? ??? ??? ?? ?? ??? ??????? ? ????? ?? ???? ????? ???

????? ??? ???? ???? ????? ?????? ????? ? ???? ????????? ???? ??? ??????? ???? ?????

??? ????? ?????? ??????? ???? ????? ??? ??? ??????? ??? ????? ?????? ??? ?????? phpmyadmin ? ???? ??????? ???????? (???? bigdump)


????? ???? ??? ?? ???? ????? ??? :

كود: تحديد الكل

max_execution_time
memory_limit
upload_max_filesize
post_max_size

? ??? ??? ?????
?? ??? php.ini ???? ????? ???????? ??????? ?????? WAMP ??? ????? ??? ???? ??????? ??? ?????? ????? ?????? ?????? php ?? ?????? php.ini

???????? ????? ????? ???? ????? ???? ??? ????? ??????

??? ?? ??????? ? ?????? ???? ??????? ?


max_execution_time: ?????? ???? ???? ?????? ???????? ? ??? ????? ?????? ???????? . ? ?? ???? ????? ?????? ???????? ????? ??? ?????? ????? ???? ???? ???? ??? ??????? ???? ????? . ?????? ?????????? ?? 30 ? ??? ??????? ?? ???? ?????? ????? ?????? : ""Maximum execution time of 30 seconds exceeded..." ??? ?? ???? ??? ??? ????? ??? ???? ????????

memory_limit: ?????? ?????? ???? ??????? ?? ?????? ?? ??????? , ? ?? ???? ????? ?? ??? ?????????? ???? ??????? ??????? ? ??? ??????? ?? ???? ?????? ??? ????? ?????? : Fatal error: Allowed memory size of XXXXXXXX bytes exhausted (tried to allocate YYYYYYY bytes)" ??? ?? ???? ??? ??? ????? ??? ???? ???????? ????


upload_max_filesize : ?????? ????? ?????? ??????? ???? ??? ????? , ???? ??? ?????? ???? ??? ?? ?????? ??? ????? ?? ??? ????? ???? 2 ???? ?????? phpmyadmin ? ??? ??????? ???? ???? ??? ??? ????? ???????? (???? ?? ??? ??? ???? ???????? 20 ???? ?????? ?????? 30 ???? ???? ?? ???? )

post_max_size: ?????? ???? ???? ???? ???????? ??????? ??? ?? ????? ?????? ????? POST . ? ?? ???? ?????? ???? ????? ??? ??? ???? ? ??? ??????? ???? ???? ?? ???? upload_max_filesize ???? ?? ?????? upload_max_filesize ?????? 30 ???? ??? ?? ?????? 40


????? ?? ???? ????? ?????

???????? ??????

??? ???? ????? ??? ????? ?? ????? ??? ???? ???????? ????? ??? ??????? ???????? ? ?? ?????? ??? ???????? ??? .htaccess

?? ???? ??? ??? ???????