PDA

View Full Version : i cant Backup my Database ? (400mb)


maxicep
24 Nov 2006, 15:58
hi ,
my database big and phpmyadmin and vb. backups burst uponing my database for my post table.
post table is 200mb. how can i backup my database to ftp and my pc as Gzip'ped ?:surprised:

jason|xoxide
24 Nov 2006, 17:50
Do you have ssh access to your server? If so, use 'mysqldump' to get the data and 'gzip' to compress. You can then move the file into a web or ftp accessible directory and download it to your local computer.

da420
24 Nov 2006, 17:54
phpmyadmin is not very good at database backups. I use SSH and the only problems I have is when I mis-type something. :)

Ramsesx
24 Nov 2006, 17:57
I use mysqldumper (http://www.mysqldumper.de/en/), free and very easy, you don't need ssh access.

AMD_Warrior
26 Nov 2006, 11:18
Wow thats alot of mysql i hired a management company to do backups for me its much better

Luky
19 Dec 2006, 14:16
lol you act like having a databas 10 times mine is a bad thing?