4
votes
2answers
1k views

MySQL export tables with prefix from Unix command line

I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_". I do not have access to ...
3
votes
4answers
2k views

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. ...