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.
Backup with mySQL administrator
Moderator: General Moderators
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA
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.
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.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
If it's not FAT32 you may need to defragment the drive toobwv2 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.
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...
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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.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...
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 