"moving Hosts " [ How To Shift Databases]
Feb 1, 2007
I am trying to shift from one hosting company to another. I currenty use a content management system for my website which utilizes databses + i have a forum as well which has a database as well.
So, i want to know how can i transfer all the files and databases accurately without any damages coz my forum has about 500 members and i dont want to loose the data obviously!
Secondly, my content management system has many posts as well which i want to tranfer safely.
I have got a cpanel control panel.
View 4 Replies
ADVERTISEMENT
Jun 11, 2009
I just had a thought. If I am moving from one host to the other, the old host would still have my files. Whats stopping them from just using the files to copy my site. Basically is there an easy way to delete my files from my old host?
View 14 Replies
View Related
Nov 29, 2008
I'm just wondering. Say, you sign up with a host offering a huge discount (50%+ off for a year). And after that year is up, you move to a new host offering another huge discount. You keep doing this, every year.
I'm pretty sure a lot of people do this.
I guess from a webhosts persepctive, it will be quite annoying since they are banking on the fact that the person will stay with them after the initial year.
View 10 Replies
View Related
Oct 19, 2009
We are currently running a phpBB forum on Dreamhost shared hosting and have been getting a lot of Internal Server Errors, so it's time to move to a new host.
We generally have around 200-300 members online (within the last 30 mins). We are using around 2.8TB/month of bandwidth currently. We get around 135,000 visits per month and 470,000 pageviews.
Dreamhost use their own way of measuring database usage..
Quote:
We've developed a unit of measure that helps to track database performance that we call the "conuery":
(25 * connections) + queries = Your database's conuery usage
Our database disk usage us 24mb, we are averaging around 100,000 database connections per day, around 85,000 queries per day and our "Conuery" is around 3 MCn per day (this means nothing to me either lol).
I have found a VPS package with directspace - 2x Intel Quad Core Xeon, 50GB Storage, 2Gb RAM, 2.5GB Burst Ram and 5TB of monthly bandwidth, for $35/month.
Is this likely to be an adequate solution for our needs? We would be running both the database and web services for phpBB from this box.
Also, can anyone give any hints on the best (and most seamless way) to migrate? I'm thinking that we'll get the new host to install all the services and get the box up and running, then I can ftp the files to the new server and export/import the databases. Then perform a (301?) redirect on the old host, pointing to the new IP address until the DNS is updated.
I realise that I'll need to update the config.php for phpbb with the new database details etc, along with the database details for our wordpress implementation and update the server details in the board configuration.
View 14 Replies
View Related
Mar 10, 2008
I have example.com as a reseller account hosted on a shared server. I have ns1.example.com and ns2.example.com on that server and client domains use these nameservers.
I want to move to a VPS for more control and so I have acquired vps.example.com. This also has vps_ns1.example.com and vps_ns2.example.com with it.
Can I move everything to the VPS? Assuming that I move the files over, if I simply changed the DNS of example.com to point to nameservers vps_ns1(and 2).example.com, what would happen?
Have I made it over complicated for me to understand, and it's actually a lot easier than I think? Or have I shot myself in the foot by using vps.example.com as the name for the VPS?
I am using cPanel/WHM for both servers.
View 3 Replies
View Related
Feb 5, 2008
I'm in the process of moving some websites between hosts... from Dreamhost to a VPS.
Basically I want to make sure that no emails get lost in the transfer, as it's possible some people haven't collected their emails. I'm only talking about 5 or 6 sites here with about 15 mailboxes in total.
I have pop3 set up on the VPS with exim4 and courier using Maildir's. I have imap/pop3 access to emails on dreamhost and all my clients only use pop3.
Dreamhost doesn't provide direct access to the Maildir's of users, so I was planning on using offlineimap to save a copy of each mailbox and move it into the Maildir of the user on the VPS. I.e. move the contents of INBOX/new into user/Maildir/new etc. I'll do this once the dns settings have propogated so I can be sure to have every single email.
Does this sound reasonable? Is anything likely to break? Will any email clients break with any of these transferred emails? I tried it with a test account and it seemed OK, but I would like an experts opinion on whether or not this is the best way of achieving what I'm trying to do
View 3 Replies
View Related
Dec 17, 2007
I am hosted by iPowerWeb and they have been causing MANY problems with their customers and of course, I am one of them. My site has been down for nearly 5 days.
I went to hostjury.com and they are now offering to move iPowerWeb customers to Hostgator, Hostican, or Site5 for free. But my question is: are they reliable and trustworthy?
Also, what hosting company do YOU guys recommend?
View 5 Replies
View Related
May 1, 2014
I use Nas to manage the customer site folder.
So the folder directory will be "as1webhostxxx" this format
I found that plesk panel default directory is inetpubvhosts
How to move the Virtual Hosts Directory to Nas ?
View 9 Replies
View Related
May 14, 2007
STAY AWAY FROM HOSTINGPLEX! OR SHOULD IT BE HOAX-ING-PLEX? TOTAL INCOMPETENCE!
After one week and no email on my new VPS and repeated requests by the admins to document what the problem was over and over again I decided to contact sales and report how unsatisfied I was with their service.
The 3rd shift admin promptly removed my VPS and destroyed thousands of dollars worth of development.
I guess if you are that lame that you can't get email working on a week you need to lash out and cause damage to someone. I'll be calling in the morning to see if this is regular policy to immediately void a contract and destroy the current working website wothout any warning.
Reponse from hoaxingplex admin below.
Hello,
We haverefunded the payment and removed the vps, your domain is not registered through us so you already have access to reconfigure it for a new vps, we are not withholding access to anything.
Kevin Moonlight
Hostingplex.Com
Ticket Details
===================
Ticket ID: SYQ-564945
Department: Level 3 Support
Priority: Medium
Status: Open
View 14 Replies
View Related
Mar 2, 2009
i want to shift my domain to one server to another server and the problem is how can i shift my email accounts data to one server to another server.
View 8 Replies
View Related
Apr 2, 2008
I was in the market for a new dedicated server after a couple of years with my previous provider. The previous provider did nothing wrong but they were no longer competitive when it came to CPU and memory.
I moved first to geekrack. And I left them after a week and a half as they never were able to get my rDNS records setup.
I found Universal Hosts on this forum and gave them a shot. I had asked for an operating system that they didn't offer normally (Debian 64 bit) and they said that they could do it. However, when my server was setup it was 32 bit Debian instead. They apologized and had Debian 64 bit setup less than 24 hours later.
When I asked them to get rDNS records setup it took a few hours but they were setup correctly and they worked.
Universal Hosts is also a BurstNet reseller but compared to my other attempt at using a BurstNet reseller they are fantastic. While the initial config was incorrect they worked quickly to fix it and were very professional about it.
So after two weeks - so far so good. Keep up the good work UniHosts!
View 1 Replies
View Related
Aug 11, 2013
I am running Apache2.2, PHP5.I have been running with virtual hosts on a Windows 7 environment fine for a couple of years successfully, but have just had to move to a Windows 8 environment.It looks like Apache and PHP have installed and are working fine, but my Virtual hosts are now not being recognised. From what I can tell, it is the Windows 8 hosts file that is having a problem, as it looks as though it is now just setup to Block websites.
If I make the host file just have the one line127.0.0.1 localhost entry, then the very first Virtual Host from my apache config file will come up, but the rest are not found.If I put the usual 127.0.0.1 mywebsite.name aliasname is appears as though my website works momentarily and then is blocked..
View 7 Replies
View Related
Aug 16, 2008
Recently I stumbled along a host on here with a good rep and that uses direct admin.
Because they were very nice on the live support I signed up to see what direct admin was like.
Its very diferent from cpanel. Some parts seem to be harder to use like the phpmyadmin requires the username and password to the database you created not the control panel username and password like cpanel. Although I guess that could be a good security feature just in case some one gets into the control panel they can not get into the phpmyadmin, then again if they are smart and were able to get into the control panel they could get into ftp and look what the username and password is on the config file for the script you are using.
The bandwidth meter seems to be better in direct admin although I think its acting up for me as its putting yesterdays bandwidth on todays. I was told by the host that it updates every 2 hours and at first it did but now its gone to every day. Oh and unlike cpanel this bandwidth meter includes bandwith used by the control panel.
Niether one from what I can tell counts sftp though at least for the hosts I have right now.
View 14 Replies
View Related
Nov 4, 2009
Do u want to run an online e-commerce store? create a forum? or develop the next facebook or myspace? If you answered yes to any of th questions then there are very important factors you need to consider before choosing a host.
You have to understand that there's a difference between Database and database size. UNLIMITED database means that you have as many databases as you want, but of what use is an unlimited database if the disk size for the database is just 50MB for example. Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions. Afterall you might not need an unlimited database afterall.
View 14 Replies
View Related
Apr 19, 2008
So your host keeps at least a daily backup of your database, but if you don't get to the backup in time, you may find that they have a backup of a crashed database. That means its important to have a procedure for getting regular backups by other means too. How are you doing this?
View 9 Replies
View Related
Feb 25, 2008
we have been trying to import sql databases through cpanel.
The old server the client was on did not have any control panel. While the new server the client is migrating to, has cpanel. We try importing sql databases through cpanel, but because the sql databases are so large in size, they corrupt while importing them.
The client's old server he would be able to access all his sql databases through FTP.
While with this new cpanel server, we can't upload sql databases by FTP. We are wanting to use FTP because when using cpanel, the sql databases corrupt.
So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?
View 5 Replies
View Related
May 7, 2007
Does anyone know anything about how to set up a mysql database? I installed this script for a gallery for wordpress but it won't create it's own databases. I already set one up myself but Im still getting this error:
Quote:
SELECT * FROM wp_fim_cat ORDER BY date DESC
Is there something Im supposed to add inside each database table? And how do I add it to make it work?
View 1 Replies
View Related
Sep 24, 2008
I need to export all databases on my server to put it on my new server. Is there a quick and easy way to do that without doing the WHM transfer?
View 4 Replies
View Related
Oct 25, 2009
Just wanted to ask, which folder are the MySQL databases held in for Cpanel? Running CentOS 5 VPS.
View 7 Replies
View Related
Apr 14, 2008
Recently I have noticed at least a couple of SQL 2000 databses hacked in different servers. The hacker inserts a javascript code whose source is [url] file. The code is inserted in all records of some tables especially the tables having html code in the records. We are running SQL 2000 on some unused port and not the default port and also we have firewalls enabled in all the servers. We also have the latest updates and fixes applied in the servers. Can anybody throw some light on this and help me find the cause and solution to prevent this from happening again?
View 14 Replies
View Related
Jun 4, 2008
I have most of my sites on the very reliable clook.co.uk but I only only get around a Gig of bandwidth per month per site.
I'm thinking of getting an unlimited hosting package so I could upload client's music files, large images, video clips etc.. Nothing is illegal or adult. Then I could host my sites as normal at Clook and then point to all the very large files being hosted at the new place.
I think I'd get about 10Gig of traffic max a month. And as it'll just be an extended online harddrive I've no real need for databases, email, php, cPanel etc...
I've seen some unlimited offers at hostpapa.co.uk for 4.99 a month with a free domain. Is there a catch? What do you recommend?
View 9 Replies
View Related
Nov 3, 2008
I am using bqinternet.com to backup (Rsync) some accounts.
I sent them a ticket before 2 days and didn't get any reply.
I used this command to schedule a remote backup for specific accounts:
Code:
echo "30 6 * * * root rsync -avz -e ssh ~account1 ~account2 ~account3 myuser@myuser.bqbackup.comerver" >> /etc/crontab
But, I found this command will backup only files.
How can I backup also databases?
View 11 Replies
View Related
Dec 14, 2008
I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together.
I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.
View 3 Replies
View Related
Aug 26, 2008
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View 1 Replies
View Related
Mar 9, 2007
I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs
However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value?
For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.
View 10 Replies
View Related
Sep 14, 2007
My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys)
I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this:
Code:
[root@rosemary v2]# ls -l /mnt/dying/var/lib/
total 68
...
....
-rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status
drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman
drwxr-xr-x 2 root root 4096 Oct 12 2005 misc
?--------- ? ? ? ? ? mysql
drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs
drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp
...
...
And if I try to cd into the dir, I get this:
Code:
[root@rosemary v2]# cd /mnt/dying/var/lib/mysql
-bash: cd: /mnt/dying/var/lib/mysql: Input/output error
I really *really* need this data!
Am I just totally S.O.L. ?
View 1 Replies
View Related
Jul 20, 2007
I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC?
I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.
View 2 Replies
View Related
Jun 13, 2007
I have several DBs and need to run a cron job on one of the databases every night.
to run a repair/optimize on the DB as its very active, this is the command I thought I would use:
Code:
REPAIR TABLE `etc` , `etc` ,
Code:
OPTIMIZE TABLE `etc` , `etc` ,
How do I specify which database to run this on in the cron in CPanel?
View 2 Replies
View Related
Jan 14, 2007
I would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases.
The integration with MySQL is easy?
View 7 Replies
View Related
Aug 10, 2007
i currently have a database which is about 400mb
I am trying to use lxadmin to do a back up but it keeps crashing the db
how do i do the mysql back up?
i have ssh access
View 6 Replies
View Related
Jul 9, 2009
I've been running a forum for a while now which of course had a database. Now I sold the vBulletin License and I'd like to delete the database that was created for it. How do I do that?
I've looked throught cPanel, but couldn't find an option on deleting a whole database. Might be looking in the wrong sections or something. Can someone help me out?
It would be even better if it is possible to reset my whole server throught cPanel. Is this possible?
View 10 Replies
View Related
