I’m running a MySQL-based application and two things need urgent attention: 1. Something in the database layer is malfunctioning. I’m seeing symptoms typical of collation or connection hiccups, but I haven’t pinpointed whether it’s a bad query, a latent connection failure, or straight-up data inconsistency—so I need a full check-up of tables, indexes, and server settings to isolate and resolve the root cause. error -- Broken table smb_componentUpdates: Corrupt failed Repairing table 'smb_componentUpdates' Try to restore automatic daily dumps stored in /var/lib/psa/dumps error Broken table smb_productUpgrades: Corrupt failed Repairing table 'smb_productUpgrades' Try to restore automatic daily dumps stored in /var/lib/psa/dumps warning - Checking the structure of the Plesk database package_id last_notification - this has may be corrupted or deleted. need to fix this. 2. When I export data to .csv, certain characters appear garbled. (£) is not fetching on values in shell that requires. it is missing. that need to fix. & add £ sign before value. as per columns title. some columns do not require £ so. only apply £ sign where value £ is shown in title column & remove some random character before A'£ 3. you must work only on remotely. i need to see what has changed to fix these issues. i will not provide access to our live server. if you cannot work remotely connection, this task is not for u. Deliverables I expect: • Clean, repeatable steps (or script) that repairs the database issue and prevents its return. • A patched export routine that produces a flawless .csv file—even when the data contains accents, symbols, or multi-byte text. • A detail notes explaining what you were wrong and how fixed it so I can maintain it going forward. Skill, you need --- MySQL, Plesk, CodeIgniter, PHP If you’re comfortable digging into MySQL configuration, character sets/collations, and CSV generation logic, I’m ready to get this wrapped up quickly.