CODEWITHSUNDEEP
phpmysqldatabasephpmyadminbackup
Howdy_McGee
Howdy_McGee

Reputation: 10645

Empty SQL Files - PHPmyAdmin

So I'm trying to export my e-commerce database via PhpMyAdmin and it keeps downloading empty SQL Files. I'm 100% sure i'm selecting all my tables and I'm using the default sets when opening the export tab. It keeps coming out to 0 bytes. If needed i'll detail all the checkboxes I have checked in php my admin but not sure if it's needed.

Is my database too big? What's another way I can back up my database?

Upvotes: 4

Views: 6075

Answers (5)

Christian
Christian

Reputation: 2194

Using mysqldump through ssh worked for me

Example

user: admin password: pass123 database name: mydatabase

mysqldump --add-drop-database --add-drop-table --user=admin --password=pass123 mydatabase > backup.sql

Then I downloaded the file via FTP

Upvotes: 1

Tom O' Mara
Tom O' Mara

Reputation: 267

I had the same issue as OP - the exported .sql backup was always empty. Selecting the gzipped compression did the trick - hope this helps somebody else!

Upvotes: 1

sedat sevgili
sedat sevgili

Reputation: 166

You can use mysqldump on your terminal.

Upvotes: 4

Eddy Freddy
Eddy Freddy

Reputation: 1816

Might be timeout or memory limit exceeded. Try mySQLDumper. Works fine for me.

Upvotes: 1

Ryan Kempt
Ryan Kempt

Reputation: 4209

This could be a memory issue, increase the memory_limit in your php.ini file to 512M temporarily (assuming it is currently much less), restart required services for this change to take affect, and I am willing to bet this will now work for you... don't forget to change your memory_limit back when you are done.

Upvotes: 0

Related Questions