ImageMagick® is a software suite to create, edit, compose, or convert bitmap images. It can read and write images in a variety of formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PNG, Postscript, SVG, and TIFF. Use ImageMagick to resize, flip, mirror, rotate, distort, shear and transform images, adjust image colors, apply various special effects, or draw text, lines, polygons, ellipses and Bézier curves.
Make sure that the required dependencies are installed:
Always backup your MySQL database with mysqldump but if you didn’t you can restore it from file system.
If your backup include the /var/lib/mysql directory, if so then you should be able to restore the database. Each database is contained in a separate subdirectory off /var/lib/mysql, so look for one named with the name of your database (WordPress or any other). To restore it, shutdown the mysql server first
sudo /etc/init.d/mysql stop
Copy the backup-ed directory into the same location on your new server, then restart mysql server
sudo /etc/init.d/mysql start
Note:- that its much better to take actual database dumps using the mysqldump command than to rely on this method. so for the future, you should schedule something like this:
Parallels Plesk Panel renames ‘root’ mysql account to ‘admin’ when the Panel is installed.
To get root privileges in mysql simply login with the ‘admin’ username instead. The password is the same as the admin password in Parallels Plesk Panel.
On server with Parallels Plesk Panel versions 8.x, 9.x and above admin password is stored in file /etc/psa/.psa.shadow. Use the following command to get the password:
~# cat /etc/psa/.psa.shadow
Since version 10 admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text:
~# /usr/local/psa/bin/admin –show-password
Despite version of Parallels Plesk Panel you may use the following command to login to mysql with root privileges: