PHPmyadmin

[jagged]

OK, another newbie question

I've got a VPS with Plesk 8 installed. I'm struggling a bit with this as I had webmin before and Plesk seems to be very limited in its functions (or they are well hidden away!). I want to reinstate a forum database from my old site but can't see any way of launching PHPmyadmin. Does anyone know if this is installed by default or do I have to add this myself? If so how do I integrate this into Plesk? Finally any tips on getting the 90+mb SQL file back up without data loss and whats the best way to back this up in future?

Thanks in advance,
Jagged

[Vin DSL]

...any tips on getting the 90+mb SQL file back up without data loss and whats the best way to back this up in future?

I don't know from 'Adam' about VPS on JagPC these days. I was involved in the beta test, but that's about it...

However, I'm probably one of the few ppl that run their own install of phpMyAdmin on shared servers -- and that's a shame!

All I can tell you is, phpMyAdmin is a piece of cake to install and maintain yourself! I don't know what everyones' aversion to this is...

If I was you, I would install phpMyAdmin in my own web space and forget Plesk!

[AlexKall]

I would advice to upload it with ftp and through SSH "install" it into the db

[jagged]

However, I'm probably one of the few ppl that run their own install of phpMyAdmin on shared servers -- and that's a shame!

Any idea why that is? I only used PHPmyadmin because it was built into my old Hsphere account. I used Eskuel on a daily basis but don't really know of any other alternatives?

If I was you, I would install phpMyAdmin in my own web space and forget Plesk!

The thing is I was hoping to make it available from the control panel for all accounts on the VPS.

I would advice to upload it with ftp and through SSH "install" it into the db

Do you know the URL of a place that shows how to do this? Also is there a similar way to do a backup, missing out PHPmyadmin altogether?

Regards
Jagged

[AlexKall]

Heres some info on it: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

[jagged]

Well it turns out phpMyAdmin was installed already, I just didn't see it because IE was silently blocking the pop-up

Of course it is neither use nor ornament when it comes to reinstating the 90+mb SQL file I have but with the pointers I've been given I think I know how to do this now. Now I just have to find a way to automate backups of the database (come back webmin all is forgiven!).

Thanks again
Jagged

[Vin DSL]

Er... Duh... will my brain surgery hurt

[jagged]

I blame it on the lack of sleep from moving 4 websites in 3 days

Cheers
Jagged

[AlexKall]

Well it turns out phpMyAdmin was installed already, I just didn't see it because IE was silently blocking the pop-up

Of course it is neither use nor ornament when it comes to reinstating the 90+mb SQL file I have but with the pointers I've been given I think I know how to do this now. Now I just have to find a way to automate backups of the database (come back webmin all is forgiven!).

Thanks again
Jagged

can do a mysqldump call with cron, to edit cron jobs by typing "crontab -e" with putty or such.

looks like this
* * * * * dosomething
first * is minutes second is hours, third is day of month, 4th is month, 5th day(s) of week

more info can be found here: http://www.adminschoice.com/docs/crontab.htm

[jagged]

Thanks, that will save me hours of searching

Cheers
Jagged