Originally Posted by studiocritic

if you have shell access, just do mysqldump -u[username] -p -D [databasename] > [databasename].sql

so like

mysqldump -uroot -p -D gfy > gfy.sql

then it'll ask for root's pass, enter it

it'll write a file called gfy.sql, that will include all the commands to recreate the db. gzip it up to make it smaller if u want