best way to backup/save database

[SPEEDKILLZ]

As the title says how and what is the best way to save or backup my database with cpanel? Thanks

[snakes1100]

The best way to backup a database is via the cmd line, using mysqldump, if you shell/ssh access to the server.

You should have no issue using the built in backup program via cpanel.

Using anything related to php is not suggestible as it can timeout when running a php script for a long time, depending on the size of the db, the setting for max_execution_time should be adjusted to a large timeout if your doing them via a script or a program such as phpmyadmin.

[SPEEDKILLZ]

Thanks, so what are the steps? Where do i go to save db to my

[snakes1100]

Steps for what cpanel backup or ssh backup?

[SPEEDKILLZ]

Cpanel or both

[snakes1100]

There are hundreds of tutorials that you can find on google.

[betterthanyours]

In cPanel it's easy. Click backups and then click the db you want to backup and download it. Simples.

for CLI:
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

[Disco_Dave]

I find this the best method:

https://vborg.vbsupport.ru/showthread.php?t=231481