duyfr Posted March 9, 2016 Share Posted March 9, 2016 hello this problem is nothing with ips product , but idk where to post this so ..... Problem is when i use mysqldumper try to back up my database , site down , after 3 min it back , seem mysql got timeout , but when i connect and back up direct in phpmyadmin , all working good , i dont know what happened with mysqldumper . i used it always and never seen this problem , i just upgrade mysql to version 5.7.6 so i think problem is from file my.ini ? Thanks to help ! Link to comment Share on other sites More sharing options...
Rhett Posted March 9, 2016 Share Posted March 9, 2016 Depending on the size of your site, this can be normal, as mysqldump locks the tables while backing up, if the tables are large or your hosting/server is very slow, you may notice this above. Link to comment Share on other sites More sharing options...
duyfr Posted March 9, 2016 Author Share Posted March 9, 2016 4 minutes ago, Rhett said: Depending on the size of your site, this can be normal, as mysqldump locks the tables while backing up, if the tables are large or your hosting/server is very slow, you may notice this above. its my host http://prntscr.com/ad8pv6 and my file to back up have ony 7 mo Link to comment Share on other sites More sharing options...
RevengeFNF Posted March 9, 2016 Share Posted March 9, 2016 Try mydumper 0.9.1, its a lot faster. Link to comment Share on other sites More sharing options...
duyfr Posted March 9, 2016 Author Share Posted March 9, 2016 8 minutes ago, RevengeFNF said: Try mydumper 0.9.1, its a lot faster. it for linux i guess ? Link to comment Share on other sites More sharing options...
RevengeFNF Posted March 9, 2016 Share Posted March 9, 2016 3 minutes ago, duyfr said: it for linux i guess ? Yes. You are using Windows? Link to comment Share on other sites More sharing options...
duyfr Posted March 9, 2016 Author Share Posted March 9, 2016 10 minutes ago, RevengeFNF said: Yes. You are using Windows? yes , with apache service i like to move to other host but when i restore it said "mysql version different" and i cant downgrade mysql , i using mysql version 5.7.6 , most of web hosting use 5.4 or 5.5 i think Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.