Hi, I tried to backup Mysql Database through phpmyadmin but I can't really understand what happens. Say if my whole database sizes 150 mb the download stops at 8 or 9 mb itself. Why does this problem occur? Is there way to download? I use Wordpress. Is there any plugin by which I can download those databses? Please help me. Thanks!
you can not download ur mysql database from phpmyadmin unless u have 2MB/SEC speed which is very expensive alternative is that ask professional hosting companies to make backup for ur database. there are sites available for it like i think hostgator or some other site dont remmember the site name use google search engine u will find one for sure.
The problem can be anything, you should also try another database backing up software before you contact your web hosting service provider. I ask you to try using MYSQL administrator. It should work. Make sure that you are not attempting to download zipped backup, because sometimes, zipping process fails at server end and in turn, aborting the backup process.
You can login to cpanel click on Backups -> You will see a section "Download a MySQL Database Backup" there you will find the name of the db click on it.
If you have shell access you can take a backup using mysql -h localhost -u mysqlusername - p databasename > dbback.sql Then it will prompt for mysql password ,thats it