Can't create backup of my Database

[simone_romeo]

Greetings,
I'm trying to create a backup of my Database but it just seems impossible.

• If I export database from PhpMyAdmin it just loads infinitely and page crashes for being loading too long.
• In the admin panel -> System -> Tools I don't have the "Backup" option.
• In System -> Configuration -> Advanced -> System I don't have the option to schedule backups.
• In the Connect Managare I can select which backup I wanna do and name it, but there is no button to start the process.

What can I do?

[Mukesh Tiwari · Accepted solution]

Hi @simone_romeo 

If you are on latest version of Magento or have applied SUPEE-10975 patch. The Magento Backup module is disabled.

Refer:

 https://devdocs.magento.com/guides/m1x/ce19-ee114/ce1.9_release-notes.html#ce19-1940

https://magento.stackexchange.com/questions/251317/supee-10975-potential-issues

If you have SSH access to the site use following command to create backup.

mysqldump -h <host> -u <username> -p <database> > dumpfile.sql

For large database always use SSH to take backup.

[simone_romeo]

Hi @Mukesh Tiwari and thank you for your reply.

I solved the problem with the guide you posted, it was very useful! Thanks!