We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Full DB Backup
Full DB Backup
Hello,
How I can create the full db backup?
Our db is around 3GB. If we use the inbuilt vestacp backup, it will be done every night, but the backup files size is around 70MB only.
I mean this cron: sudo /usr/local/vesta/bin/v-backup-users
I need the full backup, that can be used on each other server to restore all user data including full web and full db server.
Please help.
How I can create the full db backup?
Our db is around 3GB. If we use the inbuilt vestacp backup, it will be done every night, but the backup files size is around 70MB only.
I mean this cron: sudo /usr/local/vesta/bin/v-backup-users
I need the full backup, that can be used on each other server to restore all user data including full web and full db server.
Please help.
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Full DB Backup
You can use mysqldump: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.htmlsurus wrote: ↑Sat Apr 21, 2018 6:20 amHello,
How I can create the full db backup?
Our db is around 3GB. If we use the inbuilt vestacp backup, it will be done every night, but the backup files size is around 70MB only.
I mean this cron: sudo /usr/local/vesta/bin/v-backup-users
I need the full backup, that can be used on each other server to restore all user data including full web and full db server.
Please help.
Code: Select all
Simple backup:
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
Schema only
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql
Specufy tables
mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > /path/to/file/dump_table.sql
Gzipped backup
mysqldump -u USER -pPASSWORD DATABASE | gzip > /path/to/outputfile.sql.gz
Backup filename with current datetime
mysqldump -u USER -pPASSWORD DATABASE | gzip > `date +/path/to/outputfile.sql.%Y%m%d.%H%M%S.gz`