0
How do I backup mysql by data folder? I want to make a back up by the folder date, because banks are great if you do via dump will take a long time to download to climb again besides great chance of error.
1 answer
0
I agree with what @Falion says! Risky in many ways! Some databases have code, while trying to copy system folders that contain user’s database, the intended system which is an attempt to illegally copy software... if it is opensource may only stop working. but do a test (take all precautions and if you notice that something can go wrong give up) create a virtual machine (install windows with xampp for example .. or linux what you prefer>) and play in the backup (remember to stop the server!!!) of your "date" in the date folder (?!?!?!) This is almost 100% chance that it won’t work and if you don’t back up the old date and it doesn’t work, you have to be from another planet to do multiple backups of /data.
Use mysql prompt to migrate :
https://www.mysql.com/products/workbench/migrate/ https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-data-migration-setup.html
This reading should solve your problem!
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
It is not advisable to backup by folder, because the data may end up getting lost, it is advisable to do via dump because as much as it is time consuming, it is a safe method to do.
– Falion