MySQL Forums
Forum List  »  Newbie

Need help understanding sqldump
Posted by: Jeremy R
Date: December 04, 2018 11:44PM

I want to make a dump of db1 from one web server to a development server so I can do around with a few changes in a working version of the production site.

I have read a few tutorials about sqldump and I am confused about how permissions work, and it has me scared I am going to screw something up.

When I dump the database, does it make a difference which mysql user account I use?

When I import the database on the development server, does it make a difference which user account I use?

Do I just have to make sure that I 'GRANT ALL PRIVILEGES' on the database and that it matches up in the wp-config.php file?

Options: ReplyQuote

Written By
Need help understanding sqldump
December 04, 2018 11:44PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.