I have tables owned by xxx but don't know the password for user and can't change it.
I want to login as myself aaa/aaa and dump data for schema=xxx tables=one, two, three but this is not allowed.
Is there a way to get around this? I guess I can export the whole schema and only import the data for those tables I need but the there is alot of data.
Any idea?
Thanks