How do I import a Database using PhpMyAdmin in Cpanel
To import we will need the file in .sql format, not compressed .zip or .tar.gz file.
Log into your CPanel and find the link for PhpMyAdmin.
Once in PhpMyAdmin you will see on the left side a drop down of the databases, select the database you would like to import to.
This will create some tabs at the top of the screen, click on SQL.
After clicking on SQL you will see a Text Box area and a file upload option.
Click browse on the file upload option and find your .sql file
After you have selected the file click GO and it will import your database to the server.
Instructions for deleting the swap file after import in Ensim
Eg. partition - /dev/hda3 mounted on /, swap file - /var/swapfile.
Turn off swapping for file “/var/swapfile” with the following command:
swapon, swapoff - enable/disable devices and files for paging and swapping
Swapoff disables swapping on the specified devices and files. When the -a flag is given, swapping is disabled on all known swap devices and files (as found in /proc/swaps or /etc/fstab)
Delete the file “/var/swapfile” with the following command:
Fix MemoryError exception occuring during import sites with Ensim Pro
Restore of appliance, reseller, site and user fails with the “MemoryError” if the size of the backup tar file is greater than the aggregate size of RAM and swap space.
Add extra swap space to the EPL server before doing the restore.
The extra swap space is added to the EPL server by setting up a new swap file and enabling swapping on it. The EPL server must have enough disk space to create the swap file. After the restore is successful the swap file can be deleted following the instructions provided to delete the swap file.
How to import sites with custom MX records Ensim Pro Control Panel Linux
The import of a site with custom MX records could cause creation of duplicated MX records: apart from custom MX records which are defined in the imported archive, default MX records could be created.
In order to avoid this, please proceed through the following steps when importing a site with custom MX records:
1. Before importing sites disable the creation of default MX records. Run the following command(s) as root:
/usr/local/bin/SetDefaultMXRecordState -f on
2. Restart epld service using the following commands as root:
3. Import site from the archive.
4. When the site is succesfuly imported, please turn off the freezing of MX records for imported sites.
For this, run the following commands as root:
/usr/local/bin/SetDefaultMXRecordState -f off
Reference : http://parallels.com/
