Export database to sql dump in php

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'test';
$mysqldump=exec('which mysqldump');


$command = "$mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname > $dbname.sql";

exec($command);
?>

Source: stackoverflow.com

Export database to sql dump in php

exec('C:\\wamp\\bin\\mysql\\mysql5.6.17\\bin\\mysqldump.exe -uroot DatabaseName> c:\\database_backup.sql');

Source: stackoverflow.com

Similar codes

11 votes160 views1 answer
Install php 8.1 fpm and all modules on ubuntu
PHP
0 vote290 views1 answer
Add top menu bar in wordpress
PHP Wordpress
0 vote225 views1 answer
Créer projet laravel
PHP Laravel
4 votes199 views1 answer
PHP artisan create model and seeder shortcut
PHP
5 votes238 views4 answers
Create database from migration laravel for all
PHP Laravel
0 vote182 views1 answer
Laravel search user details by specific role
PHP
1 vote193 views1 answer
File_get_contents timeout
PHP
1 vote253 views1 answer
Get year in laravel 8
PHP Laravel
2 votes207 views2 answers
Php pdo fetch from db
PHP
0 vote191 views1 answer
Php prepared statement and conditional
PHP