PSA Database

[danl]

I seem to have an incomplete database after upgrading, I've tried using the backups (each type) but I keep end up with problems - the most notable being when trying to use the update;

ERROR: PleskMainDBException
Up LevelUp Level
MySQL query failed: Table 'psa.ai_vendor_sources' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:211
db_query(string 'SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources')
1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:142
AutoInstallerVendorSource::getVendorSources()
2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
AutoInstallerManager->install(string 'PLESK_8_1_1', array, boolean false, string 'u45099873@irdan.com')
3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:117

I don't mind starting virtually afresh with the database, I just need all the correct default tables - is there any where I can get it from?

thanks

 

[halfabee]

I have a similar problem.

For some reason mysql removed all the .myi files and only left the .frm files.

I have the psa backups, but they only have data and not the table structure.

Maybe some kind plesk user could do a structure dump of the psa DB.