Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > AMPPS > General Support > Topic : Backup MySQL Databases



Threaded Mode | Print  

 Backup MySQL Databases (1 Replies, Read 22301 times)
focussss
Posted on # June 29, 2023, 7:53 am
Group: Member
Post Group: Newbie
Posts: 3
Status:
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?
IP: --   

Backup MySQL Databases
adeshmrane
Posted on # June 29, 2023, 12:34 pm | Post: 1
Group: AMPPS Team
Post Group: Newbie
Posts: 27
Status:
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
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is November 10, 2024, 5:49 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.028