![]() ![]() For example: If its an entire DB, then: mysqldump -u uname -p dbname > dbbackup. Increase the value of $cfg in config.inc. You can accomplish this using the mysqldump command-line function. mysqldump -u USERNAME -p DATABASENAME > dbbackup.sql. Once the upload is complete, the bottom of the browser will indicate dump complete. Using the same cPanel program, browse to the gz file and upload it. There is no need to unzip this file to restore it. gz file will be downloaded to your local drive. After clicking on shell button, it will open a shell window. Look for ‘Download a MySQL Database Backup’ and click the name of the database. Open xampp window and click on shell button as shown in the following screenshot. These commands will backup database ABC-database into a SQL dump with the name ABC-database-backup.sql. mysqldump mysql-database > ABC-database-backup.sql. Take a backup of the database named ABC-database with this command. Note: if the issue still persist, the browser cache should be cleared.Ĭopy the content of %plesk_dir?min\htdocs\domains\databases\phpMyAdmin\libraries\ to %plesk_dir?min\htdocs\domains\databases\phpMyAdmin\.Ĭopy the content of %plesk_dir%phpmyadmin\libraries\ to %plesk_dir%phpmyadmin\. Try exporting the database using mysqldump. PHPMyAdmin Step 1: Create MySQL Dump from PHPMyAdmin Step 2: MySQL Dump Restore using PHPMyAdmin Step 1: Create database Step 2: Restore Database Summary Command Line We will first create and restore MySQL backup using command line. Connect to MySQL server via command line. Increase the settings in /etc/sw-cp-server/config to avoid '504 Gateway Timeout' error: Increase the value of $cfg in created on step 2:ĬONFIG_TEXT: $cfg = 3600 In the first place, go to the official phpMyAdmin website and download the. ![]() # cp -p /usr/local/psa/phpMyAdmin/libraries/ /usr/local/psa/phpMyAdmin/ PhpMyAdmin is a web database management software written by php script. # cp -p /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/ /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/ For Plesk Onyx and Plesk Obsidian below 18.0.30: ![]()
0 Comments
Leave a Reply. |