Problem with backing up my databases

[WildWayz]

Hi ya all

I am trying to back up my databases (I have root access) using

mysql -u clan-sites -p clan_sites_vbulletin > cs_vb.sql
enter my password

then it hangs there.

The database is small so it isn't as tho it is going through a lot of data.

I tried PHPMyAdmin and when I try to send the database so I can download it, it opens it up in the browser instead.

Any ideas?

--James

[werehere]

So it does not finish in telnet? What do you mean by hangs there, it never comes back to a prompt?

[WildWayz]

hi ya

Yes, it just hangs there like this


hyperblade:~$ mysql -u clan-sites -p clan_sites_vbulletin > cs_vb.sql
Enter password:
<blinking cursor>


--James

[Mitrofan]

It doesn't just hang there, It wait for your password. Are you trying to just login to mySQL or dump the data?

[WildWayz]

Hi ya

it *does* just hang there :)

I typed my password in, and it didn't do anything.

What I was trying to do, was dump the data - but there is a better way of doing it now :)

--James

[Chris Schreiber]

From the command line I use:

mysqldump -uuser -p --quick --add-drop-table --add-locks --extended-insert --lock-tables database > database.sql

This should work.