up vote 1 down vote favorite
share [g+] share [fb]

I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password?

Ideally I'd like to know the pg_dumpall as well as mysqldump commands to do so.

This can be useful in different circumstances, for example, when one wants to dump a database to be released to the public.

link|improve this question
59% accept rate
MySQL privileges aren't stored in each database. At least for MySQL, the privileges needed to restore a database are unrelated to those needed to dump it (i.e. to restore the database, you need to be able to login to the target MySQL server, and have permission to create a database). – cyberx86 Jan 1 at 5:31
@alfish - please go back and mark answers to your previous questions as "accepted". A 50% accept rate with 29 questions is pretty abysmal. – ErikA Jan 1 at 5:32
feedback

2 Answers

up vote 3 down vote accepted

Why would you ever need the original credentials to restore a database? Restoring only requires the credentials of the database you're restoring to, not the original source.

link|improve this answer
Well, at least for this mysql to postgresql conversion I understand that the original credentials are required: groups.drupal.org/node/15793 – alfish Jan 1 at 5:54
1  
That migration script needs the source and destination credentials to do its migration. This has nothing to do with database dumps requiring original credentials to restore. – ErikA Jan 1 at 6:01
feedback
up vote 3 down vote

Don't use pg_dumpall for postgres - use pg_dump. That will give you a dump that's independent of the original passwords. Then use pg_dumpall -g to get the users and passwords - so you at least know which usernames are supposed to be there.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.