ÔÑÍ Úãá Backup / Restore áÞÇÚÏÉ ÈíÇäÇÊ ãä ÎáÇá Php ÈæÇÓØÉ MySQLDumper
Backup/Restore MySql database using PHP
Cannot import database using PhpMyAdmin with Cpanel
Create mysql DB with PHP through cPanel and import *.sql file
Import a large database - CPanel & MySQL & PHPMyAdmin

åá íãßäß ÇÎÐ ÈÇß ÇÈ áÞÇÚÏÉ ÈíÇäÇÊ sql ÈÏæä áæÍÉ ÊÍßã Cpanel ?

äÚã íãßäß Ðáß Ïæä ÇáÏÎæá Úáì áæÍÉ ÇáÓì ÈÇäá ÇØáÇÞÇ, ÍíË ãä ÎáÇáåÇ ÇäÊ ÊÓÊÚíä phpMyAdmin

ÇÐä ÇáÚáÇÞÉ åäÇ ãÑÊÈØÉ ÈÜ php æÈÇáÊÇáì åäÇß ÓßÑÈÊÇÊ ÇÎÑì íãßäåÇ Úãá ÈÇß ÇÈ ãËáåÇ.

áãÇÐÇ ÇÍÊÇÌ ÇÓÊÎÏÇã ÓßÑÈÊ php áÇÎÐ ÈÇß ÇÈ Çæ Úãá ÑíÓÊæÑ áÞÇÚÏÉ ÇáÈíÇäÇÊ ?

ÊÍÊÇÌ áÐáß Ýì ÍÇáÉ Çä phpMyAdmin áÇ ÊÓÊØíÚ ÇáÏÎæá Úáíå Çæ åäÇß limit ááãæÇÑÏ ÇáÎÇÕÉ Èå Çæ ãÓÇÍÉ ÞÇÚÏÉ ÇáÈíÇäÇÊ ßÈíÑÉ

Ýì åÐå ÇáÍÇáÉ ÇáÓßÑÈÊ åíÞÖì ÇáÛÑÖ ÇáãØáæÈ Ýì ÇÎÐ ÈÇß ÇÈ Çæ Úãá restore.

#####################################
ÔÑÍ ÓßÑÈÊ MySQLDumper
#####################################

MySQLDumper is a web based backup/restore script for MYSQL which can handle huge dbs. Additionally - like in phpMyAdmin - you can create, drop databases, tables and views or view, search, delete, edit or add fields in an easy to use SQLBrowser.

ÇáÓßÑÈÊ åæ ÚÈÇÑÉ Úä ÝæáÏÑ ÈÏÇÎáå ãáÝÇÊ Þã ÈÑÝÚå ÏÇÎá ftp æáíßä ãËáÇ Ýì ÇáãÓÇÑ ÇáÊÇáì

www.abc.com/sqldumper

ÚäÏ ÇÓÊÏÚÇÁ åÐÇ ÇáÑÇÈØ åíØáÈ ãäß Úãá Install

Now the installation page of mysqldumper appears. Choose the language and click Installation.



Set the credentials like hostname, user and password of the mysql server. Then click Save and continue installation.



Now we have successfully entered into mysqldumper home page.


Select backup tab in left side panel. Choose the type of backup as required and then hit start new backup.



To restore the backup, Select Restore tab in left side panel and click " choose tables to be restored" button to select the particular table.


Here, click the check-box of respective table to be restored and click " Restore"


We have successfully restored the database.


Now move to home page and click " Create directory protection" . Using Directory Protection, we can protect the home screen with password. This option will use ‘ .htaccess‘ function on Apache web server.


Select the type of encryption and click " Create directory protection" .


Click Ok to confirm the protection.


The directory protection is successfully completed.


Now click File administration tab which is used to maintain all available backups and restore.



Go to Sql-browser tab if you want to run specific SQL command.


Click configuration tab. You can configure general settings, email, cron job, and more.

Click log tab to view basic logs. It shows the details such as when the backup was taken, backup restored and much more information about backup logs.




#####################################
äÕÇÆÍ åÇãÉ mysqldump requirement :
#####################################

ÍÊì íÚãá ÇáÓßÑÈÊ ãÚß ÈÔßá Óáíã íÌÈ Çä ÊÓÊÎÏã php ÇÕÏÇÑ 5.6

æÇä ÊÑÝÚ ÌãíÚ ÇáÞíã Ýì php ßãÇ Ýì ÇáÕæÑÉ Çáì ÇÑÞÇã ÇÚáì ÈßËíÑ ÍÓÈ ÞÇÚÏÉ ÇáÈíÇäÇÊ

ÍíË ÇÐÇ áã íÊã ÑÝÚ Êáß ÇáÞíã ÞÏ íÊæÞÝ ÇáÑÝÚ ÈÚÏ ÈÖÚ ËæÇäì Çæ ÏÞÇÆÞ Ïæä ÇáÇßÊãÇá

æÎÇÕÉ ÑÝÚ ÞíãÉ max_execution_time Çáì ÞíãÉ ßÈíÑÉ ÌÏÇ



ÇáÓßÑÈÊ íÚãá ÈÔßá Óáíã æåÐå ÇáäÓÎÉ åì ÇáÇÎíÑ ááãÈÑãÌ æáÇ íæÌÏ äÓÎ ÇÎÑì Ýì ÇáãÓÊÞÈá

Êã ÇáÊÌÑÈÉ 2019

#####################################
ÇáÊÍãíá:
#####################################

íãßäß ÊÍãíá ÇáÓÑßÈÊ ãä åäÇ ÈÇÎÑ ÇÕÏÇÑ:
MySQLDumper1.24.4.zip
https://sourceforge.net/projects/mysqldumper/