How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog

1. Have a backup.

2. Stop MySQL:

   sudo service mysql stop
   

3. Move (or copy) your mysql directory. If you want /mnt/mysql to be the new directory, do it like this:

   sudo mv /var/lib/mysql /mnt/
   

4. Open your MySQL configuration ...

Here is a way to create a duplicate of one database, with all its tables and their data, under a new name.

1. Make a dump of your source database:

   mysqldump -uroot -p my_project -r my_project.sql
   

   Or, if you only want to dump the datab...

There are many approaches out there how you can import data from a legacy application to a new application. Here is an approach which opens two database connections and uses active record for the legacy system, too:

1. Add you database informati...

The linked article explains how to get a database-wide lock without creating table rows:

This article explains how I replaced file-based methods to...

Sometimes you want to test migrations with production or staging data. Dumping single tables makes sense if a complete dump would be to big.

mysqldump -u deploy_user -p application_production table1 table2 table2 > table1_table2_table2.sql.du...

This may be awkward to set up, but will work once you're done.

Fun facts:

• In case of a connection loss the slave will try to reconnect to the master server and resume replication for the next 24 hours
• If you want to use your slave as a "real...

I had a huge MySQL dump that took forever (as in: days) to import, while I actually just wanted to have the full database structure with some data to use on my development machine.

After trying several suggestions on how to speed up slow MySQL du...

Rails understands a :limit options when you create columns in a migration. Its meaning depends on the column type, and sometimes the supplied value.

[The documentation](http://apidock.com/rails/ActiveRecord/ConnectionAdapters/TableDefinition/co...

This is an extract from the linked article. It shows an approach on how to implement encrypted passwords with the AWS Key Management Service (KMS).

For most applications it's enough to use a hashed...