Geeklog Forums

I have a clean install of 1.4.1 is there a buit-in backup system? My admin control panel doesn't seem to have a link.

TIA

You should have "DB Backups (N/A)" in your admin menu. And there should be a green file cabinet drawer with "DB Backups" in the C&C area.

No It's not there. I assumed it was database.php and tried to access it by url and the page works ok but it's not on the menu. How do I manually add it to the menu?

I just logged into the demo site and it appears that this is the only thing missing from the admin menu. Must of been a glitch during install.

These are the conditions under which the menu item appears:

if(( $_CONF['allow_mysqldump'] == 1 ) AND ( $_DB_dbms == 'mysql' ) AND
SEC_inGroup( 'Root' ))

You're on MS SQL, right?

I think there's a plugin that does DB backups via PHP that you could look into. This should be it. I don't know if it works with 1.4.1 or MSSQL: 752

Yes I'm using MSSQL. I remember seeing a plugin called dbman that might do the job.

Thanks.

MS SQL backups are not supported from within Geeklog. I don't know too much about MS SQL but I've been told that there is no equivaleny of mysqldump and that if you're running MS SQL, you would have better ways to backup the database anyway. So that's why that menu entry is disabled.

bye, Dirk

I would suggest creating a scheduled job within Enterprise Manager/Management Studio to back up your files.

If you're using SQL Express 2k5, you can generate a backup SQL script similar to the following and run it through query analyzer:

BACKUP DATABASE [dbname] TO DISK =N'path/to/your/backup.bkp' WITH NOFORMAT, NOINIT, NAME=N'Full Backup' , SKIP, NOREWIND, NOUNLOAD, STATS=10