URL related simple MySQL functions
Below you can find simple MySQL code snippets to extract various information from URLs stored in a database table.
How to dump MySQL database and split into 10 MB files on the fly
Recently I had to dump a database that was too big to dump with with phpMyAdmin and I couldn’t just use mysqldump tool from command line because there was a 10 MB file size limit on the server.
What SQL queries PHP scripts execute (without looking in the code)?
Sometimes I need to check what SQL queries is PHP script executing, but when code is quite complex (or encoded with Zend Guard or IonCube) it is extremely hard or even impossible to get this information from php files.
So- here’s a nice solution for this problem. It will log all the SQL queries send to the MySQL server in a MySQL table.
How to move Magento shop to another host?
To successfully move a Magento store to another host (including localhost) you can just follow the steps above.
