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