loccom Posted January 25, 2016 Share Posted January 25, 2016 Hi On verison 3.4 i used to dump the db every day using the following example mysqldump -uuser -pXXXXXX Table | gzip > /home/XXXX.gz But since updating the to v4 I am getting locked tables while it is duming the database. Anyone know of a safe way to dump the db without locking and is safe? Link to comment Share on other sites More sharing options...
loccom Posted February 10, 2016 Author Share Posted February 10, 2016 can anyone help on this? Link to comment Share on other sites More sharing options...
Chris027 Posted April 5, 2017 Share Posted April 5, 2017 +1. How are other people doing this? Link to comment Share on other sites More sharing options...
Ioannis D Posted April 6, 2017 Share Posted April 6, 2017 I usually use this command to export my database: mysqldump -u [username] -p [database name] > [database name].sql or with phpMyAdmin or with Adminer or with SQL Buddy Link to comment Share on other sites More sharing options...
MADMAN32395 Posted April 7, 2017 Share Posted April 7, 2017 I use MySQL Workbench Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.