MySQL Backup - How you do it?
 

Just tried it with PhpMyAdmin but it seems like the database is a way to big. 300mb++ So the browser times out. Aint got shell access, so is there any other remote tool who can handle this?

easiest way i've found if you have a large database is code your own. you can code one relatively quick with php + mysql commands. :2 cents:

phpmyadmin should have an export option, 300mb should be fine

if u can get shell access use mysqldump

That's VERY odd that it times out on 300MB. I exported a 2TB database onto a Webair server, and it was fine.

Lucky I did, too, because the farm (well, only 5 servers, so mini-cluster) at Candid Hosting shit the bed shortly thereafter. Cost me thousands and thousands in downtime and lost data for some of the other sites, but luckily, they gave me .. uh .. $130 back, I think. *grumble*

yeah should do the work..:)

if you have shell access, just do mysqldump -u[username] -p -D [databasename] > [databasename].sql

so like

mysqldump -uroot -p -D gfy > gfy.sql

then it'll ask for root's pass, enter it

it'll write a file called gfy.sql, that will include all the commands to recreate the db. gzip it up to make it smaller if u want

Stop, you're turning me on.