Jan 28, 2009 ·
2 minute read
mysql
This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub Some times you are working on a database that is just too big to export and import via phpMyAdmin. In those circumstances the best alternative is to use the Linux command line, usually via SSH.
Read On →
Jan 27, 2009 ·
1 minute read
php
This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub Sometime you need a PHP script to check for the existence of a MySQL table. This function achieves that for you. function db_table_exists($table){ $exists = false; $tables_query = db_query("SHOW TABLES FROM " .
Read On →
Jan 27, 2009 ·
1 minute read
php
This is post is now quite old and the the information it contains may be out of date or innacurate. If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub A lot of hosting accounts do not have CLI PHP enabled. If you have some maintainence scripts that you want to run on a regular basis then you can still do this using cron combined with cURL.
Read On →
Jan 23, 2009 ·
1 minute read
magento
If you installed Magento via any other method than the downloader, then when you come to use Magento Connect, you will find that you are unable to due to permissions. For Magento Connect to work, all folders must have 777 permissions. If you have SSH access to your server, you can fix this by running the following command: find ./ –type d –exec chmod 777 {} \; If you don’t have SSH access you could try a php based SSH emulator instead.
Read On →
Jan 22, 2009 ·
1 minute read
php
Upgrading Magento can be a little tricky. I would definitely advise testing out any upgrades on a development copy of your site, not applying updates directly to the live site without testing for problems first. Being such a young platform, Magento is in a phase of rapid development. Inevitably this development will introduce bugs and issues. Hopefully these will generally be minor but even so, you would want to get them resolved before applying them to your live site.
Read On →
Jan 21, 2009 ·
1 minute read
magento
There are a few simple steps you need to take to move your Magento based store from one place to another. First of all, create a full SQL dump of your store’s database and import this to a database on the new server. To do this, simply use the backup functionality within the Magento Admin. If you use phpMyAdmin things can become a bit weird. Then copy all files apart from the contents of the /var/ folder to the web root of the new server.
Read On →