Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 10:19 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
PostPosted: Thu Feb 18, 2010 4:48 am 
Offline
Newbie

Joined: Fri Oct 23, 2009 3:08 am
Posts: 13
My OS server's motherboard has died. I have a new server with in ESX3.5, running ubuntu x64 8.04, I want to know how I can transfer my old openaudit database from the old file system to the new file system and have it work. I have the server setup with the same mysql version and the same username and passwords. Does anyone have any luck with this type of a transfer?

I have a backup but it is 2 weeks old and is missing much work that i am my boss have entered in to the software registry.

Thanks for all of your help.

_________________
OA Server: Ubuntu 8.04 LAMP
Auditing: 400+ Wrkstns, 20+ Srvrs.
OS's: Windows XP , W2K3 Srvrs, W2k8 Srvr, Win7, Red Hat, and a MAC.
LDAP: 2 AD Domians, no trust.
I have scheduled audits running from the DCs.


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 18, 2010 6:10 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
You should be able to copy the flat files from the old hard disk to the new one

The MySql web site gives more details, but I did do this at one stage and as far as I remember it was quite easy.

From memory, what I did was this, first I found the openaudit database files on the old PC, and copied them to ny Desktop folder on the new PC. I then installed openaudit to the new PC. This set up a new openaudit database. I then stopped MySQL and moved the new openaudit database to a backup folder, and copied the original database in place of the new one, and restarted MySQL.

All of this assumes that the versions of OpenAudit and MySQL are the same.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 18, 2010 8:36 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
By the way, the mysql databases in Ubuntu 9.10 are under /var/lib/mysql and I would think they are probably in the same place in 8.x

If you want to manipulate these flat files directly, you must stop MySQL first, otherwise you will probably break something. BACK EVERYTHING UP FIRST.

To stop mysql try

sudo /etc/init.d/mysql stop

and to start it,

sudo /etc/init.d/mysql start

Hope this all helps.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 18, 2010 11:08 am 
Offline
Newbie

Joined: Fri Oct 23, 2009 3:08 am
Posts: 13
I have been unlucky with copying the files over. It seems that I have to boot up a machine with this hdd installed to access the files. Then I can mount a share to the new server and copy the files, but if I choose to retain the parms, it will fail with access denied. If i do not retain the parms it will copy and than not work. i get many permissions errors and sql errors.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/openauditwww/include.php on line 128
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/openauditwww/include_functions.php on line 166
An update has been found. Click here to upgrade!
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/openauditwww/include_functions.php on line 166
Upgrading to 06.08.30.Query failed: ALTER TABLE `system` CHANGE `system_country_code` `system_country_code` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
Can't find file: './openaudit/system.frm' (errno: 13)

Do you have any suggestions on the best way to copy these files over retaining the parms for sql?

Sorry, I use linux but I am not an advanced user yet. I will start poking around in the ubuntu and mysql forums for help as well.

Thanks for your help thus far. I have always received good support on this forum. Thank you.

_________________
OA Server: Ubuntu 8.04 LAMP
Auditing: 400+ Wrkstns, 20+ Srvrs.
OS's: Windows XP , W2K3 Srvrs, W2k8 Srvr, Win7, Red Hat, and a MAC.
LDAP: 2 AD Domians, no trust.
I have scheduled audits running from the DCs.


Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 19, 2010 12:12 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Linux permissions are set per user, so the most likely issue is that the user ID on the old disk doesn't match up with the user ID on the new disk.

You can work round this, by taking a note of the permissions and matching them up.

If you created a fresh copy of OA on the new server as I suggested in previous post, and kept that copy, you can look in the folder and check the permissions on the files, using sudo ls -l
In my /var/lib/mysql folder, I see

drwx------ 2 mysql mysql 12288 2009-12-24 12:56 openaudit

This means that the folder is owned by a user called mysql, and belongs to a group called mysql, it is a directory, and the user mysql has read, write and execute permissions.

if we then copy the data from the old server, we may see something like

drwx------ 2 401 607 12288 2009-12-24 12:56 openaudit

This indicates the folder is owned by the user with userid 401 (which doesn't exist) and group with group id 607 (which also doesn't exist)

To fis this you need to do something like

sudo chown --recursive mysql openaudit
sudo chgrp --recursive mysql openaudit

This will set the ownership and group correctly for the newly copied files.

Once this is done sudo ls -l should show

drwx------ 2 mysql mysql 12288 2009-12-24 12:56 openaudit

Furthermore

sudo ls -Rl openaudit should show the files in this folder also set with the correct permissions.

[code]
-rw-rw---- 1 mysql mysql 8682 2009-12-24 12:56 audit_commands.frm
-rw-rw---- 1 mysql mysql 184 2010-01-11 17:19 audit_commands.MYD
-rw-rw---- 1 mysql mysql 2048 2010-01-11 17:25 audit_commands.MYI
-rw-rw---- 1 mysql mysql 11362 2009-12-21 10:49 audit_configurations.frm
-rw-rw---- 1 mysql mysql 524 2010-01-05 13:02 audit_configurations.MYD
-rw-rw---- 1 mysql mysql 2048 2010-01-05 15:29 audit_configurations.MYI
-rw-rw---- 1 mysql mysql 8964 2009-12-10 14:56 audit_log.frm
-rw-rw---- 1 mysql mysql 422916 2010-01-05 12:30 audit_log.MYD
-rw-rw---- 1 mysql mysql 61440 2010-01-05 14:56 audit_log.MYI
-rw-rw---- 1 mysql mysql 10352 2009-12-21 10:49 audit_schedules.frm
-rw-rw---- 1 mysql mysql 316 2010-01-05 13:02 audit_schedules.MYD
-rw-rw---- 1 mysql mysql 2048 2010-01-05 15:29 audit_schedules.MYI
-rw-rw---- 1 mysql mysql 9072 2009-12-10 14:56 audit_settings.frm
-rw-rw---- 1 mysql mysql 84 2010-01-05 12:09 audit_settings.MYD
-rw-rw---- 1 mysql mysql 2048 2010-01-05 12:28 audit_settings.MYI
-rw-rw---- 1 mysql mysql 8790 2009-11-25 14:28 auth.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 auth.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 auth.MYI
-rw-rw---- 1 mysql mysql 9464 2009-11-25 14:28 auto_updating.frm
-rw-rw---- 1 mysql mysql 35136 2010-02-18 13:33 auto_updating.MYD
-rw-rw---- 1 mysql mysql 22528 2010-02-18 13:33 auto_updating.MYI
-rw-rw---- 1 mysql mysql 8858 2009-11-25 14:28 battery.frm
-rw-rw---- 1 mysql mysql 3596 2010-02-18 12:21 battery.MYD
-rw-rw---- 1 mysql mysql 6144 2010-02-18 12:21 battery.MYI
-rw-rw---- 1 mysql mysql 9044 2009-11-25 14:28 bios.frm
-rw-rw---- 1 mysql mysql 28300 2010-02-18 13:33 bios.MYD
-rw-rw---- 1 mysql mysql 21504 2010-02-18 13:33 bios.MYI
-rw-rw---- 1 mysql mysql 8854 2009-11-25 14:28 browser_helper_objects.frm
-rw-rw---- 1 mysql mysql 229644 2010-02-18 13:33 browser_helper_objects.MYD
-rw-rw---- 1 mysql mysql 63488 2010-02-18 13:33 browser_helper_objects.MYI
-rw-rw---- 1 mysql mysql 8620 2009-11-25 14:28 config.frm
-rw-rw---- 1 mysql mysql 20 2009-12-24 12:56 config.MYD
-rw-rw---- 1 mysql mysql 2048 2009-12-24 17:20 config.MYI
-rw-rw---- 1 mysql mysql 65 2009-11-25 14:28 db.opt
-rw-rw---- 1 mysql mysql 8836 2009-11-25 14:28 environment_variable.frm
-rw-rw---- 1 mysql mysql 255696 2010-02-18 13:33 environment_variable.MYD
-rw-rw---- 1 mysql mysql 112640 2010-02-18 13:33 environment_variable.MYI
-rw-rw---- 1 mysql mysql 9020 2009-11-25 14:28 event_log.frm
-rw-rw---- 1 mysql mysql 120996 2010-02-18 13:33 event_log.MYD
-rw-rw---- 1 mysql mysql 53248 2010-02-18 13:33 event_log.MYI
-rw-rw---- 1 mysql mysql 9106 2009-11-25 14:28 firewall_auth_app.frm
-rw-rw---- 1 mysql mysql 167052 2010-02-18 13:01 firewall_auth_app.MYD
-rw-rw---- 1 mysql mysql 58368 2010-02-18 13:01 firewall_auth_app.MYI
-rw-rw---- 1 mysql mysql 8944 2009-11-25 14:28 firewall_ports.frm
-rw-rw---- 1 mysql mysql 137992 2010-02-18 13:01 firewall_ports.MYD
-rw-rw---- 1 mysql mysql 64512 2010-02-18 13:01 firewall_ports.MYI
-rw-rw---- 1 mysql mysql 8846 2009-11-25 14:28 firewire.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 firewire.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 firewire.MYI
-rw-rw---- 1 mysql mysql 8956 2009-11-25 14:28 floppy.frm
-rw-rw---- 1 mysql mysql 11684 2010-02-18 13:01 floppy.MYD
-rw-rw---- 1 mysql mysql 7168 2010-02-18 13:01 floppy.MYI
-rw-rw---- 1 mysql mysql 8746 2009-11-25 14:28 graphs_disk.frm
-rw-rw---- 1 mysql mysql 1366744 2010-02-18 13:33 graphs_disk.MYD
-rw-rw---- 1 mysql mysql 655360 2010-02-18 13:33 graphs_disk.MYI
-rw-rw---- 1 mysql mysql 8712 2009-11-25 14:28 group_members.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 group_members.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 group_members.MYI
-rw-rw---- 1 mysql mysql 8652 2009-11-25 14:28 group_names.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 group_names.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 group_names.MYI
-rw-rw---- 1 mysql mysql 8616 2009-11-25 14:28 groups_details.frm
-rw-rw---- 1 mysql mysql 15312 2010-02-16 10:16 groups_details.MYD
-rw-rw---- 1 mysql mysql 7168 2010-02-18 13:33 groups_details.MYI
-rw-rw---- 1 mysql mysql 8928 2009-11-25 14:28 groups.frm
-rw-rw---- 1 mysql mysql 282216 2010-02-18 13:33 groups.MYD
-rw-rw---- 1 mysql mysql 95232 2010-02-18 13:33 groups.MYI
-rw-rw---- 1 mysql mysql 9498 2009-11-25 14:28 hard_drive.frm
-rw-rw---- 1 mysql mysql 82228 2010-02-18 13:33 hard_drive.MYD
-rw-rw---- 1 mysql mysql 29696 2010-02-18 13:33 hard_drive.MYI
-rw-rw---- 1 mysql mysql 9844 2009-11-25 14:28 iis.frm
-rw-rw---- 1 mysql mysql 8936 2009-11-25 14:28 iis_ip.frm
-rw-rw---- 1 mysql mysql 1252 2010-02-18 13:01 iis_ip.MYD
-rw-rw---- 1 mysql mysql 4096 2010-02-18 13:01 iis_ip.MYI
-rw-rw---- 1 mysql mysql 4148 2010-02-18 13:01 iis.MYD
-rw-rw---- 1 mysql mysql 4096 2010-02-18 13:01 iis.MYI
-rw-rw---- 1 mysql mysql 8866 2009-11-25 14:28 iis_vd.frm
-rw-rw---- 1 mysql mysql 6260 2010-02-18 13:01 iis_vd.MYD
-rw-rw---- 1 mysql mysql 4096 2010-02-18 13:01 iis_vd.MYI
-rw-rw---- 1 mysql mysql 8940 2009-11-25 14:28 iis_web_ext.frm
-rw-rw---- 1 mysql mysql 5484 2010-02-18 12:20 iis_web_ext.MYD
-rw-rw---- 1 mysql mysql 4096 2010-02-18 12:20 iis_web_ext.MYI
-rw-rw---- 1 mysql mysql 8720 2009-11-25 14:28 invoice.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 invoice.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 invoice.MYI
-rw-rw---- 1 mysql mysql 9072 2009-11-25 14:28 ip_route.frm
-rw-rw---- 1 mysql mysql 282488 2010-02-18 13:01 ip_route.MYD
-rw-rw---- 1 mysql mysql 98304 2010-02-18 13:01 ip_route.MYI
-rw-rw---- 1 mysql mysql 8984 2009-11-25 14:28 keyboard.frm
-rw-rw---- 1 mysql mysql 566100 2010-02-18 13:33 keyboard.MYD
-rw-rw---- 1 mysql mysql 130048 2010-02-18 13:33 keyboard.MYI
-rw-rw---- 1 mysql mysql 19932 2009-11-25 14:28 ldap_computers.frm
-rw-rw---- 1 mysql mysql 71900 2010-02-03 16:20 ldap_computers.MYD
-rw-rw---- 1 mysql mysql 22528 2010-02-04 08:35 ldap_computers.MYI
-rw-rw---- 1 mysql mysql 9120 2009-11-25 14:28 ldap_connections.frm
-rw-rw---- 1 mysql mysql 700 2009-12-07 13:40 ldap_connections.MYD
-rw-rw---- 1 mysql mysql 2048 2009-12-07 17:20 ldap_connections.MYI
-rw-rw---- 1 mysql mysql 8812 2009-11-25 14:28 ldap_paths.frm
-rw-rw---- 1 mysql mysql 296 2010-02-03 16:20 ldap_paths.MYD
-rw-rw---- 1 mysql mysql 2048 2010-02-04 12:51 ldap_paths.MYI
-rw-rw---- 1 mysql mysql 19046 2009-11-25 14:28 ldap_users_details.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 ldap_users_details.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 ldap_users_details.MYI
-rw-rw---- 1 mysql mysql 24194 2009-11-25 14:28 ldap_users.frm
-rw-rw---- 1 mysql mysql 77332 2010-02-03 16:20 ldap_users.MYD
-rw-rw---- 1 mysql mysql 23552 2010-02-04 08:36 ldap_users.MYI
-rw-rw---- 1 mysql mysql 8790 2009-11-25 14:28 log.frm
-rw-rw---- 1 mysql mysql 93044 2010-02-18 10:37 log.MYD
-rw-rw---- 1 mysql mysql 13312 2010-02-18 12:01 log.MYI
-rw-rw---- 1 mysql mysql 8812 2009-11-25 14:28 manual_software_detection.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 manual_software_detection.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 manual_software_detection.MYI
-rw-rw---- 1 mysql mysql 8928 2009-11-25 14:28 manual_software.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 manual_software.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 manual_software.MYI
-rw-rw---- 1 mysql mysql 9116 2009-11-25 14:28 mapped.frm
-rw-rw---- 1 mysql mysql 4759872 2010-02-18 13:01 mapped.MYD
-rw-rw---- 1 mysql mysql 1507328 2010-02-18 13:01 mapped.MYI
-rw-rw---- 1 mysql mysql 8788 2009-11-25 14:28 media.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 media.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 media.MYI
-rw-rw---- 1 mysql mysql 9068 2009-11-25 14:28 memory.frm
-rw-rw---- 1 mysql mysql 55932 2010-02-18 13:33 memory.MYD
-rw-rw---- 1 mysql mysql 32768 2010-02-18 13:33 memory.MYI
-rw-rw---- 1 mysql mysql 9012 2009-11-25 14:28 modem.frm
-rw-rw---- 1 mysql mysql 15764 2010-02-18 12:21 modem.MYD
-rw-rw---- 1 mysql mysql 9216 2010-02-18 12:21 modem.MYI
-rw-rw---- 1 mysql mysql 9326 2009-11-25 14:28 monitor.frm
-rw-rw---- 1 mysql mysql 64720 2010-02-18 13:33 monitor.MYD
-rw-rw---- 1 mysql mysql 27648 2010-02-18 13:33 monitor.MYI
-rw-rw---- 1 mysql mysql 9042 2009-11-25 14:28 motherboard.frm
-rw-rw---- 1 mysql mysql 21856 2010-02-18 13:33 motherboard.MYD
-rw-rw---- 1 mysql mysql 25600 2010-02-18 13:33 motherboard.MYI
-rw-rw---- 1 mysql mysql 8986 2009-11-25 14:28 mouse.frm
-rw-rw---- 1 mysql mysql 48724 2010-02-18 13:33 mouse.MYD
-rw-rw---- 1 mysql mysql 28672 2010-02-18 13:33 mouse.MYI
-rw-rw---- 1 mysql mysql 8996 2009-11-25 14:28 ms_keys.frm
-rw-rw---- 1 mysql mysql 741344 2010-02-18 13:33 ms_keys.MYD
-rw-rw---- 1 mysql mysql 189440 2010-02-18 13:33 ms_keys.MYI
-rw-rw---- 1 mysql mysql 8882 2009-12-21 10:49 mysql_queries.frm
-rw-rw---- 1 mysql mysql 0 2009-12-21 10:49 mysql_queries.MYD
-rw-rw---- 1 mysql mysql 1024 2009-12-21 10:49 mysql_queries.MYI
-rw-rw---- 1 mysql mysql 11276 2009-11-25 14:28 network_card.frm
-rw-rw---- 1 mysql mysql 371552 2010-02-18 13:33 network_card.MYD
-rw-rw---- 1 mysql mysql 46080 2010-02-18 13:33 network_card.MYI
-rw-rw---- 1 mysql mysql 8876 2009-11-25 14:28 nmap_ports.frm
-rw-rw---- 1 mysql mysql 234952 2010-01-04 19:00 nmap_ports.MYD
-rw-rw---- 1 mysql mysql 95232 2010-01-05 11:50 nmap_ports.MYI
-rw-rw---- 1 mysql mysql 8654 2009-11-25 14:28 notes.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 notes.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 notes.MYI
-rw-rw---- 1 mysql mysql 8848 2009-11-25 14:28 onboard_device.frm
-rw-rw---- 1 mysql mysql 44964 2010-02-18 13:33 onboard_device.MYD
-rw-rw---- 1 mysql mysql 31744 2010-02-18 13:33 onboard_device.MYI
-rw-rw---- 1 mysql mysql 8982 2009-11-25 14:28 optical_drive.frm
-rw-rw---- 1 mysql mysql 35636 2010-02-18 13:33 optical_drive.MYD
-rw-rw---- 1 mysql mysql 22528 2010-02-18 13:33 optical_drive.MYI
-rw-rw---- 1 mysql mysql 9702 2009-11-25 14:28 other.frm
-rw-rw---- 1 mysql mysql 71884 2010-02-18 13:33 other.MYD
-rw-rw---- 1 mysql mysql 16384 2010-02-18 13:33 other.MYI
-rw-rw---- 1 mysql mysql 8918 2009-11-25 14:28 pagefile.frm
-rw-rw---- 1 mysql mysql 16156 2010-02-18 13:33 pagefile.MYD
-rw-rw---- 1 mysql mysql 19456 2010-02-18 13:33 pagefile.MYI
-rw-rw---- 1 mysql mysql 9432 2009-11-25 14:28 partition.frm
-rw-rw---- 1 mysql mysql 77088 2010-02-18 13:33 partition.MYD
-rw-rw---- 1 mysql mysql 38912 2010-02-18 13:33 partition.MYI
-rw-rw---- 1 mysql mysql 8798 2009-11-25 14:28 passwords.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 passwords.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 passwords.MYI
-rw-rw---- 1 mysql mysql 9446 2009-11-25 14:28 processor.frm
-rw-rw---- 1 mysql mysql 410964 2010-02-18 13:33 processor.MYD
-rw-rw---- 1 mysql mysql 88064 2010-02-18 13:33 processor.MYI
-rw-rw---- 1 mysql mysql 9058 2009-11-25 14:28 scan_latest.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 scan_latest.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 scan_latest.MYI
-rw-rw---- 1 mysql mysql 9004 2009-11-25 14:28 scan_log.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 scan_log.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 scan_log.MYI
-rw-rw---- 1 mysql mysql 8842 2009-11-25 14:28 scan_type.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 scan_type.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 scan_type.MYI
-rw-rw---- 1 mysql mysql 9338 2009-11-25 14:28 scheduled_task.frm
-rw-rw---- 1 mysql mysql 263740 2010-02-18 12:17 scheduled_task.MYD
-rw-rw---- 1 mysql mysql 33792 2010-02-18 12:17 scheduled_task.MYI
-rw-rw---- 1 mysql mysql 9024 2009-11-25 14:28 scsi_controller.frm
-rw-rw---- 1 mysql mysql 5944 2010-02-18 13:01 scsi_controller.MYD
-rw-rw---- 1 mysql mysql 3072 2010-02-18 13:01 scsi_controller.MYI
-rw-rw---- 1 mysql mysql 8898 2009-11-25 14:28 scsi_device.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:28 scsi_device.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:28 scsi_device.MYI
-rw-rw---- 1 mysql mysql 8632 2009-11-25 14:29 service_details.frm
-rw-rw---- 1 mysql mysql 66720 2010-02-17 18:22 service_details.MYD
-rw-rw---- 1 mysql mysql 26624 2010-02-18 13:33 service_details.MYI
-rw-rw---- 1 mysql mysql 9170 2009-11-25 14:28 service.frm
-rw-rw---- 1 mysql mysql 5043760 2010-02-18 13:33 service.MYD
-rw-rw---- 1 mysql mysql 1063936 2010-02-18 13:33 service.MYI
-rw-rw---- 1 mysql mysql 8872 2009-11-25 14:29 shares.frm
-rw-rw---- 1 mysql mysql 127212 2010-02-18 13:33 shares.MYD
-rw-rw---- 1 mysql mysql 62464 2010-02-18 13:33 shares.MYI
-rw-rw---- 1 mysql mysql 9246 2009-12-03 14:00 smtp_connection.frm
-rw-rw---- 1 mysql mysql 112 2009-12-10 09:11 smtp_connection.MYD
-rw-rw---- 1 mysql mysql 2048 2009-12-10 11:24 smtp_connection.MYI
-rw-rw---- 1 mysql mysql 9378 2009-11-25 14:29 software.frm
-rw-rw---- 1 mysql mysql 8630 2009-11-25 14:29 software_group_members.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 software_group_members.MYD
-rw-rw---- 1 mysql mysql 2048 2009-11-25 14:29 software_group_members.MYI
-rw-rw---- 1 mysql mysql 8652 2009-11-25 14:29 software_group_names.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 software_group_names.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 software_group_names.MYI
-rw-rw---- 1 mysql mysql 9086 2009-11-25 14:29 software_licenses.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 software_licenses.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 software_licenses.MYI
-rw-rw---- 1 mysql mysql 12291300 2010-02-18 13:33 software.MYD
-rw-rw---- 1 mysql mysql 3056640 2010-02-18 13:33 software.MYI
-rw-rw---- 1 mysql mysql 8726 2009-11-25 14:29 software_register.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 software_register.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 software_register.MYI
-rw-rw---- 1 mysql mysql 8878 2009-11-25 14:29 sound.frm
-rw-rw---- 1 mysql mysql 36364 2010-02-18 13:33 sound.MYD
-rw-rw---- 1 mysql mysql 21504 2010-02-18 13:33 sound.MYI
-rw-rw---- 1 mysql mysql 8998 2009-11-25 14:29 spare.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 spare.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 spare.MYI
-rw-rw---- 1 mysql mysql 9052 2009-11-25 14:29 startup.frm
-rw-rw---- 1 mysql mysql 904844 2010-02-18 13:33 startup.MYD
-rw-rw---- 1 mysql mysql 172032 2010-02-18 13:33 startup.MYI
-rw-rw---- 1 mysql mysql 8894 2009-11-25 14:29 switch_ports.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 switch_ports.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 switch_ports.MYI
-rw-rw---- 1 mysql mysql 8834 2009-11-25 14:29 system_audits.frm
-rw-rw---- 1 mysql mysql 1198640 2010-02-18 13:33 system_audits.MYD
-rw-rw---- 1 mysql mysql 481280 2010-02-18 13:33 system_audits.MYI
-rw-rw---- 1 mysql mysql 9352 2009-11-25 14:29 system_change.frm
-rw-rw---- 1 mysql mysql 8968 2009-11-25 14:29 system_change_log.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 system_change_log.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 system_change_log.MYI
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 system_change.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 system_change.MYI
-rw-rw---- 1 mysql mysql 11518 2009-11-25 14:29 system.frm
-rw-rw---- 1 mysql mysql 9430 2009-11-25 14:29 system_man.frm
-rw-rw---- 1 mysql mysql 276 2009-12-09 13:59 system_man.MYD
-rw-rw---- 1 mysql mysql 3072 2009-12-10 08:25 system_man.MYI
-rw-rw---- 1 mysql mysql 109688 2010-02-18 13:33 system.MYD
-rw-rw---- 1 mysql mysql 21504 2010-02-18 13:33 system.MYI
-rw-rw---- 1 mysql mysql 8740 2009-11-25 14:29 system_security_bulletins.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 system_security_bulletins.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 system_security_bulletins.MYI
-rw-rw---- 1 mysql mysql 8858 2009-11-25 14:29 system_security.frm
-rw-rw---- 1 mysql mysql 0 2009-11-25 14:29 system_security.MYD
-rw-rw---- 1 mysql mysql 1024 2009-11-25 14:29 system_security.MYI
-rw-rw---- 1 mysql mysql 9072 2009-11-25 14:29 tape_drive.frm
-rw-rw---- 1 mysql mysql 35716 2010-02-18 12:19 tape_drive.MYD
-rw-rw---- 1 mysql mysql 9216 2010-02-18 12:19 tape_drive.MYI
-rw-rw---- 1 mysql mysql 8908 2009-11-25 14:29 usb.frm
-rw-rw---- 1 mysql mysql 90276 2010-02-18 13:33 usb.MYD
-rw-rw---- 1 mysql mysql 28672 2010-02-18 13:33 usb.MYI
-rw-rw---- 1 mysql mysql 8616 2009-11-25 14:29 users_detail.frm
-rw-rw---- 1 mysql mysql 5220 2010-02-17 10:12 users_detail.MYD
-rw-rw---- 1 mysql mysql 5120 2010-02-18 13:33 users_detail.MYI
-rw-rw---- 1 mysql mysql 9116 2009-11-25 14:29 users.frm
-rw-rw---- 1 mysql mysql 197912 2010-02-18 13:33 users.MYD
-rw-rw---- 1 mysql mysql 62464 2010-02-18 13:33 users.MYI
-rw-rw---- 1 mysql mysql 9492 2009-11-25 14:29 video.frm
-rw-rw---- 1 mysql mysql 106228 2010-02-18 13:33 video.MYD
-rw-rw---- 1 mysql mysql 33792 2010-02-18 13:33 video.MYI
-rw-rw---- 1 mysql mysql 8716 2009-12-21 10:49 ws_log.frm
-rw-rw---- 1 mysql mysql 4368 2010-01-05 13:02 ws_log.MYD
-rw-rw---- 1 mysql mysql 2048 2010-01-05 15:29 ws_log.MYI

[/code]

:D Any further issue, let me know.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 19, 2010 5:59 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
FYI You need to copy the whole openaudit folder in place of the original openaudit folder, just in case this isn't clear, and the versions of OA and MySQL must be the same.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 19, 2010 10:02 am 
Offline
Newbie

Joined: Fri Oct 23, 2009 3:08 am
Posts: 13
Thank you for the response, I am working on trying this I have been busy with other projects today. I am trying to revive the old server as I found it is the software raid that is the issue with the server not booting. Tonight I will see if I can get the server to boot and do a proper backup. If not I will attempt this transfer. I have a feel I will be following your procedure tomorrow evening or so....

Again, thank you for the response.

_________________
OA Server: Ubuntu 8.04 LAMP
Auditing: 400+ Wrkstns, 20+ Srvrs.
OS's: Windows XP , W2K3 Srvrs, W2k8 Srvr, Win7, Red Hat, and a MAC.
LDAP: 2 AD Domians, no trust.
I have scheduled audits running from the DCs.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group