mysql download

[jon123]

is there a way to download/backup all the databases on a domain in one go? Maybe using WHM?

Also any tutorials on copying a site on another server over to this one, or just mysql would be handy. Both use cpanel btw

thx
jon

[Pumazooma]

There's a good little script called bigdump for restoring db backups bigger than 2Mb.

[jon123]

Originally Posted by Pumazooma

There's a good little script called bigdump for restoring db backups bigger than 2Mb.

yes i have used that before but I need a script for downloading the dbs not restoring.
thx anyway

[kev woodman]

Have you got command line access to MySql?

[jon123]

Originally Posted by kev woodman

Have you got command line access to MySql?

Hi Kev, I have no idea! I have a vps and seem to have control of most things, unfortunately my knowledge of telnet, root access, linux, and pretty much everything else that doesn't have a gui is very very limited.

[Administrator]

Hello Jon,

You have a cpanel VPS and you have options to make package of full account using SSH as well as cpanel control panel.

If you configure daily / weekly backup of your accounts from WHM on a specific location inside your VPS then you can use those backup files as they will include .sql dump of all your databases.

Best option is to download .sql dump of each database from cpanel - backup section.

[kev woodman]

Does the cpanel dump work even with large dbs? I know from painful experience that phpMyAdmin tends to time out and choke on anything substantial.

[Administrator]

Originally Posted by kev woodman

Does the cpanel dump work even with large dbs? I know from painful experience that phpMyAdmin tends to time out and choke on anything substantial.

Large DB's should be limited upto 1 GB - 2GB. cPanel on 32 bit Linux OS can never deal with files bigger than 2 GB. I will never think of making a dump of database over 2 GB. best option is to copy the database as it is from one server to other server using rsync.

If you restore a database of over 1 GB size on any Linux Server using mysql restore feature then there are many chances of that restore failing. Restore is initially done in RAM of the server and then put in its appropriate location. If your VPS / Server has limited Memory then the restore wont succeed.

Its worth to learn use of Rsync if you have some love for Linux. Life becomes quite easy with Rsync. Some of our customers who have databases over 2 GB in size make multiple partial dumps of their databases and then we go on restoring each of those dumps to make a one whole big database.

You get many options if you open doors for Linux

[jon123]

Originally Posted by Administrator

Hello Jon,

You have a cpanel VPS and you have options to make package of full account using SSH as well as cpanel control panel.

If you configure daily / weekly backup of your accounts from WHM on a specific location inside your VPS then you can use those backup files as they will include .sql dump of all your databases.

Best option is to download .sql dump of each database from cpanel - backup section.

Many thanks, I will look into that now and get back to you if i get stuck

[Administrator]

Originally Posted by jon123

Many thanks, I will look into that now and get back to you if i get stuck

Cheers !

[kev woodman]

Interesting stuff Admin - cheers. Let us know how you get on Jon.

[jon123]

Well I used cpanel backup which did download the .sql files but also the whole of the site. I chose a small site to test it on which also had one db.
The problem is that it was a 20Meg download and much of which I don't need or want.

What I am trying to achieve is to backup all the dbs within my package on a regular basis. Sinse most sites use either html/php/pl pages I don't see the need to back them up as I / they already will have a local copy. What I assume they won't have is a recent backup of their dbs, I know i keep forgetting to backup.

I have seen whm has the backup but again it refers to the whole lot, which not only will use a large amount of space, but also not give me what I need. Last time I tried it I think it was on the 4 gig mark.

I just thought there would be an easy way to back up just mysql, especially as a db is always changing as that's its nature,and everything else remains fairly static.
Even if I backed up everything every month I would still like the option to backup mysql once a week or so.

Any thoughts? Do I have the wrong idea about backups?

[Administrator]

there was no option called "Download a MySQL Database Backup" ?

Every cpanel control panel has that option. please check once again.

[jon123]

Originally Posted by Administrator

there was no option called "Download a MySQL Database Backup" ?

Every cpanel control panel has that option. please check once again.

Sorry I will explain better.
yes there is an option in cpanel to backup databases but I can't use that option as it would mean i would need to access peoples accounts to do so. Yes this option would be fine if all the hosting accounts were mine but they are not.

Is there no other option in whm? I know you mentioned SSH, doies this only offer full backup?

[Administrator]

Originally Posted by jon123

Sorry I will explain better.
yes there is an option in cpanel to backup databases but I can't use that option as it would mean i would need to access peoples accounts to do so. Yes this option would be fine if all the hosting accounts were mine but they are not.

Is there no other option in whm? I know you mentioned SSH, doies this only offer full backup?

Not sure if you have tried it so far but here's how you login in cpanel of your customers accounts from your WHM without using customers login details.