Category Archive for "MySQL"

How to move Magento site from subdomain to main domain?

Moving magento site from subdomain to main domain (and vice-versa) is quite easy. And you can do it by two different way and you will feel it is more easy when you go through how to do it. Process I: You need to do as per following steps to achieve this: STEP 1: Go to Magento Admin –> System –> Configurations –> Web –> Unsecure URL & Secure URL. Change both the secure URL and unsecure URL to the domain…

Read More

How to reset Auto-increament in MySQL?

It is possible to reset the auto increment value of a MySQL auto incremental primary key to a new value, either higher or lower than what it would otherwise next be. This post looks at how to do this using a MySQL query and also with phpMyAdmin. The following example changes the auto increment value for the table named “mytable” to 1. This means that the next time you insert a record into this table the value of the auto…

Read More

How to ensure your WordPress site’s security?

What is Security? Fundamentally, security is not about perfectly secure systems. Such a thing might well be impractical, or impossible to find and/or maintain. A secure server protects the privacy, integrity, and availability of the resources under the server administrator’s control. Your website can never be 100% secure. Hackers are always trying new things and discovering new vulnerabilities to exploit. The online world changes quickly and the same is true of security. Good security is about minimizing risk. If anybody…

Read More

How to export the data from MySQL into a XML file with PHP?

There are a couple of ways to export data from MySQL to a XML file. This post looks at how to export the data from MySQL into a XML file with PHP. The example code below uses the raw mysql_* functions but it should be easy enough to substitute a database library’s functions instead. It also writes the data out line by line to the XML file whereas you could buffer the whole file in memory and write it out…

Read More