Many times we fail to restore the mysql dump from command line.
Some times mysql server crash. First go to your filesystem.
Here I am using the fedora OS for this example
In linux go to /var/lib/mysql path
In that folder each folder means seprate database.
Copy that all folders to your local machine.
again go to your mysql local installtion and paste that folder into your mysql folder.
For in each database folder file you will find follwoing types of files in the folder
db.opt
test.frm
test.MYD
test.MYI
just copy and paste in your system
Incoming search terms:
- mysql backup filesystem
- mysql filesystem backup
- mysql files backup filesystem
- linux mysql backup databases on filesystem
- mysql backup filesystem linux
- mysql backup from filesystem
- mysql file system backup
- mysql filessystem copy files
Pingback: Tweets that mention How to take mysql backup from file system -- Topsy.com
I really enjoy the blog post. Much obliged.
Advantageously, the article is actually the best on this deserving issue. I fit in with your conclusions and will thirstily look forward to your comingupdates. Saying thanks will not just be adequate, for the fantasticlucidity in your writing.
Good post, thanks