Big Dump

[lufbra]

Have any of you guys tried or use Big Dump (http://www.ozerov.de/bigdump.php), and if so, what is your opinion of it?

[Buzz]

I haven't tried it but I certainly will next time I need to move a large DB.

[degsy]

I use mySQL man. It is PERL based and doesn't have the size limitations of PHP.

[MishY]

If you have ssh access you can use mysqlhotcopy (http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html).

[dammit]

Read the title..... had to come and look..... *gone* :D

[lufbra]

Sorry for taking so long to reply here. :)

Buzz, I've read that many folks use this Big Dump thing.

Degsy, are you saying that the one you use doesn't "split up" the database like Big Dump does? I know the database I'm using isn't very large at all yet, but I've been hearing (through other forums I go to) that many folks have trouble transferring their databases simply because they are so large.

MishY, I just looked through the CPanel that my webhost gives us, but I see nothing about ssh, unless I'm not looking in the right place. But then again, looking at the page you linked, that'd be a sure fired way to give this here thicko a headache...LOL!!

[Buzz]

I've struggled many times to take a large DB file and break it into 2mb chunks for moving... it's a nightmare. I certainly would try Big Dump in any event. Worse case scenario is you trash the db and go back to a backup.

[lufbra]

How often do you do a database back up, and do you have a way of doing it automatically, or do you do it manually through your webhost's CP? As you know I have a forum set up, until uploading the latest version of the forum software, there was/is a modification available that would download the database through either my email account, or to the FTP site, I had it set for downloading every third day. Unfortunately that"mod" doesn't work with the latest forum software upgrade, and I haven't seen any sign of it (so far) as being upgraded. This doesn't mean to say it won't be upgraded, I was just wondering if there may be another way of doing this without having to keep upgrading a mod whenever the forum software gets upgraded.

[Buzz]

Depends upon the forum. Last time I used vBulletin I had an auto backup cron job nightly. I'd just go in (ftp) every couple weeks and remove all but the latest backup and download the latest to a local volume. You could write a custom cron job. If you search Google for "mySQL auto backup" there are several scripts out there that aren't tied to anything and will do autobackups for you.

[degsy]

Degsy, are you saying that the one you use doesn't "split up" the database like Big Dump does? I know the database I'm using isn't very large at all yet, but I've been hearing (through other forums I go to) that many folks have trouble transferring their databases simply because they are so large.

mySQLman doesn't have those problems. It seems to be a PHP limitation or setting that leads to the time-out.
It doesn't split up the files. It just downloads and accepts full .sql files.

I'm pretty sure you have mySQLman on your webspace Dave. It was on last time I logged in, albeit that was a while back.

[lufbra]

Darn it, I can't figure out what the url address would be, I now realize that it's in the cgi_bin directory, but I'm not getting to it when trying different addresses.

[degsy]

Look at the folders using FTP. If it there you will be able to see the correct path.

If not it's easy to upload it again.

[lufbra]

All the files are uploaded from previous, but I canna seem to get the right path to view it through my browser.

[degsy]

Depending on the folder structure it will be

http://www.daves-pub.com/cgi-bin/foldername/scriptname.cgi

[Buzz]

Here;s a nifty little script that might help too Dave.

Change the suffix from .txt to .php

Drop it in any folder then call it from a browser (htttp://yoursite.com/whereami.php).

it will show you the server path to the file.

[lufbra]

Thanks guys, Degsy figured out the address, but I'll keep that file Buzz, and I've downloaded a freeware cron job file that should download the database at given times. :)