Backup DB by a user

Community Support Database
1

Is it possible to do this for an unprivileged user?
Opera Snapshot_2024-03-09_231904_hostom

2

No v-* command can only used by root or users with sudo permissions

3

And … mysqldump -u user -p password database > test.sql ???

4

mysqldump -u USERXX -pPASSXX BDXX > /home/USERDOMXX/web/DOMXX/public_html/testXX.sql

SOLUTION

5 
<?php
$fecha = date("Y-m-d_His");  
$nombre = "/home/xxxx/web/xxxxx.com/public_html/APIMP_BD_".$fecha.".sql";

system('mysqldump -u XXXXX -pXXXXX BDXXXX > /home/xxxx/xxx/'.$nombre);
system('zstd '.$nombre);
unlink($nombre);
?>

:wink:

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.