export backup of my forum database

khalled

Active Member
Jan 8, 2011
34
0
56
when i try to export backup to my PC from my forum database via mysql at cpanel i not success in that may because of large size of the database (3500 Mb) is there is any way of command which i can use to take this backup
i have root access to VPS server
 

khalled

Active Member
Jan 8, 2011
34
0
56
many thanks the problem that who i can download this backup to my local computer , when i go to Cpanel --- Backup ----
Download a MySQL Database Backup ,
and try to download the backup it's partially downloaded
is there is software or command to download backup of database to my computer
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
is there is software or command to download backup of database to my computer
After generating the MySQL database backup using mysqldump, you can access the server via a SFTP client (e.g. FileZilla) as root and download the SQL file.

Thank you.