Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

closed as too localized by Bruno Pereira Feb 24 '12 at 10:01

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
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
    
It freezes because its creating the sql file. Just wait until it finishes. – Rael Gugelmin Cunha Feb 10 at 10:38

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

share|improve this answer
1  
This can be done from $: /var/www – shasi kanth Aug 28 '13 at 4:49

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