On Sun, Mar 15, 2009 at 2:43 PM,  <jida...@jidanni.org> wrote:
> OK, but then the structure of those tables are gone from the dump too,
> not just their contents. We cannot thus recover from scratch straight
> from the SQL dump. But perhaps we then can immediately run a
> maintenance script to recreate the missing tables' structure?

Then you could just do

$ mysqldump --ignore-table=my_database.wiki_objectcache
--ignore-table=my_database.wiki_searchindex my_database > backup.sql
$ mysqldump -d my_database wiki_objectcache wiki_searchindex >> backup.sql

or something similar to that.

_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to