How can I use PHP to backup MySQL Database under Windows xampp?

Question

Good evening, I am currently working on a mysql backup system but I can't get it to run.

My current code:

exec ("C:\xampp\mysql\bin\mysqldump.exe --routines -h $db_server -u $db_user -p $db_pass --single-transaction $db_name > C:\xampp\htdocs\test.sql");

I read the documentation on mysqldump and tried several ways, for example the above and also:

exec ("mysqldump --routines -h $db_server -u $db_user -p $db_pass --single-transaction $db_name > C:\xampp\htdocs\test.sql");

What am I doing wrong? Thanks in advance!

1) You are injecting raw input into shell 2) You aren't making any attempt to find out if the command executes successfully or to retrieve error messages if any — Álvaro González
– Álvaro González, Commented Feb 27, 2017 at 16:49

Community · Accepted Answer · 2017-05-23 11:46:15Z

0

I don't know what you mean by cannot run. It is it dump empty file or nothing at all happen. So I will write regarding on what I have understood. I also encounter same issues years back. Read here.

$filename = test.sql   

$command = sprintf("C:\xampp\mysql\bin\mysqldump.exe --opt -h%s -u%s -p%s %s > C:\xampp\htdocs\%s",

$db_server,
$db_user,
$db_pass,
$db_name,
$filename
);
system($command);

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Feb 28, 2017 at 4:52

Salehin Rafi

3512 gold badges6 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:31:59Z

-1

try this script http://www.lecoindunet.com/sauvegarder-bdd-mysql-mysqldump-php-27

or this

Using a .php file to generate a MySQL dump

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Feb 27, 2017 at 16:27

mohamed jebri

2713 silver badges13 bronze badges

Collectives™ on Stack Overflow

How can I use PHP to backup MySQL Database under Windows xampp?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related