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
[...] This post was mentioned on Twitter by wordpressapi. wordpressapi said: RT @wordpressapi How to take mysql backup from file system http://bit.ly/dr5ZPJ [...]
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