Having a Dump - Teh Forum

From:	-Daz-	10 Jan 2007 17:41
To:	ALL	1 of 8

31665.1

Hello children.

What's the best practice way of backing up a MySQL database regularly?

Matt, I'm looking at you!

All my love.
Darren.

Edit: Spelling Spacks

Edit 2: Why is it not showing edits? Does it have to be read first?

Did You Know?
In parts of central and eastern China it is considered impolite to kick a man in the nuts and shag his wife.

0/0

Reply Quote

More

From:	Manthorp	10 Jan 2007 17:48
To:	-Daz-	2 of 8

31665.2 In reply to 31665.1
I thought a short grace period was added a while ago - 5 mins or summat. Bush Says Cheney, Rumsfeld Will Stay: "Both Men Are Doing Fantastic Jobs"... Associated Press, 1 Nov 2006

0/0

Reply Quote

More

From:	Matt	10 Jan 2007 18:30
To:	-Daz-	3 of 8

31665.3 In reply to 31665.1

From the terminal / command prompt using the mysqldump program, which is provided with MySQL - In Windows you may need to add the \MySQL\bin\ directory to your %path% variable, and redirect the output to a file, i.e.:

code:

mysqldump -uusername -ppassword database > database_dump.sql

You can automate that from a cron job or Task Scheduler.

To import you can use the MySQL command line client:

code:

mysql -uusername -ppassword -Ddatabase < database_dump.sql

(Note the difference in commands when specifying the database to use)

I'm sure you could probably get all clever and append the date and time to the filename and even tar and gzip it or zip/rar if you wanted to.

doohicky

0/0

Reply Quote

More

From:	-Daz-	10 Jan 2007 18:52
To:	Matt	4 of 8

31665.4 In reply to 31665.3
Much obliged Matt. I knew dumping was involved somewhere. Did You Know? In parts of central and eastern China it is considered impolite to kick a man in the nuts and shag his wife.

0/0

Reply Quote

More

From:	Ben (BENLUMLEY)	11 Jan 2007 01:00
To:	-Daz-	5 of 8

31665.5 In reply to 31665.4

if you need to compress it and stick the date in, i have it on a crontab at work somewhere working like that. so shout.

SIGSIZESWITCHER

0/0

Reply Quote

More

From:	DSLPete (THE_TGG)	11 Jan 2007 08:25
To:	Matt	6 of 8

31665.6 In reply to 31665.3
may I be so bold as to recommend the --opt switch when doing the dump

0/0

Reply Quote

More

From:	Ben (BENLUMLEY)	11 Jan 2007 09:21
To:	DSLPete (THE_TGG)	7 of 8

31665.7 In reply to 31665.6

its the default though??

SIGSIZESWITCHER

0/0

Reply Quote

More

From:	Matt	11 Jan 2007 10:30
To:	DSLPete (THE_TGG)	8 of 8

31665.8 In reply to 31665.6
What he said ^

0/0

Reply Quote

More