Install an OpenVPN client: Fedora/CentOS/RedHat: yum install openvpn Ubuntu/Debian: apt-get install openvpn In general, the easiest way to install an OpenVPN client is to use the –config argument to specify the location of the client config file: openvpn –config client.ovpn
Set it temporarily, by running the following commands on mysql console: set global slow_query_log = 1; set global slow_query_log_file = ‘/var/log/mysql-slow.log’; the changes will be undone when mysql is restarted. Set it permanently, by adding the following in “my.cnf” file: slow-query-log=1 slow-query-log-file=/var/log/mysql-slow.log The location of my.cnf varies by OS, but is often found in /etc/my.cnf,
Example doctrine console command: php vendor/bin/doctrine orm:generate-entities –help Available commands: dbal:import Import SQL file(s) directly to Database. dbal:run-sql Executes arbitrary SQL directly from the command line. orm:clear-cache:metadata Clear all metadata cache of the various cache drivers. orm:clear-cache:query Clear all query cache of the various cache drivers. orm:clear-cache:result Clear result cache of the various cache drivers.
Show doctrine constructed query and parameters print $query->getSQL(); foreach ($query->getParameters() as $param) print_r($param);
Mysqldump only tables with certain prefix: mysqldump DBNAME $(mysql -D DBNAME -Bse “show tables like ‘wp_%'”) > FILENAME.sql
Generate a Self-Signed Certificate At the shell prompt, issue the following commands to install SSL for Apache and generate a certificate: yum install mod_ssl mkdir /etc/httpd/ssl openssl req -new -x509 -sha256 -days 365 -nodes -out /etc/httpd/ssl/httpd.pem -keyout /etc/httpd/ssl/httpd.key Configure Apache to use the Self-Signed Certificate NameVirtualHost *:443 SSLEngine On SSLCertificateFile /etc/httpd/ssl/httpd.pem SSLCertificateKeyFile /etc/httpd/ssl/httpd.key ServerAdmin info@mydomain.com
tar tar files tar cvf dest.tar file.txt file2.txt Tarring folders tar cvf dest.tar myfolder/ Untar the file or folder tar xvf dest.tar tar.gz Compress using gzip: tar cvfz dest.tar.gz myfolder/ Uncompress zip file: tar xvfz dest.tar.gz tar.bz tar cvjf dest.tar.bz2 myfolder/ Extract: tar xvjf dest.tar.bz2 Extracting individual files tar xvjf dest.tar.bz2 textfile.txt
To execute a script at startup of Ubuntu Edit /etc/rc.local and add your commands The script must always end with exit 0 To execute a script upon rebooting Ubuntu: Put your script in /etc/rc0.d Make it executable (sudo chmod +x myscript) Note: The scripts in this directory are executed in alphabetical order The name of
This command will dump a MySQL database, compress it and save it to a file (replace userName and databaseName with your data): mysqldump -u userName -p databaseName | gzip > databaseName.sql.gz The import command takes a compressed MySQL dump, decompresses it and adds it to the database (replace userName and databaseName with your data): gzip
The dump function dumps information about a template variable. It can be used as an alternative to var_dump or print_r from php. This is mostly useful to debug a template that does not behave as expected by introspecting its variables: {{ dump(var_name) }} Read entire article at: Twig -> Functions -> dump