Mysqldump database backup through PHP

Asked Jun 22 '21 at 09:49

Active Jun 22 '21 at 11:07

Viewed 22 times

I am facing an issue when we are run a PHP script. Here, the file generated but the data did not get into the data file.

<?php
// Database configuration
define("DB_HOST", "localhost");
define("DB_USERNAME", "root");
define("DB_PASSWORD","");
define("DB_NAME", "val");

// Get connection object and set the charset
$conn = mysqli_connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME) ;
               
exec(" C:/xampp/mysql/bin > mysqldump --user=root --password= --host=localhost new_trcker > M:/db_valad/valadpk1_kima578_backup.sql");

echo 'exported';

here, only generate valadpk1_kima578_backup.sql file into folder location but not get all table and data that files.

How to resolve this issue?

edited Jun 22 '21 at 11:07

Dharman

30,962
25
85
135

asked Jun 22 '21 at 09:49

Sagar

1

"`C:/xampp/mysql/bin > mysqldump`" -- Should this be `C:/xampp/mysql/bin/mysqldump`? – sticky bit Jun 22 '21 at 09:52
@stickybit not working. just generate file but inside not getting any database table and data. – Sagar Jun 22 '21 at 10:02
Your question has nothing to do with mysqli – Dharman Jun 22 '21 at 11:09
I suggest you the the output and fi the error that gives you :), pass a 2nd param to the exec() method and echo that after – Martijn Jun 22 '21 at 11:10

Mysqldump database backup through PHP

0 Answers0