MySQL Backup - How you do it? - GoFuckYourself.com

Pimpin_J · 12-29-2006, 02:16 AM

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?

Nookster · 12-29-2006, 02:18 AM

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.

tical · 12-29-2006, 02:22 AM

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

if u can get shell access use mysqldump

edgeprod · 12-29-2006, 02:30 AM

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*

DomP_nl · 12-29-2006, 03:33 AM

Mysqldumper is your friend

Adultnet · 12-29-2006, 03:36 AM

Quote:

Originally Posted by DomP_nl

Mysqldumper is your friend

yeah should do the work..

studiocritic · 12-29-2006, 03:43 AM

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

edgeprod · 12-29-2006, 03:45 AM

Quote:

Originally Posted by studiocritic

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.

12-29-2006, 02:16 AM	#1
Pimpin_J Confirmed User Join Date: Jul 2006 Location: SplitInfinity.com Posts: 3,637	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? __________________

12-29-2006, 02:18 AM	#2
Nookster Confirmed IT Professional Industry Role: Join Date: Nov 2005 Location: Hollywood, CA Posts: 3,744	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. __________________ The Best Affiliate Software, Ever.

12-29-2006, 02:22 AM	#3
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	phpmyadmin should have an export option, 300mb should be fine if u can get shell access use mysqldump __________________ 112.020.756

12-29-2006, 03:43 AM	#7
studiocritic Confirmed User Join Date: Jun 2005 Location: Irvine, CA Posts: 2,442	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 __________________ 254342256

12-29-2006, 02:30 AM	#4
edgeprod Permanently Gone Industry Role: Join Date: Mar 2004 Posts: 10,019	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

12-29-2006, 03:33 AM	#5
DomP_nl So Fucking What Industry Role: Join Date: Sep 2005 Location: 128579 Posts: 631	Mysqldumper is your friend