Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 07:54 am EDT

Geeklog Forums

How to Backup


Status: offline

maggs

Forum User
Newbie
Registered: 04/11/07
Posts: 14
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
 Quote

Status: offline

jmucchiello

Forum User
Full Member
Registered: 08/29/05
Posts: 985
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.
 Quote

Status: offline

maggs

Forum User
Newbie
Registered: 04/11/07
Posts: 14
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.
 Quote

Status: offline

jmucchiello

Forum User
Full Member
Registered: 08/29/05
Posts: 985
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
 Quote

Status: offline

maggs

Forum User
Newbie
Registered: 04/11/07
Posts: 14
Yes I'm using MSSQL. I remember seeing a plugin called dbman that might do the job.

Thanks.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

randy

Forum User
Newbie
Registered: 01/18/03
Posts: 11
Quote by: maggs

Yes 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

 Quote

All times are EDT. The time is now 07:54 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content