Database backup SSH file location?

[DaveL]

I need to make a backup of my forum database via SSH as too large for phpmyadmin. I've found the below command:
mysqldump -uUSERNAME -p DATABASE > backup.sql

Can anyone advise how I choose the location of where the database will be downloaded to?

 

[AndyB]

The backup.sql is a path you define. For example:

mysqldump -uUSERNAME -p DATABASE > /home/user/backup.sql

 

[DaveL]

Thanks @AndyB
Still new to SSH, but gradually picking it up!

 

[AndyB]

Keep in mind that once you get the SSH command working properly, you can add that same command into a Cron Job so it can backup your database every day.

 

[eva2000]

Remember for XF 2.1 to read https://xenforo.com/community/threads/public-service-announcement-check-your-mysql-backup.152740/

 

[Itworx4me]

I need to make a backup of my forum database via SSH as too large for phpmyadmin. I've found the below command:
mysqldump -uUSERNAME -p DATABASE > backup.sql

Can anyone advise how I choose the location of where the database will be downloaded to?

How to duplicate MYSQL database on CentOS VPS?

Hello, we have been trying to duplicate a MYSQL database on a CentOS VPS, sadly with no luck. We can't export it, as it is too big. Does anybody know how we would go about duplicating it? Thanks in advance!

xenforo.com