Tags » Mysql

How to Clean Order database in magento

Open Putty with your default Username & Copy – Paste the below Script in it.

Run below script to clean the order database in magento… 722 more words

Magento

How to take a db backup in Magento

Open Putty with your default Username & Copy – Paste the below Script in it. 

$ mysqldump -u root -p Tutorials > tut_backup.sql
Magento

How to Change Directory of root of server in Magento

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Change Directory of root of server.

sudo nano /etc/apache2/sites-available/000-default.conf
DocumentRoot /var/www/html
sudo nano /etc/apache2/apache2.conf
<Directory /var/www/html/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>
sudo service apache2 restart
Magento

How to Change Permission of Magento Root folder

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Permission changed of html folder

sudo adduser <username> www-data
sudo chown -R www-data:www-data /var/www
sudo chmod -R g+rwX /var/www
restart after it
Magento

How to Change Existing Customer Email Address

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Customer Email change

select * from sales_flat_order_address where email='old@gmail';
update sales_flat_order_address set email='new@gmail.com' where email='old@gmail' and telephone='Telephone Number'; 70 more words
Magento

MySQL DoS in the Procedure Analyse Function - CVE-2015-4870

This is a crash I found in MySQL versions up to 5.5.45. In the function procedure analyse() I found this crash while passing a sub query. 938 more words

Web Application Security

Updated pbuilder4cpp, 1.1404.Final released

pbuilder4cpp 1.1404.Final has been released. This version fixes a minor bug (12) and is the last release compatible with Ubuntu 14.04 and earlier versions.

Enjoy it!

C++