So, Today After i updated Ubuntu... It was not booting,
So i followed this recovery process as adviced by support
viewtopic.php?f=46&t=10584
I successfully managed to make a backup of all the files. But i want to make a backup of the MySql Databases As i can not use mysqldumb or a webserver , what are the other process to make a backup of the database?
Backing Up MySql Database.
-
Faqahat
- New to forums
- Posts: 1
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Wed Dec 16, 2015 7:33 am
Re: Backing Up MySql Database.
I'd recommend backing up the entire system, such as by using the "rsync" tool to copy it elsewhere (to an SSD partition or a different VDS). You'll then be able to restore any files later and not have to worry about whether you missed any.
If you're reinstalling the same version of MySQL, you should be able to bring over the old MySQL databases by saving its data folders and then wholesale replacing the default ones on the newly-installed version (while the MySQL server is stopped). By default, these should be in /var/lib/mysql. Also note that if you are using InnoDB tables, you may need to perform additional recovery steps (this will become clear when you start the server, if it refuses to start). InnoDB is not very good when it comes to handling crashes.
If you're reinstalling the same version of MySQL, you should be able to bring over the old MySQL databases by saving its data folders and then wholesale replacing the default ones on the newly-installed version (while the MySQL server is stopped). By default, these should be in /var/lib/mysql. Also note that if you are using InnoDB tables, you may need to perform additional recovery steps (this will become clear when you start the server, if it refuses to start). InnoDB is not very good when it comes to handling crashes.