Postgres: Restoring A Filesystem Backup
i had to do a file system back up because of the size of my database.
i shutdown postmaster and tar'd the files.
i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.
i then su'd from root to postgres user:
Code:
[postgres@austin1 pgsql]$ psql service_2_3
psql: FATAL: database "service_2_3" does not exist
DETAIL: The database subdirectory "base/16385" is missing.
the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.
my data directory is /var/pgsql/data.
Code:
[postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385
but that yielded nothing.
have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.
how i can resolve this issue if you have the time.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Restoring 1.5GB SQL Dump (Postgres)
This seemed like the most appropriate place so I decided to post here. SYSTEM: Fedora Core 4, 3GHz, 2GB RAM Postgres 8, Apache 2, PHP 4 The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump. Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go. I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing: Code: gunzip -c dump.sql.gz | psql my_db But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated. I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file. Is there a way I could perhaps split up my db dump and then import them into the db one by one?
View Replies!
View Related
E2label (Restoring Backup From Old Primary)
I have a smart error of possible hard drive failure on a hard drive of a cPanel server. Before I ask for replacement of new drive, I'm going to get a new hard drive as New Primary and make the Old Primary as Secondary Drive (To Restore) I have the complete manual to restore. However the last time I tried to do that same thing, the system OS crash because it cannot tell which one is primary, and which is secondary (Both is SATA) My partition is /boot 100mb swap 2gb /tmp 500mb / rest of disk no LVM, installed on MBR I remember the last time I read something about e2label to rename my hdd label which cause the OS crash when new+old primary was booted together.
View Replies!
View Related
Restoring SQL Database Backup To Invision Power Board
I moved my site to a new host and am running IPB 1.3 forums, I have a 62meg sql backup to restore. I have tried using BIGDUMP.php as max upload is over 52megs. No Joy! I also tried zipping the file, got it down to 9megs, It wont complete the upload in PhpMyAdmin? I have not had to restore a back up before, and am really struggling.
View Replies!
View Related
Postgres Install
I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4 I checked and postgres is not listed in phpinfo output.
View Replies!
View Related
Cannot Add Postgres Database
PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added. root@server [~]# rpm -qa | grep postgre postgresql-devel-8.1.4-3PGDG postgresql-contrib-8.1.4-3PGDG postgresql-8.1.4-3PGDG postgresql-server-8.1.4-3PGDG postgresql-libs-8.1.4-3PGDG postgresql-python-8.1.4-3PGDG I've already compiled apache after postgres was upgraded months ago. I'm using cpanel 10x
View Replies!
View Related
Cron As Postgres User Not Working
I was hoping someone could shed some light on a cron related issue I'm having. I've been using linux for a while...but never really used crons. My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't. I opened my cron in vim via: Code: postgres@myhost:~$ crontab -e And here's the cron: Code: * * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz Also: Code: postgres@myhost:~$ ls -lah /var/www/test/postgres/ total 8.0K drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 . drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 .. Running the backup command via CLI works fine.
View Replies!
View Related
IDENT Authentication Failed For Postgres. Pg_hba.conf
I just reloaded the OS on our production server and I'm having issues configuring postgres. the user postgres exists in the system (i.e. 'su postgres' switches me to that user) i attempted to connect to my database 'service_2_3' via CLI: Code: $ su postgres $ psql service_2_3 and i recieved the following error: Code: psql: FATAL: IDENT authentication failed for user "postgres@service_2_3" the database is installed on the machine on which i was attempting to connect to it with. therefore, i edited my pg_hba.conf so that it looks like this: Code: # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 ident sameuser # IPv6 local connections: host all all ::1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 password and reloaded with (as user postgres): Code: bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log but i still get the same error. am i editing the wrong file, perhaps? how would i know which is the correct pg_hba.conf file? locate pg_hba.conf seems to give me a few results.
View Replies!
View Related
Read Only Filesystem
I have a server with pacificrack. When I see my website it says "Read-Only File system" and my SSH dies with read-only file system errors. It happens once per month, and the bad thing is I'm sleeping when it happens so I don't know my server is in this state. Even though support fixes the problem within 15minutes of my support ticket, my server is down for hours because I don't know its down to then raise a ticket. I asked support why it happens and they never tell me... just tell me to read the logs but I'm not technical enough to understand linux logs etc. Server is centos.
View Replies!
View Related
Filesystem Became Read-only
Somehow the filesystem on my server turned read-only. The databases would not connect. When I rebooted the box it would not come up. Support had to run FSCK. Even after, the databases had to be repaired using the CPanel tool. Things seem to be ok now, however: 1. What could have caused this to happen? Software or hardware failure? 2. I get these notifications, should I be worried? WARNING: Kernel Errors Present EXT3-fs error (device sda2): e...: 1 Time(s)
View Replies!
View Related
Mount Tmp As Filesystem
I currently have a VPS. I have installed cPanel/WHM + CSF Firewall. Everything is fine and all the ports are closed except for the ones I need. I currently have some issues I need to fix, but google isn't helping Quote: Check /tmp is mounted as a filesystemWARNING/tmp should be mounted as a separate filesystem with the noexec,nosuid options set I tried googling this and there was a cPanel script but I do not have permission to run it. So does anyone mind explaining it to me one step at a time? Quote: You should consider adding ini_set to the disable_functions in the PHP configuration as this setting allows PHP scripts to override global security and performance settings for PHP scripts. Adding ini_set can break PHP scripts and commenting out any use of ini_set in such scripts is advised I have disabled this in php.ini but I do not know why it still says that I have to fix this
View Replies!
View Related
Ext3 On A Very Large Filesystem
We're considering deploying a large server that will have 8x 500GB drives in a RAID-10 config. I intend to use a 3ware 9650SE w/ BBU along with A/B power to each of the PSU's. My question is... since this will return into a 2TB array/partition, in event of a crash (kernel panic, etc -- I expect a power outage will be very, very rare if at all) what do you guys think the fsck time would be? In my experience a RAID BBU significantly drops it, sometimes to the point of no manual fsck required, but in event of a manual fsck shouldn't the BBU be able to provide more consistent data (less errors) and therefore a much shorter fsck? Maybe just recovering the journal?
View Replies!
View Related
ISCSI Windows Clustered Filesystem
I'm currently connecting one of my servers to an iSCSI SAN but would like to hook up another server to that target as well. However, this doesn't work with NTFS filesystem and I couldn't really find any windows solutions for that. Does anyone have experience with this?
View Replies!
View Related
Quotacheck: Can't Find Filesystem Cpanel
My /etc/fstab: Code: # cat /etc/fstab # This file is edited by fstab-sync - see 'man fstab-sync' for details LABEL=/1 / ext3 defaults,usrquota 1 1 LABEL=/boot /boot ext3 defaults 1 2 none /dev/pts devpts gid=5,mode=620 0 0 none /dev/shm tmpfs rw,noexec,nosuid,nodev 0 0 none /proc proc defaults 0 0 none /sys sysfs defaults 0 0 LABEL=SWAP-sda2 swap swap defaults 0 0 /dev/sdb1 /backups ext3 defaults 1 2 Code: # /scripts/fixquotas Installing Default Quota Databases...../aquota.user..../quota.user..../boot/aquota.user..../boot/quota.user..../backups/aquota.user..../backups/quota.user.....Done Quotas are now on Updating Quota Files...... quotacheck: Can't find filesystem to check or filesystem not mounted with quota option. quotacheck: Can't find filesystem to check or filesystem not mounted with quota option. ....Done AND root@srv01 [/www/logs]# /scripts/initquotas Quotas are now on Updating Quota Files...... quotacheck: Can't find filesystem to check or filesystem not mounted with quota option. quotacheck: Can't find filesystem to check or filesystem not mounted with quota option. ....Done
View Replies!
View Related
Optimal HDD And Filesystem Settings For Web Hosting
I am in the process of configuring my volumedrive dedicated server and would like some input on ideal settings for my filesystem. I'd appreciate suggestions and explanations of what they options do. Here is my system info: Linux volumedrive.com 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86_64 x86_64 GNU/Linux CentOS release 5 (Final) AMD Sempron64 3000+ 1GB RAM HDD: Location: SCSI device B Cylinders: 60801 Size: 465.76 GB Model: ATA ST3500320AS Seagate Barracuda 7200.11 ST3500320AS 500GB 7200 RPM 32MB Cache SATA 3.0Gb/s Hard Drive Parameters I can change: EXT 3 File System Configuration Options: Block size Fragment size Bytes per inode Reserved blocks Journal file size Edit IDE Parameters Transfer mode: Default mode / Disable IORDY / PIO mode 1,2,3,4 / Multimode DMA 0,1,2 / Ultra DMA 0,1,2 Using DMA: On/Off Sector count: 256 Read-lookahead: On/Off Write caching: On/Off Interrupt unmask: On/Off Keep settings over reset: On/Off Keep features over reset: On/Off Read only: On/Off Reprogram best PIO: On/Off Standby timeout: 0 32-bit I/O support: Disable / Enable / Enable with special sync sequence Sector count for multiple sector I/O: Disable 2 4 8 16 32
View Replies!
View Related
Restoring Mailboxes
I am in the process of migrating client's website and mailboxes. My server is using Plesk 8.1 with horde as the default webmail applacation and had to install Squirrelmail beacause he was using this program integrated in his website. I have been able to install it, configure it, it works both on Http and Https and i'm able to receive and send emails. After this i'm trying to restore all the mailboxes into the new server (10 GB worth of mail) but i can't seem to find where to place that folder. I have tried google and looked everywhere suggested but can't find the folder where mails are stored I have been able to find the folder where the addressbook and config file for every account is located (/var/qmail/mailnames/DOMAIN/ALIAS) but there are no emails there despite the fact that they appear in the Inbox in Squirrelmail. The server is running Debian 3.1 with Plesk 8.1 and Squirrelmail 1.4.4
View Replies!
View Related
Restoring Files
I had my server with FDCservers and its back after 2 days of horrible downtime which according to them was due to hardware failure. Server specs: Intel Core 2 DUO E6600 @ 2.40 GHz 4096 MB RAM 400 GB HDD cPanel The old drive has Fedora 5 running with cPanel but on new drive, its CentOS 4.5 with cPanel. Now, I want to restore the files from old(slave) drive to master(main on which centOS is running) How do I do that? Isnt there any possibility since I changed the Operating System.
View Replies!
View Related
Restoring Database
Here's the situation: Moving from VPS to Dedicated, VPS (cPanel) and Dedicated (Plesk)... I FTP'd all the files, what's left is the database. I was going to restore the db using SSH, but I had to FTP it first, so I tried but half-way it would time out (disconnect from server) Right now I am trying phpMyAdmin, I doubt it will work. Is there a way to transfer from cPanel to Plesk? DB size is 400MB
View Replies!
View Related
Getting Error While Restoring Database.
SQL query: /*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */; MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UNLOCK TABLES; -- -- Table structure for table `qhvbmailer_campaigns` -- DRO' at line 1
View Replies!
View Related
Restoring Email To A VPS
I have an existing client with about 200 email accounts, I want to migrate all of them off of our server and to a VPS or something. They wil use a webmail to access them. Is that possible? Also, is it possible to give the client access only to create email accounts without giving them access to the whole hosting control panel?
View Replies!
View Related
Error With Mysql While Restoring Account
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases: Quote: ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database roundcube...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists' ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database horde...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists' ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string Done What does this error mean and how to solve this problem? I have updated cpanel and mysql but the problem is still found This problem found while trying to restore any account not this one only..
View Replies!
View Related
Error When Restoring Reseller Privs
i try to restore a backup from another hosting to my server and always get stucked on "restoring reseller privs" i'm using restorepkg username and got this error Code: not a reference at /usr/local/cpanel/Cpanel/CachedDataStore.pm line 27 at whm i can transfer multiple account and select "skip restoring reseller privs" but in this case my old hosting doesnt provide ssh access. i was wondering is there any paramater to skip that? something like Code: /scripts/restorepkg -somethingblahblah accusername
View Replies!
View Related
Restoring Accounts To Addon Domain
Currently, 2 domains hosted on a dedicated server with each account having its own Cpanel. I'm going to move/migrate these 2 domains to a shared hosting server. The shared hosting accont has Cpanel and I've added 2 Add-on domains (the same ones on the dedicated). In total, there are 3 domains under the shared hosting account; The main domain and the 2 other (add-on) domains. My question is it possible to restore these 2 accounts under a single cpanel account and having all the emails intact? So, in essence, I'm having a single cpanel account to manage the 2 domains to be transferred from the dedicated.
View Replies!
View Related
Restoring Incremental CPanel Backups To A New Drive
We have incremental backups running in our server. We want to move the cPanel accounts to a new cPanel server and restore in that server. The Backup Restore option in WHM will recognize only compressed backups (like .tar.gz) when it is placed in the /home directory. So how do I do about restoring a incremental backup through the WHM of the new server?
View Replies!
View Related
Restoring Full Backups - CPanel And PuTTy
I’ve just switched to a deticated server. I have backups of sites I need to move over and restore. cPanel has a “Restore a Full Backup/cpmove” option. Two questions… 1) How do I upload the back up file to the /home directory of my deticated server? 2) If the backup file is under a current client “/home/clienta” how do I restore it? I’ve also tried using puTTy to restore the file. - logged into as “root” - typed “cd /home” - typed “/scripts/restorepkg domainname”
View Replies!
View Related
BackupPC Restoring Files Without GUI Or Command Line
I got our server staff to install BackupPC on our dedicated server and run daily backups. All is well (from what I can tell) but i've come to a point where I want to actually use an archived file. So I jump into my ftp client, navigate to the backup folder, and download the file. The problem is, the file reads as jibberish. I'm assuming that BackupPC has compressed it. So the question is two-fold: 1. How do I decompress it on windows (command line stuff is well beyond me) 2. Is there any browser/windows apps that I can use to manage the backups?
View Replies!
View Related
Restoring Mysql Db From .frm, .MYD, .MYI Files
I did the absolutely most stupid thing yesterday, I emptied the wrong mysql table via phpmyadmin. Fortunately my host managed to grab a the table in question from a few days ago. So I have: auctions.frm, auctions.MYD, and auctions.MYI My assumption, is that I can just overwrite the current files of the same name in the mysql folder, and everyone will be happy. Is there some more to this process?
View Replies!
View Related
Rsyn --backup --backup-dir Switches For Incremental Backs
I current do some rsync backups with a command like so every day rsync -az -e ssh --stats --delete --exclude "stuff" / user@server:/home/user/ What I want to do is have some incremental backups in there in subdirectories. So, for example, something like this on the remote server /home/user/something.tuesday /home/user/something.friday I thought the --backup --backup-dir Switches were used to store just the files that had changed in seperate directories, am I wrong on that? I've read everything I could find, including the big rsnapshot scripts, but I'm not able to do what I want, it seems so simple but something's not right, am I wrong that subdirs should have just files that are new or have changed. I tried various things like this, but had no luck rsync -az -e ssh --stats --delete --backup --backup-dir=/home.Thursday --exclude "stuff" / user@server:/home/user/
View Replies!
View Related
[cpbackup] Backup Failed! /backup Is Not Mounted!
my cpanel doesn't get backups. When I force it, it gives me this error: mount: can't find /backup in /etc/fstab or /etc/mtab mount: can't find /backup in /etc/fstab or /etc/mtab [cpbackup] Backup failed! /bekkaplars is not mounted! at /scripts/cpbackup line 415. It's a vps. Another interesting thing is, my other 3 vpses run good even /etc/fstab has no line like /backup in there, also.
View Replies!
View Related
Remote Backup Or Local Backup
I would like to weight the benefits and costs of using remote backup and local backup to another hardisk? Let's assume the price is the same. What's the benefits of using remote backup? Is it secured to use local backup in another hardisk? I'm running on linux centos. What happend if hacker get hold of my server? Currently, i have 80GB of diskspace. Does it mean i will need at least 80GB of ANOTHER hardisk to backup that?
View Replies!
View Related
How To Take Backup
How To take Backup in a Reseller account..I have over 54 account in an Reseller hosting ..i don't have ssh ..then how can i take full backup of all the account... any idea ..the Server is REDHAT Enterprise 3 With WHM 11.23.0 cPanel 11.23.1...
View Replies!
View Related
Best Way To Backup VP
What would be the best way to Backup my VPS? It currently is running WHM/Cpanel with around 5 accounts. Would I need to tar/gzip the directorys, and manually use the ssh commands to backup each of the mysql databases? My new host also has WHM/Cpanel, so would I need to use the backup feature the CP provides?
View Replies!
View Related
Backup
I have a server that I wish to create an additional backup of, in particular a php+mysql site that is critical to our operations. Can anyone recommend excellent applications that can create backup archives, perhaps combined with a cronjob?
View Replies!
View Related
What Are You Using For Backup
While we looked at Acronis, their sales was not on top of things (long story), and the product appears very expensive ($999 per server to back up). For those of you who have two or more racks of servers with a mixture of Unix and Windows 2003, what hardware and software are you using to back up those servers? Are any of you using auto tape loaders? If so, does the tape loader software pull the backup from the servers, or do you have to set up the servers to push the backup to the tape loader equipment?
View Replies!
View Related
Backup Strategy
I am asking myself what the best backup strategy for my dedicated server could be. I do not host any commercial website on it (just private ones), but we all know that even losing non-commercial data hurts. What I already do: More or less recent backups of the most important websites (just webspace, no email or database) on my local computer Having hardware Raid-1 on the server and 2 HDs Using R1Soft Backup Space provided by my server host I would like to add some FTP space at an external (!) DC to do scheduled cPanel backups. I think that a further dedicated server or VPS will not be necessary for this task. Can you recommend a provider of pure FTP Backup Space which is reliable, at least on a 100 Mbps line and affordable? I guess I need about 100-200 GB of space to keep daily, weekly and monthly backups.
View Replies!
View Related
Email Backup
Can anyone suggest a solution for one of my clients. Their email is very important to them and is their main point of contact. Their old account (shared hosting) got suspended a few times due to going over their hourly limit. I have now put them on a new account on my VPS. Unfortunately the ip was blacklisted in the first week and they are getting about 25% of mail bounce backs due to being rejected. They also experienced a few hours of downtime while the nameservers propagated, so all in all they're not very happy. I would like to offer them the following: incoming back - if their server/mail goes down, mail either gets stored or re-routed to an alternative address outgoing mail - if their server/mail goes down, they have an alternative way of sending email from their domain outgoing mail - if their ip address gets blacklisted again, an alternative way of sending email from their domain until the issue is fixed.
View Replies!
View Related
Backup Server
I'm looking for a dedicated machine that will be used solely for rsync backups. (I don't want to use a shared rsync solution) Requirements are simple, at least 1TB HD and < $99 a month. Should have a decent amount of RAM and processor, but other than that, I would think any reputable provider would do. Most places I find a suitable server for $49 and then see it's another $50/mo. to upgrade to a 1TB hard drive. Hard to believe the markup for these larger drives considering they go for, what $89 now?
View Replies!
View Related
Backup Solutions
Presently I run a site on a shared server. I run a database backup every night to the host root and two backup servers and I run a full root backup every week to the backup servers. I have two questions. One, let's say I lose my entire forum root for some reason and need to run a backup. I use vBulletin and am wondering how that works with the database. Would the database be stored in the root somewhere, or would I have to take one of my database backups, create a new database in cpanel, and import the backup into the new database (and link to it via config.php)? Second, I'm looking to increase my backup security. I understand that offsite backup servers are great if the site gets hacked, but let's say the server gets hacked. Not that I find it likely, but if it does happen from what I understand the hacker could destroy the rsync'd backups because the key is right there. I'm looking for a backup solution that would keep this from happening. I'm thinking of going with an external RAID harddrive configuration with DVD backups at regular intervals (probably weekly). I'm considering using an automatic FTP from one of my backup roots (more bandwidth) to my computer. If I do this, and my main root is compromised, is there any way the hacker could compromise my home computer or backups. Further, is there a way to get the information on my home computer without simply copying everything over every time, because that will really eat bandwidth and take a lot of time. I know rsync is great because it only updates, and thus if I lose all my folders it won't delete the backup, whereas an FTP that happened at the correct time could potentially do so.
View Replies!
View Related
|
TRACKER
