First we access the system with SSH
then find the latest all-databases dump file
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!
then find the latest all-databases dump file
- cd to it
- un zip
- 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!
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.
No comments:
Post a Comment