backup through plesk, then restore not work

[Michael neese]

I backed up a domain, with domain settings and all content selected...it was saved to the ftp repository...then when the restore was needed, I used the plesk interface to the server repository...

Using the restore utility with this command line...

/usr/local/psa/bin/pleskrestore --restore /var/lib/psa/dumps/domains/allisonbellowsjewelry.net/sun_allisonbellowsjewelry.net_info_1003211212.xml -level domains -filter list:allisonbellowsjewelry.net -suspend

This gave me a message in plesk that the restore had completed...

When viewing the restore, I found that indeed the domain settings had been restored, but the data from the mysql database was not restored...this is a joomla site...

Why was the database not backed up then restored properly? Is there more restoration I have to do with the database, or change some configurations, or maybe the command for restoration was incomplete?

 

[IgorG]

It is very difficult to say what is wrong there without logs, error messages, etc. There are can be different reasons - keys in Latin1 in Joomla databases which will be incorrectly converted to UTF8, or comments in database dumps, or different Mysql versions... How it is possible to find a reason without any details and deep investigation?

 

[Michael neese]

You are right, the question is too broad...let me be more specific...

When a backup is made for a domain, with domain settings and all content specified...does that mean a full database backup as well?

Then, when the restore is done...does that overwrite the database automatically? Would there be a warning or question regarding this overwriting the database....or would the database restore require the phpadmin interface...

Also, where do I see the logs for the backup and its content, as well the logs for the restoration, and any possible errors involved...In the documentation for restore I see nothing regarding this log information...

And lastly, is there a backup solution within plesk for the database itself...if so, where is the information on that backup and restore process...

 

[Michael neese]

You mentioned keys in Latin1 joomla database... all the domain databases are created by plesk before installing joomla, the are utf8...why would there be different mysql?

This is a fresh server, 9.3 installed by 1and 1, with default everything except security enhancements such as mod-security....

All the databases are created through plesk, so if there are incompatibilities, it is not to do with anything but plesk management of databases...

By the way, I see that the plesk databases are (default 9.3 installation last month by 1and1) on fresh server are listed as...
horde....latin1_swedish
mysql....latin1_swedish
phpmyadnin...latin1_swedish
psa....latin1_swedish
tortix....latin1_swedish

Whereas the new databases created for new domains through the plesk admin interface are ALL...utf8_general_ci

Is this unusual...is this a problem? Are all my backups/restores bad because of these plesk database inconsistencies????