Throttle a MySQLDump export so it doesn't lock up your production server

Trying to get your MySQLDump to relax a little bit?

If you are running InnoDB, consider running your mysqldump command with the following options:

--single-transaction --quick

This will slow the execution enough that your production site should still stay somewhat performant and not just hijack the server until it completes.

There are associated concerns, of course, but this should get many users through a MySQL dump on a live site.

So, for those of you looking for a complete MySQLDump command example using these switches, try:


How to easily move databases from staging to production environments

HeidiSQL allows you to copy entire schemas DIRECTLY ACROSS database servers!

Often times people are faced with the cumbersome task of moving an entire database from one environment to another, usually by creating a dump file of the database, moving it across from one database server to another, and re-running the script on the destination. This is irritating in that it requires one to create a file that is immediately disposed of, and to transfer that file one or two times over the wire. It is also prone to error in that it entails many distinct steps that each have their own glitches or mistakes to make. The good news is that the easy, one-step solution exists in a product you just haven't tried yet.


Magento Product Export Not Working - getting "No Valid Data Sent" error

Are mysteriously corrupt records causing your exports to fail?

Sometimes Magento Community Edition version (and perhaps other versions) throw an error when you try to use the built-in product export feature. I've been able to find the particular product SKU's in my catalog that are causing the export routine to bomb, but I couldn't for the life of me figure out what was wrong with these records. I could not trace a specific condition back to the problematic records for something to blame, such as simple versus complex product types, attribute sets, funky characters or encoding, missing values - nothing. It seemed as if there was some sort of invisible problem with certain records that would cause the product export to fail.

I looked in the exception log and saw this super-helpful error message:


Subscribe to RSS - Export