Dumping Mysql database using Putty/SSH ?

[pi0tr3k]

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.

LOLOLOLOLTROLLLLOLOL.
Webmaster, much?

I even dumb my 15GB database using putty, without any problems.

@OP: add --verbose in your command to see if it works.

mysql --verbose --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPFILE.SQL

Or, do

mysql --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPFILE.SQL &

Note the & at the end! Like this, you can now type

top

and see if mysqldump is working or not

Also, when I dump my 15GB database, it takes +2h on a shitty VPS.

Cheers & good luck.

[resoft11]

If you want to restore your db , using this command via Putty.

mysql -uforum_for43 -puser_password forum_forum42 < /home/forum/forum_forum427.sql

Dont use spaces. And depend on your vps/dedi specs, it could take very long time. Just wait until its done.

[bachbell]

i use this for import expot db 250m aprox and works fast


Export

mysqldump -u username -p database_name > dumpfile.sql


Import


mysql -u username -p database_name < dumpfile.sql

[WebMonster]

Thanks everyone . I ended up restoring a slightly older database it was half the size and dumped in seconds . 1 of my tables was 1.gb in size and it seems its corrupt even left over night i left it and it stopped after that table .

Im using a Dell 860 - Intel Xeon X3050 - 4GB MEM - 500GB HDD with centos 5 32 bit OS