Forum database back up with Plesk

tennis4you

Trekkie

Offline

Posts: 13

Forum database back up with Plesk

« on: May 09, 2008, 05:20:26 PM »

I would like to back up or save my forum's database. I was previously on a regular account and that was very easy through the CPanel. I am on a VPS now which requires me to use Plesk. I have no clue how to use Plesk, it looks very foreign to me. I have asked around and no one i know who is good with pcs (IT people included) have ever heard of Plesk.

So...

Can any one here tell me how to make a back up of the SMF forum? I thought a while back someone told me I could set Plesk to make nightly back ups? I would also like to save the SMF forum database to my hard drive here too.

Any way to do those actions?

Thanks!!!


	Logged

perestrelka

Administrator
Jedi

Offline

Posts: 980

Re: Forum database back up with Plesk

« Reply #1 on: May 09, 2008, 10:08:52 PM »

Hi Tennis4you,

If the forums databases is not so big (approximately, below 70 megs), as in cPanel, you can use phpMyAdmin to get a backup. To access phpMyAdmin, click on the databases shortcut on the domain's panel, then select the database you need to backup and then click DB WebAdmin.

If the database is rather big, it is better to use shell utilities to backup it due to VPS having the memory restricted. This would be mysqldump command executed as root via ssh connection.


	Logged

Kind Regards,
Vlad Artamonov

tennis4you

Trekkie

Offline

Posts: 13

Re: Forum database back up with Plesk

« Reply #2 on: May 11, 2008, 03:39:33 PM »

I knew the CP pretty well in the previous hosting situation you had me in but this Plesk is beyond me. My Brother-in-law who is an IT guy couldn't figure out how to dl the forum db either. He tried the SSH through Plesk but it would not connect, whatever that means.

I have zero clue what I am doing. The forum will be over 70 megs which probably makes this harder for me, but I need to learn to back this forum up so I can have the db stored on my pc as well.

Is there any kind of step by step for dummies? I am way lost.

Thanks!


	Logged

perestrelka

Administrator
Jedi

Offline

Posts: 980

Re: Forum database back up with Plesk

« Reply #3 on: May 13, 2008, 07:15:56 AM »

Hi,

I'll try to explain you the steps you need to do to get the db backed up in shell and ready for download.

1. Ssh to the server as root using these instructions:

http://www.lunarforums.com/lunarpages_dedicated_web_hosting/how_to_login_to_your_dedicated_server_via_ssh-t26372.0.html

2. Run

mysqldump -u admin -p`cat /etc/psa/.psa.shadow` [db_name] | gzip > /var/www/vhosts/[domain_name]/httpdocs/[db_name].sql.gz

(replace [db_name] and [domain_name] with actual names)

3. Download the file by opening http://[domain_name]/[db_name].sql.gz in browser. You should be able to open it in any archivator supporting ZIP archives on your PC in case it is needed.

Please advise, if something is still unclear for you.


	Logged

Kind Regards,
Vlad Artamonov

tennis4you

Trekkie

Offline

Posts: 13

Re: Forum database back up with Plesk

« Reply #4 on: May 16, 2008, 05:28:46 PM »

Seems clear enough. I have never messed with SSH stuff before. Man o man was CPanel so much easier.

I will give it a shot, I am sure I will be back with questions...


	Logged

perestrelka

Administrator
Jedi

Offline

Posts: 980

Re: Forum database back up with Plesk

« Reply #5 on: May 16, 2008, 08:58:47 PM »

Sounds good. BTW, you would use the same way to backup large DB in cPanel as well so no difference here.


	Logged

Kind Regards,
Vlad Artamonov

Pages: [1] Go Up

« previous next »

	Welcome, Guest. Please login or register. Did you miss your activation email?	July 25, 2008, 11:26:16 PM
		Login with username, password and session length