Backup with mySQL administrator

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Backup with mySQL administrator

Post 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.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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.
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post 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.
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Post 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.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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 :)
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Post 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...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Changing file storage types will destroy all the data normally.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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.
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Post 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:
Post Reply