Problem Description
I want to copy a live production database into my local development database. Is there a way to do this without locking the production database?
I'm currently using:
<!-- language: lang-none -->
mysqldump -u root --password=xxx -h xxx my_db1 | mysql -u root --password=xxx -h localhost my_db1
But it's locking each table as it runs.
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?