Posted on: 04/13/07 11:52am
By: maggs
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
Re: How to Backup
Posted on: 04/13/07 03:45pm
By: jmucchiello
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.
Re: How to Backup
Posted on: 04/13/07 04:21pm
By: maggs
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.
Re: How to Backup
Posted on: 04/13/07 04:27pm
By: jmucchiello
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:
Re: How to Backup
Posted on: 04/13/07 04:37pm
By: maggs
Yes I'm using MSSQL. I remember seeing a plugin called dbman that might do the job.
Thanks.
Re: How to Backup
Posted on: 04/15/07 04:01am
By: Dirk
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
Re: How to Backup
Posted on: 05/25/07 08:25am
By: randy
Quote by: maggsYes I'm using MSSQL. I remember seeing a plugin called dbman that might do the job.
Thanks.
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