what is the best way to backup mysql database? using a mysql existing tool or technique?
The database has million of records, and will need to be backed up every data entry from the user. Answer For small databases I’m personally use phpMyAdmin. For bigger databases (SQL dump is, let’s say, more than 5MB) I prefer backing up from command line using standard MySQL tool mysqldump: mysqldump -h localhost -u username … Read more