A basic example of backing up a MySQL database using mysqldumb and exec. You may need to allow PHP to use the exec() function. Run phpinfo() to check if exec() is ...

The mysql gem returns only nil or string data types, leaving you to convert field values to Ruby types in Ruby-land, which is much slower than mysql2's C code. For a comparative benchmark, the script ...