How can I export MySQL database manually - without phpmyadmin

Question

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?

Achu, have you tried looking at mysql -u username -p -e 'show processlist' ? It may offer a clue as to what mysqldump is waiting for. Could be a table lock. — SpamapS, Oct 31, 2011 at 7:53
It freezes because its creating the sql file. Just wait until it finishes. — Rael Gugelmin Cunha, Feb 10, 2016 at 10:38
"using mysqldump for backing-up, it freezes up and does nothing" Open a 2nd terminal. cd to the dir you started the command and do ls -l Yoiu will see the file and it will be growing. ALSO: make sure you do this in a dir you own. Not in /var/lib/ — Rinzwind, Jun 8, 2020 at 18:07

matre · Accepted Answer · 2011-05-19 11:10:48Z

22

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

answered May 19, 2011 at 11:10

matre

3311 silver badge2 bronze badges

Add a comment |

Kesavan M · Accepted Answer · 2021-12-16 06:43:37Z

0

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

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

answered Dec 16, 2021 at 6:43

Kesavan M

1

From the manual : --no-tablespaces, -y This option suppresses all CREATE LOGFILE GROUP and CREATE TABLESPACE statements in the output of mysqldump. Why would this option prevent freeezing?
– Marc Vanhoomissen
Dec 16, 2021 at 8:43

Add a comment |

2 Answers 2