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?

  • I just wanted to say use mysqldump
    – Marcel
    May 19 '11 at 11:05
  • 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 '11 at 7:53
  • This question is better suited for stackoverflow.com
    – Hailwood
    Feb 24 '12 at 6:49
  • 2
    It freezes because its creating the sql file. Just wait until it finishes. Feb 10 '16 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 '20 at 18:07

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

  • 1
    This can be done from $: /var/www Aug 28 '13 at 4:49
  • No password for the db user? Aug 3 '17 at 7:52

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

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

  • 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? Dec 16 '21 at 8:43
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    Dec 16 '21 at 8:44

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.