Differences

This shows you the differences between two versions of the page.

--- mysql:exportadatabase [2012/04/13 07:29] – rlunaro
+++ mysql:exportadatabase [2022/12/02 21:02] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== 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>