03-07-2013 03:26 AM
I'm trying to backup a SAS Financial Management database. It is in MySQL partly and partly in SAS Base. Theres no problem with SAS Base DB backup, but how can i get to FM database in MySQL - to SAS Suppliend FM LIB - I have tried to get to it with MySQLAdministrator but all i can see is sassdm and sasop databses(schemas). In sassdm schema i see tables like sas_audit, sas_config etc. but there are no tables like SAS_CURRENCY or SAS_DIMENSION_TYPE whitch i want to backup. Does anyone know where can i find tables from SAS Supplied LIB and how to bacup data from them???
03-21-2013 11:12 AM
OK...solved it...the databases to backup are: sharedservices, sassdm, sasop
From CMD you can do it by: mysqldump.exe -u sqladmin -p [databsetobackup] > backupfile.sql