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?
MySQL Backup - How you do it?
Collapse
X
-
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.
-
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*Comment
-
-
yeah should do the work..

TrafficCashGold Paying Webmasters Since 1996!
Awesome Conversions! Fast Weekly Payments! Over 125 Tours!Comment
-
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 want254342256Comment
-
Stop, you're turning me on.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 wantComment


Comment