Training

When: Every first Sunday of every month -get a ticket- from $15 (Click Here).

Thursday, January 23, 2014

Recovering wordpress with database

First we access the system with SSH
then find the latest all-databases dump file
  1. cd to it
  2. un zip
  3. drop your tables

create a single database backup from latest:

shell> sed -n '/^-- Current Database: `test`/,/^-- Current Database: `/p' fulldump.sql > test.sql

You just need to change “test” to be the name of the database you want extracted.

them use that from phpmyadmin

all fixed!

No comments: