Back-up Database And Replace The Existing One

Jan 4, 2007

I have a site but it was corrupted due to server problem with host. I have a back-up of DB in phpMySQL.

I am now installing the same script in new server and the site is now running.

The problem is, I want to use my back-up database and replace the existing one. How to do this?

View 2 Replies


ADVERTISEMENT

Plesk 11.x / Windows :: Add Existing MSSQL Database?

Sep 18, 2012

I restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.

View 2 Replies View Related

Plesk 12.x / Windows :: How To Import Existing MS SQL Database Into Subscription

Apr 2, 2015

I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.

I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?

The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.

View 1 Replies View Related

Plesk 12.x / Windows :: Associate Existing Database With Subscription

Feb 24, 2015

Plesk12 on IIS8.5/Windows2012r2.

For a migrated site, how can I associate an existing DB with a subscription? The only option I see is to add a new database and this is not a new database?

View 1 Replies View Related

Error On Importing Back-up Database

Jan 4, 2007

Quote:

Error

SQL query:

CREATE TABLE `hm2_deposits` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`user_id` bigint( 20 ) NOT NULL default '0',
`type_id` bigint( 20 ) NOT NULL default '0',
`deposit_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_pay_date` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum( 'on', 'off' ) default 'on',
`q_pays` bigint( 20 ) NOT NULL default '0',
`amount` double( 10, 5 ) NOT NULL default '0.00000',
`actual_amount` double( 10, 5 ) NOT NULL default '0.00000',
`ec` int( 11 ) NOT NULL default '0',
`compound` float( 10, 5 ) default '0.00000',
PRIMARY KEY ( `id` ) ,
KEY `hi1` ( `user_id` ) ,
KEY `hi2` ( `deposit_date` ) ,
KEY `hi3` ( `status` ) ,
KEY `hi4` ( `user_id` , `status` )
) ENGINE = MYISAM AUTO_INCREMENT =538 DEFAULT CHARSET = latin1;

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 'DEFAULT CHARSET=latin1' at line 18

View 5 Replies View Related

How To Back Up Columns In Mysql Database

Oct 24, 2008

I have a mysql database, and what I wanna do is to back up specific columns only. For example, I have a table with 2 columns:

City, Zipcode

How can I do that with mysqldump?

View 2 Replies View Related

Supermico Minis Back To Back

Jun 19, 2007

Can you put two of these supermicro mini servers back to back in a standard rack? I am looking at the [url]

View 14 Replies View Related

Does Your Provider Back Up Your VPS Or Do You Back It Up Yourself

Nov 10, 2009

Many of the VPS providers I've looked at don't back up the servers that house the VPSs and as such don't back up the VPSs either - have you considered what would happen should the VPS itself be erased (such as what happened to vaserv/fsckvps not too long ago)?

View 14 Replies View Related

Replace Disks With Little Downtime

Feb 12, 2008

I colo a 1U machine with 2-36gig drives. They're not in RAID, and I have it set to rsync backups to a remote machine on a regular schedule. I have another remote machine functioning as a secondary DNS. Neither of these 2 are on a large upstream pipe. I just bought 2-147gig drives that I'd like to replace the 36g's with. How does this sound for a scenario to accomplish this with little downtime (pre-pardon my noob'ish ways):

1. Do a complete rsync of the filesystem to my remote machine as well as sync the mysql db's (to 1 remote drive).

2. Pop that single rsync'd drive into an external enclosure.

3. Travel to datacenter, once there, plug external drive into laptop and start up a VM that boots off of that drive.

4. Sync again so external drive has the most up-to-date data.

5. Change over IP's from colo to VM on laptop.

6. Shutdown and swap out drives in colo'd box with the new ones.

7. Setup new drives as RAID 1, install OS, then rsync filesystem over from laptop to new drives in colo'd box.

8. Change back IP's.

What am I missing, or is there an easier way without a 2nd colo/dedicated server? Currently, the colo'd machine is using about 1.3Mbit/sec outbound and it's running a low load.

View 5 Replies View Related

4 Hours To Replace Hardware

Apr 16, 2009

Recently a drive in one of my main box's has failed.

Ive contacted my provider, however there SLA states - 4 Hours for hardware replacement.

It takes 4 hours to replace a harddrive? What are they, sloths?

Anyone else had similar experiences when attempting to get drives replaced?

View 14 Replies View Related

Replace Hypervm/lxadmin

Jun 21, 2009

we know hypervm/lxadmin have some exploit. My server is ruuning with lxadmin. Is there any panel to replace it? I mean we can easily to reload OS, use File Manager like hypervm...

View 4 Replies View Related

Replace Larger HD For Raid 5

Jul 21, 2009

i have a msi server with three seagate HD,

and use seagate ST336607LC to do raid5.

the raid card is adaptec 2200S,

it is installed with centos with cpanel.

today,the websites shows 500 internal error and i asked the DC reboot,

minutes later,the websites run well.

but minutes later,it down again,and i ssh to reboot,

minutes,it shows file system problem,it seems readonly?...in my memory.

and i ask the DC to reboot again,

and i still can not login,and the DC staff tell me it shows with "operation system not found"...

and i go to DC,

it shows there is no logical drives... and operation system not found.

and i try to use ctrl+a to access raid control panel,

it shows there is no raid setting....

and i try to verify the hds in raid control panel,

it shows my 3rd hd has defect and ask if want to assign new block,

at begining,i chose no,it still can not load the os.

and then i chose yes to reassign the block and passing the verify,

but it still can not load the os.

i can not get any ST336607LC now,

i want to ask can i use larger HD to replace the 3rd hd?

if yes,after replacing and booting,

should i reset the raid configuation?

View 7 Replies View Related

Inexpensive VPS To Replace Reseller Hosting

Nov 4, 2009

Currently paying 24.95/month with Hostgator on a reseller plan but am only using ~2Gb drive space and less than 2Gb or monthly transfer.

Would be nice to find a VPS that has CPanel for about the same price range.

View 13 Replies View Related

Find & Replace Of Text For Security...

Jul 25, 2007

My old VPS was hacked and an iframe html string was added to just about all the files on the server.

I've since then identified the vulnerability and moved to a new host and want to copy the accounts over but wanted to know if there was an easy way to search all the files for this html code and delete it?

For example, search all files for <iframe etc etc> and delete it?

I know this is probably rather simple...but I have no idea how to do it.

View 2 Replies View Related

Replace Linux With Windows Server Via Vkvm

Jun 1, 2009

I'm trying to replace my Linux OS with Windows Server 2003, which I already have a license.

I'm talking about OVH Kimsufi XL.

Following support's instructions, I booted my dedicated with netboot, specific with vkvm option.

Then I specified an ftp location, (where there is my "totally working" .iso), and I started the virtual session.

After some mins, a java windows appears, and starts the vnc session.

After usual linux loading, it stops on this :

Code:
VFS: Cannot open root device "801" or unknown-block(8,1)
Please append a correct "root=" boot option; here are the available partitions:
0300 244198584 hda driver: ide-gd
0301 5245191 hda1
0302 238428687 hda2
0303 522112 hda3

Kernel panic - not syncing: VFS: Unable to mount root fs on unknown-block(8,1)

And, besides I cant write a letter!

View 13 Replies View Related

How To Set Up Cron Job To Replace Index File Every 3 Hours...

Apr 18, 2007

I would like to replace my index file every three hours, with a specified file on the server thats in a different folder (someone keeps putting unwanted stuff in my index file) Can someone explain to me how this is done?

View 2 Replies View Related

SSH Or Program How To File Replace Lots Of Files

Jan 14, 2007

I have anywhere between 80,000 - 90,000 webpages that have a single code into this. Unfortunately at the time the web developer I used didn't use PHP includes. So each .html file has the code in it.

I want a way so I can do a single command either a program or an SSH command can find the syntax in the files and replace it will code I have. Its just a single line of code that is basically for an adsense code, so the pub-blahblahblah etc..

Does anyone know of a SSH command I can use, or a program that will find and replace without manually opening up each file? 80k - 90k of opening files then find/replace will take forever!

View 11 Replies View Related

Plesk 11.x / Linux :: Can't Restore Backup And Replace Files

May 25, 2014

I am trying to restore a backup that Parallels Plesk made (latest version) and I used to get the option at some point to replace everything. Now, I only get the options to select what I want to restore and it fails because it says certain things, domains, content is already there.

I can't find the option anymore that allows me to say replace everything during the backup. Was that removed? If so, I'd really....really like it back.

Warning:
Failed deployment of domain localhost.localdomain
Warning:
Execution of /usr/local/psa/admin/plib/api-cli/domain.php --create localhost.localdomain -owner admin -do-not-apply-skeleton -notify false -guid 4fe5de63-3103-4fa0-a01c-04894e167107 -vendor-guid 75b2fa01-6c6e-4cb2-8f1b-9c69757fd3ec -creation-date 2014-02-13 -ip 46.165.251.98 -ignore-nonexistent-options failed with return code 1.
Stderr is
An error occurred during domain creation: There are no available resources of this type (domains) left. Requested: 1; available: 0.

View 1 Replies View Related

Plesk 11.x / Windows :: Possible To Replace Express Edition With Web In Panel?

Feb 23, 2014

I have one customer installed with plesk 11.5 + power pack integrated with mssql 2008 express on his server.But now client want to install Mssql 2008 web edition. Is this possible to replace the express edition with web in plesk panel?

View 1 Replies View Related

Are There Any Stable Cloud Hosting Options To Replace Dedicated Server?

Oct 4, 2008

I've got a dedicated server through Liquid Web. I can't say enough about how great the reliability and service has been since I switched over to them a number of months ago.

Nevertheless, with the advent of cloud hosting, I'm intrigued by the idea of paying for what I actually use on a server rather than having way more capacity than I need 90% of the day.

I've looked around here and there's a bit of talk about it but it doesn't seem like folks are scrambling into it and it also appears that the offereings are still relatively immature.

I really don't have the time to devote to tweaking, etc or figuring out something really complicated.

I'll stick to my dedicated server if it means tons of extra work or potential downtime or massive frustration but I wanted to get some feedback from the community about whether or not there are some stable cloud hosting options that are emerging that might be worth considering.

View 14 Replies View Related

LiteSpeed :: Binary Path Must Be Set Properly In Order Replace Apache

Apr 6, 2008

2008-04-06 08:52:32.597ERRORApache Binary Path must be set properly in order replace Apache, fall back to 'Reload on configuration file change'.
2008-04-06 08:52:32.602WARN[configerver:listener] No listener is available for normal virtual host!
2008-04-06 08:52:32.604ERROR[config:template:centralConfigLog] Listener [Default] does not exist
2008-04-06 08:52:32.605ERROR[config:templateHP_SuEXEC] Listener [Default] does not exist
2008-04-06 08:52:32.605ERROR[config:template:EasyRailsWithSuEXEC] Listener [Default] does not exist
2008-04-06 08:52:32.617WARNStandard Edition only support up to 5 Apache vhosts.

I did everything on the litespeed setup I was soppose to found at their wiki site. But still I recieve these errors, LiteSpeed works on my server because httpd is disabled and LiteSpeed is responding to request now.

View 8 Replies View Related

Plesk 11.x / Linux :: Application Vault - Replace Quick Install Button

Jul 30, 2014

We've been experiencing a lot of trouble with novice customers that want to install an Application Vault package that has sub-optimal default settings, e.g.

customer wants to install wordpress, clicks on Application Vault -> wordpress -> "INSTALL"

This will install, without any questions for settings, wordpress into domain.com/wordpress - which is not what people want. I know that there is a button with teh drop down menu that shows "custom", however, people don't see/know about it and click "install".

Is there a way to remove / replace the "quick install" button and have the "install custom" as default.

View 2 Replies View Related

Run An Existing Site On A LAN

Mar 30, 2008

I am currently trying to transition a website from one CMS to another.

I need to configure and build the new CMS so that it retains the same features of the previous CMS.

I don't want to interrupt service to the website, thus I need to build the new one offline and then switch the two.

Can a domain server with the same domain structure of the WWW be run on a LAN?

I was thinking of configuring a FreeBSD server with apache on a private IP LAN.
Then I would run a DNS server to emulate the internets domain structure (.com, .net and .org).

View 3 Replies View Related

Forwarding Existing Emails

Jul 27, 2008

I have this strange issue,

There are few domains with few email accounts with some existing emails, like

user@domain1.com having 60 mails in inbox
user2@domain1.com having 125 mails in inbox

user@domain2.com having 80 mails in inbox
user2@domain2.com having 380 mails in inbox

And many more.

Now these existing emails are to be forwarded to onespecificmailid@some-remote-domain.com

How to automate this?

There are hundreds of other mail accounts too which should not get disturbed/touched.

Each existing mail should be forwarded as normally incoming mails are forwarded.

We have root access and server specs are:
WHM 11.23.2 cPanel 11.23.4-R26138
CENTOS Enterprise 5.2 i686 on standard - WHM X v3.1.0

Any idea how to do that?

View 9 Replies View Related

3dgwebhosting.com Support- Existing Or Not

Dec 3, 2008

I've tried posting 3 tickets (2 support and 1 billing) and so far non of them was answered. 1st ticket I've posted was 11/18/2008 and until now, no response.
Has anyone seen their support and billing in action??? my last ticket was for billing canceling my account. They've got good prices but lacking of support people... too bad

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved