Mysqldump is not working in laravel production server

Question

I'm trying to take a backup of my database using mysqldump. When I use php artisan serve command it works perfectly on my local machine. but when I access it through URL is generates an empty file.

public function getBackup()
    {
        $dbhost = env('DB_HOST');
        $dbuser = env('DB_USERNAME');
        $dbpass = env('DB_PASSWORD');
        $dbname = env('DB_DATABASE');

        $dbfilename = 'easytrax_db_' . date("Y_m_d_his") . '.sql.gz';
        $backupfile = base_path("db") . '/' . $dbfilename;

        exec("mysqldump --max_allowed_packet=4000M --skip-lock-tables -h$dbhost -u$dbuser -p$dbpass $dbname | gzip > $backupfile");

        return response()->download(base_path("db/{$dbfilename}"));
    }

currently using wamp. mysql version: 8.0.21 php version: 7.2.33

check this post: https://stackoverflow.com/questions/749803/empty-files-generated-from-running-mysqldump-using-php — Giacomo M, Mar 04 '21 at 10:35

score 0 · Answer 1 · answered Mar 04 '21 at 12:46

0

Check your script step by step where this goes wrong:

Do you have write permissions on the filesystem?
Does the database login work?
Is the dump created at all?
Is the file path correct?
Is the gzipping working? What if you skip it for now?
Is a proper download link generated for the file?
Are the env variables populated as they should be?

answered Mar 04 '21 at 12:46

PtrTon

3,705
2
14
24

[This post](https://stackoverflow.com/questions/57309869/how-to-generate-a-table-backup-programatically-with-laravel/57310013#57310013) I wrote a while back might also give you some inspiration on the topic – PtrTon Mar 04 '21 at 12:48

Mysqldump is not working in laravel production server

1 Answers1