Dumping Mysql database using Putty/SSH ?

[WebMonster]

My question is when i dump the database using a command like so

mysql -u forum_for43 -p forum_forum42 < /home/forum/forum_forum427.sql;

I am prompted for the users pass so i put it in and then putty gives no response .

Now i know its dumping the DB because i have had to do it now a second time as the database was too big .

How long should it take for a database of 1.6gb take to dump ?

WebMonster Reviewed by WebMonster on 6th Oct 2011. Dumping Mysql database using Putty/SSH ? My question is when i dump the database using a command like so mysql -u forum_for43 -p forum_forum42 < /home/forum/forum_forum427.sql; I am prompted for the users pass so i put it in and then putty gives no response . Now i know its dumping the DB because i have had to do it now a second time as the database was too big . How long should it take for a database of 1.6gb take to dump ? Rating: 5

[Gavo]

It all depends on the speed of your server and current load and amount of entries

anything between 2-30 minutes.


Check my topic for a faster method.
http://www.besthostingforums.com/48-...s-vps-ded.html

[WebMonster]

Ok thank you Gavo . Seems it just stops when it gets to the biggest table .

[filegrasper]

you cant dump huge database using putty. I recommend you to use mysqldumper . Becoz i have a bad experience in dumping my 7gb database with putty . And finally got done by mysql dumper. U can hire me if u cant do.

[onel0ve]

Ok thank you Gavo . Seems it just stops when it gets to the biggest table .

maybe you exceed ram

[Sp32]

I think I remember one of my servers taking around an hour to do it via PuTTy.

Ignore filegrasper. PuTTy is definitely a better way to back up mysql databases. The reason being is that software such as bigdump and mysqldumper experience PHP time outs, unless you've edited your servers files so that PHP don't experience time out requests for x amount of time.

[filegrasper]

he is asking about dumping an database and he needs an solution nw. Try mysqldumper it is best.

[GoPantheoN]

I ll take time to dump. So after entering password wait till it responds.

I ll recommend you to take the dump gzipped so that it ll save you space using this

mysqldump -u yourUserName -p yourDBName | gzip >databasebackup.sql.gz

[onel0ve]

for backup and restore check this
https://www.vbulletin.com/docs/html/...nce_ssh_backup
https://www.vbulletin.com/docs/html/...ce_ssh_restore

[Whoo]

I also suggest you use Putty

mysqldump -u username -ppassword database_name > dump.sql

(Yes the -ppassword is written without a space!)