====== Exporting/importing a database ======


http://codex.wordpress.org/Backing_Up_Your_Database


<code bash>

user@linux:~/files/blog> mysqldump --add-drop-table -h mysqlhostserver
 -u mysqlusername -p databasename (tablename tablename tablename) | bzip2
 -c > blog.bak.sql.bz2

</code>

===== Importar la misma base de datos =====


<code bash>
user@linux> mysql -h hostname -u username -p databasename < blog.bak.sql
</code>

O también: 

<code bash>
user@linux> bunzip2 -c filename.sql.bz2 | mysql -h hostname -u username - p databasename 
</code>