Best way to back up a mySQLdatabase?

**Tea_J** · 05-22-2003, 09:01 AM

Hi guys

How do you guys go about backing up you mysql databases? How do you guys do it in PHP?

Also, my habit is to just simply copy the folder where my database resides (MYSQL>DATA) .. is this ok? reliable and safe??

PLease share some thoughts... thanks

**micmac** · 05-22-2003, 10:06 AM

Hi there,
I personally use mysqldump to backup my mysql databases. I have a cron job set to execute every day at 2:00 AM. You could even execute a script that emails the dump file to yourself.

Cheers,
micmac

**Tea_J** · 05-22-2003, 10:13 AM

hmm.. sounds a good idea. is there a way to do that in php?

**Tea_J** · 05-23-2003, 07:44 AM

well?

**Musicman** · 05-23-2003, 07:58 AM

Hi,

I believe phpmyadmin can also dump a database - so why not copy the scripts from phpmyadmin?

Musicman

**Tea_J** · 05-24-2003, 10:53 AM

isnt there a function for this?

**Nostalgica** · 05-26-2003, 07:43 AM

i'd say go look @ phpmyadmin and see how he's doin it ..

**Tea_J** · 05-26-2003, 10:28 AM

yeah.. i might as well.. tnx fellas :P

**garfieldx** · 06-03-2003, 04:31 PM

Would appreciate if you could post some ideas if you were successfully in finding a cool function for a simple mysql backup.
Thx, Garfield

**Tea_J** · 06-04-2003, 08:44 AM

Hi garfieldx

umm... well, i tried to study how PHPmyADMIN did it, but i never was good at reading someone else's codes.. so, it just made me very confused, and gave me a head ache... so what i did was, i'm just using a simple php function cleverly named "copy()"

I simply have my app copy the databases and tables in the mysql/data/* folder into another location.. it seems to work pretty well.. i've had talks with people from MIRC and they said it was ok as long as noone wuz writting to one of the tables.. or else the data would be messed up.. so locking the tables and then copying the files is my trick..

Anyone got something to comment agaisnt this/?

**garfieldx** · 06-04-2003, 02:51 PM

Good idea. Thanx for posting your idea.
Garfield

**Nostalgica** · 06-05-2003, 03:10 AM

This file contains a backup.php file i found in a Webshop..
i think it can be usefull .. it has more features.. backups it in a file that can be compressed.. and also has a restore function..

**Tea_J** · 06-09-2003, 02:01 AM

Thanks garfieldx...

and Nostalgica, thanks for the script.,. will review it soon..

tae

Thread: Best way to back up a mySQLdatabase?

Thread Tools

Display

Best way to back up a mySQLdatabase?

@ Tea_J

Posting Permissions