LMSouq
database Open

Run MySQLDump without Locking Tables

GR
Greg
1 month ago
3 views
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

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base