WordPress

#Turvalisusega seotud pluginad mis vaja wordpressi lisada

1) Akismet Anti-Spam
2) All In One WP Security
3) EWWW Image Optimizer
4) iThemes Security
5) Limit Login Attempts Reloaded
6) Sucuri Security - Auditing, Malware Scanner and Hardening
7) Wordfence Security
8) WP fail2ban


#Wordpressi mälu limiidi määramine

To increase the WordPress allowed memory size for your website:
1) Open wp-config.php, which by default is located in the root WordPress directory. 
Find the following line near the end of the file:
/* That's all, stop editing! Happy blogging. */
Just above that line, add the following line:

define('WP_MEMORY_LIMIT', '64M');

Save your changes. 
You can also increase memory to a higher number, and you can also increase the memory limit for admin tasks, as described in the WordPress codex.
If you’re still receiving the error after this fix, contact your web host provider or server administrator for their help. 

MySQL andmebaas

#mysql andmebaasi importimine käsurealt

mysql -u kasutajanimi -p andmebaas < /home/koopiad/file.sql

Check MySQL Options.
Note-1: It is better to use the full path of the SQL file file.sql.
Note-2: Use -R and --triggers to keep the routines and triggers of original database. They are not copied by default.
Note-3 You may have to create the (empty) database from mysql if it doesn't exist already and the exported SQL don't contain CREATE DATABASE (exported with --no-create-db or -n option), before you can import it.