Symfony2 Doctrine debug query
Show doctrine constructed query and parameters print $query->getSQL(); foreach ($query->getParameters() as $param) print_r($param);
Month: May 2015
Mysqldump only tables with certain prefix
Mysqldump only tables with certain prefix: mysqldump DBNAME $(mysql -D DBNAME -Bse “show tables like ‘wp_%'”) > FILENAME.sql
SSL Certificates with Apache 2 on CentOS
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…
Tar and untar files and folders
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…
Ubuntu – Executing a script at startup and shutdown
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…
Exporting and Importing Compressed MySQL Databases
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…