Ive killed my Virtualmin X_X please help me save my databases and files

13 posts / 0 new
Last post
#1 Thu, 06/07/2012 - 05:16
Xencored

Ive killed my Virtualmin X_X please help me save my databases and files

Ok to cut a long story short ive messed up everything tying to install lets just say "something silly"

Ive got ext2explore on my home windows computer and have wacked in my servers HDD ive saved

/home so am guessing that's all the website files

but where is the databases located? also is it posable to save the virtual servers?

Thanks alot, I be lost with out you guys on this site <3 eric :D

Thu, 06/07/2012 - 09:03
andreychek

Howdy,

Well, if you have access to all your files, it may be possible to get things working again :-)

You may want to try setting up an identical OS somewhere else, and begin copying relevant files from your current hard drive to your new system.

Your web files and email are all in /home.

Your databases are in /var/lib/mysql.

Your users are in /etc/passwd, /etc/shadow, and /etc/group.

All the Webmin/Virtualmin configuration is in /etc/webmin.

You'll also have various other config files throughout /etc for the various services that were running -- the Apache config, BIND config, and so on -- you'll want to copy that as well.

-Eric

Thu, 06/07/2012 - 09:19
Xencored

Hey Eric the main "stuff" is (as if I was doing a full backup within virtualmin) that's the only stuff I need to get if I can get them

Thu, 06/07/2012 - 10:08
andreychek

Well, the problem is that the Virtualmin backups really do a lot of work in order to back things up correctly :-)

The Virtualmin backup process goes through every relevant config file, pulls out the section related to a given domain, and associates that with the backup for that domain. That happens for Apache, BIND, Postfix, and so on.

Without Virtualmin backups, you'll have to do that entire process manually, which will be quite a bit of work. Though I do believe it's possible :-)

Since you're trying to restore everything, what that means is that copying over the full config file for every service configured by Virtualmin should work for you (along with all the other files and directories mentioned above).

-Eric

Thu, 06/07/2012 - 10:12
Xencored

Hey

I have a old back up which was done with virtualmin, if I upload that get it to restore everything than copy over the datebases and files via winSCP think that would work?

I don't use bind (if this means anything)

Cheers

Thu, 06/07/2012 - 11:00
andreychek

If you have full backups, even older ones, that would really help.

You could first restore those backups -- then copy the files from /home, and then the databases from /var/lib/mysql -- and after that you should largely be in good shape!

-Eric

Thu, 06/07/2012 - 11:08
Xencored

Eric Ive done what you said yet some datebase are showing empty even tho the mysql files are there

Thu, 06/07/2012 - 11:11
Xencored

edit that, there all coming up with datebase errors

A Database Error Occurred Error Number: 1194

Table 'nova_sessions' is marked as crashed and should be repaired

SELECT * FROM (nova_sessions) WHERE session_id = '1ce927d0f573d3b0da037e76f81ba338' AND ip_address = '86.6.56.216' AND user_agent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5'

Filename: libraries/Session.php

Line Number: 213

Database error in vBulletin 4.1.2:

Invalid SQL:

        UPDATE cache
        SET locktime = 1339085299
        WHERE cacheid = 'forumblock.04ccc27af4d69954fd7b5153c6cc5822';

MySQL Error : Table 'cache' is marked as crashed and should be repaired Error Number : 1194 Request Date : Thursday, June 7th 2012 @ 05:08:19 PM Error Date : Thursday, June 7th 2012 @ 05:08:20 PM Script : http://mana4x2rpg.com/ Referrer : IP Address : 86.6.56.216

Error Number: 1036

Table 'nova_sessions' is read only

INSERT INTO nova_sessions (session_id, ip_address, user_agent, last_activity, user_data) VALUES ('6825126ec9a6e758cc3e208bf7f2495c', '86.6.56.216', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5', 1339085305, '')

Filename: libraries/Session.php

Line Number: 328

etc..

Thu, 06/07/2012 - 12:13
Xencored

Also eric I restarted mysql and now some of them are not connecting to the datebases (there saying there just not there)

Thu, 06/07/2012 - 12:03
andreychek

Whenever copying database files, be sure to do it when MySQL is stopped -- otherwise strange things can happen :-)

-Eric

Thu, 06/07/2012 - 12:14
Xencored

Still the same eric same errors ive jsut done a full reinstall (well I was doing it before you posted) as I thought I copyed over some "stuff" I shouldn't have. But its just the same.

in one error its saying its read only? is there some thing I need to do after I copy the new sql files ?

edit

I ran

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

and got some of this

nova_b5.nova_characters_data Error : File './nova_b5/nova_characters_data.MYD' not found (Errcode: 13) Error : File './nova_b5/nova_characters_data.MYD' not found (Errcode: 13) Error : Table 'nova_characters_data' is read only error : Corrupt nova_b5.nova_posts Error : File './nova_b5/nova_posts.MYD' not found (Errcode: 13) Error : File './nova_b5/nova_posts.MYD' not found (Errcode: 13) Error : Table 'nova_posts' is read only error : Corrupt nova_b5.nova_wiki_drafts Error : File './nova_b5/nova_wiki_drafts.MYD' not found (Errcode: 13) Error : File './nova_b5/nova_wiki_drafts.MYD' not found (Errcode: 13) Error : Table 'nova_wiki_drafts' is read only error : Corrupt nova_fbi.nova_characters_data Error : File './nova_fbi/nova_characters_data.MYD' not found (Errcode: 13) Error : File './nova_fbi/nova_characters_data.MYD' not found (Errcode: 13) Error : Table 'nova_characters_data' is read only error : Corrupt nova_fbi.nova_posts Error : File './nova_fbi/nova_posts.MYD' not found (Errcode: 13) Error : File './nova_fbi/nova_posts.MYD' not found (Errcode: 13) Error : Table 'nova_posts' is read only error : Corrupt nova_sgc.nova_characters_data Error : File './nova_sgc/nova_characters_data.MYD' not found (Errcode: 13) Error : File './nova_sgc/nova_characters_data.MYD' not found (Errcode: 13) Error : Table 'nova_characters_data' is read only error : Corrupt nova_sgc.nova_missions Error : File './nova_sgc/nova_missions.MYD' not found (Errcode: 13) Error : File './nova_sgc/nova_missions.MYD' not found (Errcode: 13) Error : Table 'nova_missions' is read only error : Corrupt nova_sgc.nova_posts Error : File './nova_sgc/nova_posts.MYD' not found (Errcode: 13) Error : File './nova_sgc/nova_posts.MYD' not found (Errcode: 13) Error : Table 'nova_posts' is read only error : Corrupt rpgrealm.wp_frm_fields Error : File './rpgrealm/wp_frm_fields.MYD' not found (Errcode: 13) Error : File './rpgrealm/wp_frm_fields.MYD' not found (Errcode: 13) Error : Table 'wp_frm_fields' is read only error : Corrupt rpgrealm.wp_options Error : File './rpgrealm/wp_options.MYD' not found (Errcode: 13) Error : File './rpgrealm/wp_options.MYD' not found (Errcode: 13) Error : Table 'wp_options' is read only error : Corrupt rpgrealm.wp_postmeta Error : Table 'wp_postmeta' is read only error : Corrupt rpgrealm.wp_posts Error : File './rpgrealm/wp_posts.MYD' not found (Errcode: 13) Error : File './rpgrealm/wp_posts.MYD' not found (Errcode: 13) Error : Table 'wp_posts' is read only error : Corrupt shieldomega.nova_access_groups error : Table 'shieldomega.nova_access_groups' is read only shieldomega.nova_access_pages error : Table 'shieldomega.nova_access_pages' is read only shieldomega.nova_access_roles error : Table 'shieldomega.nova_access_roles' is read only shieldomega.nova_applications error : Table 'shieldomega.nova_applications' is read only shieldomega.nova_awards error : Table 'shieldomega.nova_awards' is read only shieldomega.nova_awards_queue error : Table 'shieldomega.nova_awards_queue' is read only shieldomega.nova_awards_received error : Table 'shieldomega.nova_awards_received' is read only shieldomega.nova_bans error : Table 'shieldomega.nova_bans' is read only shieldomega.nova_catalogue_ranks error : Table 'shieldomega.nova_catalogue_ranks' is read only shieldomega.nova_catalogue_skins error : Table 'shieldomega.nova_catalogue_skins' is read only shieldomega.nova_catalogue_skinsecs error : Table 'shieldomega.nova_catalogue_skinsecs' is read only shieldomega.nova_characters error : Table 'shieldomega.nova_characters' is read only shieldomega.nova_characters_data error : Table 'shieldomega.nova_characters_data' is read only shieldomega.nova_characters_fields error : Table 'shieldomega.nova_characters_fields' is read only shieldomega.nova_characters_promotions error : Table 'shieldomega.nova_characters_promotions' is read only shieldomega.nova_characters_sections error : Table 'shieldomega.nova_characters_sections' is read only shieldomega.nova_characters_tabs error : Table 'shieldomega.nova_characters_tabs' is read only shieldomega.nova_characters_values error : Table 'shieldomega.nova_characters_values' is read only shieldomega.nova_coc error : Table 'shieldomega.nova_coc' is read only shieldomega.nova_departments_blk error : Table 'shieldomega.nova_departments_blk' is read only shieldomega.nova_docking error : Table 'shieldomega.nova_docking' is read only shieldomega.nova_docking_data error : Table 'shieldomega.nova_docking_data' is read only shieldomega.nova_docking_fields error : Table 'shieldomega.nova_docking_fields' is read only shieldomega.nova_docking_sections error : Table 'shieldomega.nova_docking_sections' is read only shieldomega.nova_docking_values error : Table 'shieldomega.nova_docking_values' is read only shieldomega.nova_login_attempts error : Table 'shieldomega.nova_login_attempts' is read only shieldomega.nova_manifests error : Table 'shieldomega.nova_manifests' is read only shieldomega.nova_menu_categories error : Table 'shieldomega.nova_menu_categories' is read only shieldomega.nova_menu_items error : Table 'shieldomega.nova_menu_items' is read only shieldomega.nova_messages error : Table 'shieldomega.nova_messages' is read only shieldomega.nova_mission_groups error : Table 'shieldomega.nova_mission_groups' is read only shieldomega.nova_missions error : Table 'shieldomega.nova_missions' is read only shieldomega.nova_news error : Table 'shieldomega.nova_news' is read only shieldomega.nova_news_categories error : Table 'shieldomega.nova_news_categories' is read only shieldomega.nova_news_comments error : Table 'shieldomega.nova_news_comments' is read only shieldomega.nova_personallogs error : Table 'shieldomega.nova_personallogs' is read only shieldomega.nova_personallogs_comments error : Table 'shieldomega.nova_personallogs_comments' is read only shieldomega.nova_positions_blk error : Table 'shieldomega.nova_positions_blk' is read only shieldomega.nova_posts error : Table 'shieldomega.nova_posts' is read only shieldomega.nova_posts_comments error : Table 'shieldomega.nova_posts_comments' is read only shieldomega.nova_privmsgs error : Table 'shieldomega.nova_privmsgs' is read only shieldomega.nova_privmsgs_to error : Table 'shieldomega.nova_privmsgs_to' is read only shieldomega.nova_ranks_blk error : Table 'shieldomega.nova_ranks_blk' is read only shieldomega.nova_security_questions error : Table 'shieldomega.nova_security_questions' is read only shieldomega.nova_sessions error : Table 'shieldomega.nova_sessions' is read only shieldomega.nova_settings error : Table 'shieldomega.nova_settings' is read only shieldomega.nova_sim_type error : Table 'shieldomega.nova_sim_type' is read only shieldomega.nova_specs error : Table 'shieldomega.nova_specs' is read only shieldomega.nova_specs_data error : Table 'shieldomega.nova_specs_data' is read only shieldomega.nova_specs_fields error : Table 'shieldomega.nova_specs_fields' is read only shieldomega.nova_specs_sections error : Table 'shieldomega.nova_specs_sections' is read only shieldomega.nova_specs_values error : Table 'shieldomega.nova_specs_values' is read only shieldomega.nova_system_components error : Table 'shieldomega.nova_system_components' is read only shieldomega.nova_system_info error : Table 'shieldomega.nova_system_info' is read only shieldomega.nova_system_versions error : Table 'shieldomega.nova_system_versions' is read only shieldomega.nova_tour error : Table 'shieldomega.nova_tour' is read only shieldomega.nova_tour_data error : Table 'shieldomega.nova_tour_data' is read only shieldomega.nova_tour_decks error : Table 'shieldomega.nova_tour_decks' is read only shieldomega.nova_tour_fields error : Table 'shieldomega.nova_tour_fields' is read only shieldomega.nova_tour_values error : Table 'shieldomega.nova_tour_values' is read only shieldomega.nova_uploads error : Table 'shieldomega.nova_uploads' is read only shieldomega.nova_user_loa error : Table 'shieldomega.nova_user_loa' is read only shieldomega.nova_user_prefs error : Table 'shieldomega.nova_user_prefs' is read only shieldomega.nova_user_prefs_values error : Table 'shieldomega.nova_user_prefs_values' is read only shieldomega.nova_users error : Table 'shieldomega.nova_users' is read only shieldomega.nova_wiki_categories error : Table 'shieldomega.nova_wiki_categories' is read only shieldomega.nova_wiki_comments error : Table 'shieldomega.nova_wiki_comments' is read only shieldomega.nova_wiki_drafts error : Table 'shieldomega.nova_wiki_drafts' is read only shieldomega.nova_wiki_pages error : Table 'shieldomega.nova_wiki_pages' is read only shieldomega.nova_wiki_restrictions error : Table 'shieldomega.nova_wiki_restrictions' is read only uss_nova.nova_characters_data Error : File './uss_nova/nova_characters_data.MYD' not found (Errcode: 13) Error : File './uss_nova/nova_characters_data.MYD' not found (Errcode: 13) Error : Table 'nova_characters_data' is read only error : Corrupt uss_nova.nova_wiki_drafts Error : File './uss_nova/nova_wiki_drafts.MYD' not found (Errcode: 13) Error : File './uss_nova/nova_wiki_drafts.MYD' not found (Errcode: 13) Error : Table 'nova_wiki_drafts' is read only error : Corrupt ussmarauder.wp_frm_fields Error : File './ussmarauder/wp_frm_fields.MYD' not found (Errcode: 13) Error : File './ussmarauder/wp_frm_fields.MYD' not found (Errcode: 13) Error : Table 'wp_frm_fields' is read only error : Corrupt ussmarauder.wp_options Error : File './ussmarauder/wp_options.MYD' not found (Errcode: 13) Error : File './ussmarauder/wp_options.MYD' not found (Errcode: 13) Error : Table 'wp_options' is read only error : Corrupt ussmarauder.wp_posts Error : File './ussmarauder/wp_posts.MYD' not found (Errcode: 13) Error : File './ussmarauder/wp_posts.MYD' not found (Errcode: 13) Error : Table 'wp_posts' is read only error : Corrupt

Thu, 06/07/2012 - 12:28
Xencored

Hey it seems the files I copyed over was set to root and they needed to be mysql

Looks like everything is working now :)

only last thing eric is there a way I can limit the upload from the whole server ? to like 400kb

Thu, 06/07/2012 - 14:41
Brook

For future reference, there are some mysql back-up guides on vbulletin's website (server section) - back ups are handy for situations like these :p

Topic locked