Tag Archives: mysql

To upgrade to PHP & Mysql on plesk 10

To Upgrade to Mysql 5.1 on plesk 10 Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x Step 1) Set up the atomic channel: wget -q -O – http://www.atomicorp.com/installers/atomic | sh Step 2) Upgrade to Mysql 5.1 yum upgrade mysql Step 3) MySQL 5.1 removed the BERKLEY storage engine. Since it [...]

Commenti disabilitati

useful command for plesk maintenace

here some useful command  for plesk maintenance get ftp user password mysql -uadmin -p` cat /etc/psa/.psa.shadow` -Dpsa -e”SELECT login AS FTP_USER,password AS FTP_PASS,home AS DOMAIN_ROOT,accounts.id,sys_users.account_id FROM accounts, sys_users WHERE accounts.id=sys_users.account_id;” get email user password mysql -uadmin -p` cat /etc/psa/.psa.shadow` -Dpsa -e”select mail_name,name,password from mail left join domains on mail.dom_id = domains.id inner join accounts where [...]

Commenti disabilitati