backing up mysql on local machine

Posts: 1129 · Posted: Sun Nov 07, 2004 1:37 am

yup its time once again, my monthly reinstall of CrapOS (aka winxp)
i've become quite the master at this execpt for making a backup of my mysql data. I can do this with some tools by manually doing each db but that takes days. It used to be that i could just copy the mysql folder to my removable drive and after reinstallof CrapOS i could just install mysql and then copy the folder from the removable drive right over the new install and walla but that doesnt work anymore.

anyone have any good tricks too do this?

Posts: 3 · Posted: Tue Nov 16, 2004 10:49 am

Couldn't you just export the database structure and data with phpMyADMIN and restore it later?

Posts: 1031 · Posted: Tue Nov 16, 2004 2:10 pm

mysqldump --all-databases > mybackupfile.sql

shouldn't that do it? Worded for me last week...

Posts: 1129 · Posted: Wed Nov 17, 2004 12:39 am

never seems to have actually worked right, errors out when redoing it
this time i just used a reg folder backup up program and backed up the whole folder to my external harddrive the when i reinstalled the sysyem i reinstalled a fresh copy of mysql the restored to backup over it and it was all there... for once

in the meantime i found a php program that will do it as well but i dont run that crap on my local machine

Posts: 1031 · Posted: Wed Nov 17, 2004 2:04 pm

I found this as well...

http://www.searchallsoft.com/mysql-backup.html

Posts: 1129 · Posted: Wed Nov 17, 2004 10:27 pm

good find, i had something similar but it was pretty expensive
did u download this?
doesnt dl 4 me

Posts: 1031 · Posted: Thu Nov 18, 2004 1:47 pm

I just tried... I can't get anything either.

HA!!! HAAAAAA HA HA!!!! You can download it here... I've verified that.

http://www.tucows.com/preview/346565.html

If you still can't get it for some reason let me know... I'll stick it up for you to download somewhere.

Posts: 1129 · Posted: Thu Nov 18, 2004 7:26 pm

lol yeah i did find it at 2 cows right after i posted that but thanks

gunna have to try it out here as its about the time of the month that i need to reinstall crapxp, just waiting on my new fresh package from macromedia to get here (hopefully today!)

Posts: 1031 · Posted: Thu Nov 18, 2004 8:48 pm

fresh package? getting something good?

Posts: 1129 · Posted: Thu Nov 18, 2004 8:52 pm

at the last coldfusion users group i won a fresh new in the box copy of Studio MX 2004 pro, i already have it but **** sure its good

Posts: 1031 · Posted: Thu Nov 18, 2004 9:10 pm

nice

Posts: 1129 · Posted: Thu Nov 18, 2004 9:14 pm

well i aint gunna complain about it thats 4 sure!