How Can I Export Mysql Database Manually - Without Phpmyadmin
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...
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?
2 Answers
I have always used mysqldump -u username -p databasename > backup.sql with no issues.
Just add --no-tablespaces, It's working for me
mysqldump -u username --no-tablespaces -p databasename > backup.sql
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
