My phpmyadmin doesn't work. I see only white blank page when I open it (it has some issue),

However, I'd like to export my project database manually to another computer.

I saw all my databases inside /var/lib/mysql and when i run

mysqldump -u username -p databasename > backup.sql

using mysqldump for backing-up, it freezes up and does nothing

Is there any another way by which I can export my database?

5

2 Answers

I have always used mysqldump -u username -p databasename > backup.sql with no issues.

2

Just add --no-tablespaces, It's working for me

mysqldump -u username --no-tablespaces -p databasename > backup.sql

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy