Question: So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked.
Is there a way to stop the process without losing data? I can´t access to any other admin panel utility or make any purchase on my store.

Answer: 
You can take a backup by commands.

```
mysqldump -u username -p dbname > db_dump.sql

```
Backup time depends on how many products & customers you have.

You can truncate all log data in your database.

1. Instead of Manual backup , you can take backup at night time by setting scheduled backup

> 
> System > Configuration > Advanced > system> Scheduled backup setttings
> 
> 
>
2. Also, you can take backup in **phpmyadmin** by importing the Database.
3. If you have ssh access, you can take backup by commands.

> 
> mysql -uUSER -p -hHOST DB\_NAME < db\_dump.sql
> 
> 
>