Database and FTP Security addons

[pengrus]

I was browsing yesterday and saw a thread that leads to some great addons such as Google Maps, Database Management, and FTP Security addons. I was going to install them today, but could not find them again after many searches.

Could someone please give me a pointer on where to look for these addons? I believe they all work with 1.6.

[Dennis]

ow sure... just look at my sig :p

Please contact me if you need help, especially the FTP_security addon is a bit tricky to setup. Easiest way to get the path is by logging in with a ftpclient and write down the paths you need to open to get to your pixelpost root index.php file.

[pengrus]

Great. Thanks a lot!

The FTP Permission looks like work wonders. I do have a question on DB management:

On the Backup Tab, it says:

Please create a backup folder (e.g. 'backup-db') in 'pixelpost' folder

And on Options Tab, it says:

"backup-db" will point to the "backup-db" folder in "admin").

So I don't know where to create that "backup-db" folder, under /pixelpost/ or under /pixelpost/admin/?

Many thanks for your help.

[Dennis]

Ok great catch! You see that message because the backup folder was not defined yet in the database.

The backup folder should be located in the "admin" folder. (e.g. /pixelpost/admin/backup-db)

[pengrus]

Thank you. I created that folder under /admin/, and was about to try the first backup, but this sentence stopped me:

Database Backup Type: Full (Structure and Data): Database will be dropped!

Why does it say the "Database will be dropped!"?

[Dennis]

Basically this means a DROP statement is executed prior to restoring the database.

This will effectively rebuild your whole database. Perhaps I should change that to: Database will be dropped prior to restoring this backup.

[pengrus]

This is on the BACKUP page, nothing mentioned about restoring... And the button also says "Backkup".

[dakwegmo]

I think that's why he's saying he should change the text. When you create a full backup, a SQL drop statement is included in the backup file. When you restore from this backup file, the drop statement will be executed. The warning currently isn't very clear, but essentially says be careful what you do with this file.

[Dennis]

^^^ what the smart guy above says.