Softaculous


Topic : Backup MySQL Databases


Posted By: focussss on June 29, 2023, 7:53 am
Is it possible to backup the MySQL databases that are in MyPhpAdmin by backing up specific folders rather than going in and having to export the database and then back them up?

Posted By: adeshmrane on June 29, 2023, 12:34 pm | Post: 1
Yes, you can back up your MySQL database manually by backing up the data folder. (path/to\Ampps\mysql\data)
one drawback of using this technique is you need to create a backup for the complete data folder. If you do it for any specific folder inside the data folder then your restore will not work.

it is not a recommended approach because the databases consist of more than just the files within those folders(data files, index files, and other components that are essential for the proper functioning of the database). Instead, it is best to use the backup and restore tools provided by MySQL, such as the mysqldump utility or export utility by phpMyAdmin

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.