Page 1 of 1

Backup with mySQL administrator

Posted: Sun Apr 09, 2006 12:49 pm
by bwv2
I need to backup my 10gB database to an external harddrive. I am using mySQL administrator as it works better than phpMyAdmin for exporting. However, after 4.194304 gB, it fails and says the device is full. I have 180 gB free on the device, so it's not full. I tried twice and it stopped at exactly the same byte count both times. Any ideas? Is there some upper limit I can change somewhere?

Thanks.

Posted: Sun Apr 09, 2006 12:51 pm
by Chris Corbyn
Sounds like you're using a FAT32 filesystem to me ;)

Use a different filesystem if you are... FAT32 has a max filesize of 4GB.

Posted: Sun Apr 09, 2006 12:51 pm
by d3ad1ysp0rk
Can't you just do a little drag+drop action (or CP if you're in linux)?

AFAIK, that's one of the beautiful parts of mysql.

Posted: Sun Apr 09, 2006 1:05 pm
by bwv2
Drag and drop, now there's an idea. Will I still be able to load the db if it's not exported correctly? Or is that only a mess if I try to load it onto a different server? On that note, I will be needing to send it to a new server in the next few weeks, so I will need a way of exporting it to where it can be loaded by someone else.

As for the FAT32 file system, I don't think I have it set up that way. I will certainly double check, but I do have several .csv files on that hard drive of 3-12gB each.

Thanks.

Posted: Sun Apr 09, 2006 2:07 pm
by Chris Corbyn
bwv2 wrote:Drag and drop, now there's an idea. Will I still be able to load the db if it's not exported correctly? Or is that only a mess if I try to load it onto a different server? On that note, I will be needing to send it to a new server in the next few weeks, so I will need a way of exporting it to where it can be loaded by someone else.

As for the FAT32 file system, I don't think I have it set up that way. I will certainly double check, but I do have several .csv files on that hard drive of 3-12gB each.

Thanks.
If it's not FAT32 you may need to defragment the drive too :)

Posted: Sun Apr 09, 2006 2:44 pm
by bwv2
Well crap. Looks like it is FAT32. Those other big files are on a different HD, this one only has sub-2gB files. So I need to repartition. Correct me if I'm wrong, but repartitioning my HD will require me to backup my files and delete the whole thing, right? Or does repartitioning keep the files intact? What a drag...

Posted: Sun Apr 09, 2006 2:47 pm
by feyd
Changing file storage types will destroy all the data normally.

Posted: Sun Apr 09, 2006 4:52 pm
by Chris Corbyn
bwv2 wrote:Well crap. Looks like it is FAT32. Those other big files are on a different HD, this one only has sub-2gB files. So I need to repartition. Correct me if I'm wrong, but repartitioning my HD will require me to backup my files and delete the whole thing, right? Or does repartitioning keep the files intact? What a drag...
Do you use Linux or windows. In Linux the Freeware GNU/Parted can convert filesystems without data loss, in Windows you'd pay for something like Partition Magic to do it.

Posted: Sun Apr 09, 2006 6:18 pm
by bwv2
I'm on Windows. I should back up this data on DVDs anyway, so I've begun that. It's only 60 gigs or so, so it's not that big a deal. I'll .rar everything and burn it, then reload it later. What else would I do on a beautiful Sunday afternoon in the mountains? I should close the window so I can't see the park across the street :cry: