Getting 0KB of size file while backup mysql database using mysql dump

Question

I am using below code to backup my database using php script but I am getting 0KB size file. How can I backup my full database with all routines and functions?

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname='mydatabase';
$toDay = date('d-m-Y');
//exec("mysqldump --user=$dbuser --password='$dbpass' --host=$dbhost --single-transaction $dbname > D:\Sql_Backups/".$toDay."_DB.sql");
//exec('mysqldump --user=$dbuser --password=$dbpass --host=$dbhost $dbname > D:\Sql_Backup/file.sql');
exec ("mysqldump --routines --h $dbhost --u $dbuser --p $dbpass --single-transaction $dbname  > D:\Sql_Backup/db_backup.sql");

how to create a backup database script in php and zip it How to backup MySQL database in PHP? Backup a mysql database and download as a file

Windows path must escape backslash ` \ ` to ` \\ ` if using double quotes. Besides that, what error do you get? What does echo exec(... print? Can you hit the command via command line from the same user? > does not pipe STDERR does it? Do you have log files? — Daniel W.
– Daniel W., Commented Feb 25, 2014 at 11:40
@DanFromGermany echo exec(..) did't print anything.And it not return any error.. — Surendra
– Surendra, Commented Feb 25, 2014 at 11:48

Salehin Rafi · Accepted Answer · 2014-12-08 04:44:02Z

1

There a few suggestion:
1. Compulsary to use absolute path for mysqldump.
2. Try using --opt (default option for mysqldump). Can refer http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
3.For the option, if use short form, no need to have (--). eg: --p. Use (--) when use full form. eg: --password. So use '-p' instead of '--p' (applied for others option too).
4. try 'shell_exec' or 'system' if mysqldump doesnt work on 'exec'.
5. try avoid have space between option and variable. Eg: -p$dbpass

answered Dec 8, 2014 at 4:44

Salehin Rafi

3512 gold badges6 silver badges16 bronze badges

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

2 Comments

Sumit patel Over a year ago

can you provide a example with your suggestion.

Salehin Rafi Over a year ago

@Sumitpatel this is the issues I encountered a long time ago in stackoverflow.com/q/26749853/4216992, for point 2 - 5 you can refer to link that I provided above.

Collectives™ on Stack Overflow

Getting 0KB of size file while backup mysql database using mysql dump

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related