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 :smiley:

Howdy,

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

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

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

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

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 :slight_smile:

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

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

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

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

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…

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

-Eric

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

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

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

Looks like everything is working now :slight_smile:

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

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