mysql database replica

I wanted to ‘clone’ the production database for my giggle project to my development environment, so I could have more realistic data for testing with.

First I created database ‘giggleclone’, then ran a command like this:

mysqldump -h -u edward -ppassword --opt giggle2 | mysql -h localhost -u giggledev -ppassword -C giggleclone

I haven’t figured out how to do this without specifying the passwords in the command line.

Post a Comment

Your email is never published nor shared. Required fields are marked *