Mysql – Deleting entries from tables
- No Comments
- Jun, 23, 2010
- Angelo Schalley
- Linux, MySQL, Plesk Linux
The SQL delete statement requires the table name and optional conditions.
DELETE from table_name [WHERE conditions];
NOTE: If you don’t specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED!!!
Read more on Mysql – Deleting entries from tables…
plesk mod_suphp php tmp
- No Comments
- Nov, 29, 2009
- Angelo Schalley
- Plesk Linux
create a tmp directory in you sites root
place a file php.ini in your sites root and add the following content :
allow_url_fopen=off
upload_tmp_dir = “/tmp”
session.save_path = “/tmp”
read / recover ftp password from a plesk database
- 3 Comments
- Oct, 23, 2009
- Angelo Schalley
- Plesk Linux
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e “use psa; select accounts.password from accounts INNER JOIN sys_users ON accounts.id=sys_users.account_id WHERE sys_users.login=’xxxx’;”
specify sys_users.login=’xxxx’ ( user login xxxx )
Categories
