Which Host For Website With MySQL Database
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Database And Website On Different Servers
We have 2 linux servers directly connected by Gigabyte Ethernet. On a First server (192.168.0.1) we have a website (PHP5, Apache2), on the Second server (192.168.0.2) (CentOS 5 64bit, kernel: 2.6.22.9xe5u) we have MySQL 5.0 Database. A website from a Fist server connects to the database on the Second. The problem is that this system is very slow. We triet to move our website from First server to the Second and it works 50-300 times faster. This is very strange, because when we print SQL queries of a website we see that some similar queries which are not dependent on a data or where there are very small amount of data, are executing in very different time. For example: SELECT t.*, tl.title, tl.content FROM site_tree_public AS t INNER JOIN site_tree_public_localdata AS tl ON t.id=tl.site_tree_public_id WHERE t.hidden='0' AND tl.lang_keyword='eng' ORDER BY parent_id, orderid 0.61763 after refresh 0.00365 another refresh 0.86579 another refresh 0.00302 another refresh 1.22748 Another example: Four similar queries to four different databases (shemas), on one page load: SET NAMES utf8 0.00021 SET NAMES utf8 0.00012 SET NAMES utf8 0.00012 SET NAMES utf8 0.20491 When we moved website to the Second server these queries are executing in a good stable time. Also some following problems were noticed: 1. While connecting to the FTP, server slowed down and sometimes connections were dropped 2. We tried to install Ubuntu unsuccesfully - the network didnt work at all, then we moved to CentOs 5 3. When we first installed CentOs 5 with standart kernel we had experienced problems with network (IP's aliases just didnt work) then we installed newer kernel and the problem was solved. first server - SM-XE2, SuperMicro 6014H-82, Dual Xeon 3.4 Ghz, 4GB DDR RAM, 2x72GB U320 SCSI RAID1, Dual Intel PRO1000, 1U second server - SM-XEW, SuperMicro 6015P-8, Dual Xeon 2.0 Ghz (Woodcrest 5130) , 8GB DDR RAM, 2x73GB U320 SCSI RAID1, Dual Intel PRO1000, 1U So the question is - what do you think about the problem? Did you use such a system - when a website is on one server and the database on the second? And what was the experience? Could it be kernel problems? we think that it might be problems with kernel that dont work properly with network, please comment this.
View Replies!
View Related
Hosting For 4GB Website + 2GB SQL Database
I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?
View Replies!
View Related
Reloading A Mysql Database
My server admin linked me to this: [url] I'm using a cpanel based server, but I can't get this to work. It requires I be in a directory I figure (this step isnt included) so I type cd /home/username/public_html/ And then i follow the commands. but it doesnt work. Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@
View Replies!
View Related
Get Mysql Database From Shell
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server. The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method. Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?
View Replies!
View Related
MySQL With Huge Database
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance. The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option. Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours. I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far: 1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once). 2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially. I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View Replies!
View Related
Big Mysql Database 4gb
i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick
View Replies!
View Related
Managed Database Hosting (Mysql)
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View Replies!
View Related
[mySQL] Copy Colomn From 1 Database To Another
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade. The DB structure table forum_msgs It contains a column called "topic_id". Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id" I tried this but it doesn't seem to work correctly. Any ideas how it should be done? insert current.forum_msgs ( topic_id ) select topic_id from old.forum_msgs
View Replies!
View Related
Alterntive Way For Downloading A MySQL Database
A friend of mine has an account with a hosting company that recently became unstable and he wants to move his site away. I downloaded the files, but it now seems impossible to download the databases in the conventional ways. I tried downloading them using their control panel (vDeck) but I get an error "File Permissions do not allow to download backup". Then I tried to export it using PHPMyAdmin but the files either doesn't download at all, or it downloads inccomplete with the last lines having something like the following: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/phpMyAdmin-2.6.3/export.php:121 I tried to contact their support but they have no clue. Is there any way to download the database? I thought of creating a script that would manually itterate through the tables and create an export fie similar to what phpMyAdmin creates. I don't know if this is possible, and I hope there are better ways.
View Replies!
View Related
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database. It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs. I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS. I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem. All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts. I just added an hourly crontab so as to restart the MySQL server as a stop gap.
View Replies!
View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ? Quote: # mysqldump gallery > gallery.sql mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES # I checked the table, it is fine, but can't do the backup. Quote: mysql> check table 10tir_user_group; +-------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------+ | gallery.10tir_user_group | check | status | OK | +-------------------------+-------+----------+----------+ 1 row in set (0.07 sec) mysql>
View Replies!
View Related
Exporting Mysql Database From Helm
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server... the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created.. in host i could see server.mysql in php database config files i want to export database...to linux server i have not used helm much.. where actually is database located and how can it be exported?
View Replies!
View Related
Fetch Admin Password From MySQL Database
I have forgot the admin password for one of our application. All the users and passwords are stored in database table "users", is there any way I can get the password from the database.. any MySQL query that will fetch the admin password from that database table.
View Replies!
View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down
View Replies!
View Related
Mysql Database Dump (150mb) Utf8
recently I had problems with backing up my ~150mb database through PHP. And I know some people are backing their databases to a dump file through terminal. My database contains UTF-8 and other characters. I have tried simply dumping with mysqldump but I doesn't seem to work, when restoring all the characters are messed up. Is there any command to tell that the database is UTF-8?
View Replies!
View Related
MySQL Database Service Stops From Running
I have a phpBB forum, which uses MySQl database. For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason. What can cause such a frequent database failures? Can someone attack the forum/database/server in a way that will cause the above problem? (there is a good reason I consider this possibility very seriously) How can I prevent futher database failures?
View Replies!
View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password. How is it possible to copy the database, without having the hosting panel access?
View Replies!
View Related
Exceeding Database Quota Advice On New Host
I run a fairly large but low traffic oscommerce site that is currently hosted on ipower. I exceed the "max_questions" variable they have limiting sql queries. I have already created a bunch of users and it helps but it's still not perfect. What I need: • No SQL Limits. • Ability to host up to 10 domains. • 5 gigs of storage (user uploads). • 20 gig/month of bandwidth. • Fast network. • Access to techs that know what they are doing. • 10-20 emails • A nice user friendly panel to handle everything. • Looking to keep price around $10-$20 a month. I would love to have a slice of the CPU and memory like a VPS but I don't know linux and it's a little scary.
View Replies!
View Related
Trying To Import Mysql Database Via CLI In Ubuntu Linux
I have ubuntu 6 server version running. I am trying to import a database I have however I cannot get it working for the last 2 hours! I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run. Also tried the full command mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql Neither seem to do anything. PHPMYADMIN shows no database tables at all. Running mySQL 5.
View Replies!
View Related
Trying To Host A Website From Home PC
I am trying to host a website from my home computer. Currently I have it setup and it works and everything. I have my virus database updated, router update, firewall up and running, and I am ready for people to try hacking. But there is one thing I can do. I can't seem to get my website online. I go to whatismyip.com and try that IP address on both the computer I am hosting the website from and a different computer downtown but I can access it. I am currently using webs.com to tell people to download COMODO EasyVPN to access my website. But they have to download it first to be able to access my website. At one time I had to load it using the IP address I go to whatismyip.com but it took it six minutes to load and with the EasyVPN it only takes seconds. I am just wandering if my internet connection is just timing out and not letting anyone on. Is there a software I can use that works like COMODO EasyVPN but lets you type in my External/Public IP address and it go to my website. I mean my connection is slow but with the COMODO EasyVPN software it makes people connecting to my computer fast. I need a software that tunnels my connection to a clients computer. I am using the XAMPP software to host my website!
View Replies!
View Related
Community Website - Which Host
I've had four different hosts in 1½ year, and I'm noe experiencing problems again with my current host, Lunarpages. Therefore, I really want to make the right choice this time. It would be such a pleasure to see my website run without any problems for more than just 8-9 months at a time... Anyway, let me try to describe it. It's based on the Content Management System phpFusion. It has news, downloads, forums and screenshots. The site itself is c. 2 GB large (because of forum attachments and screenshots), the download section is c. 15 GB, and the site use up about 700 GB og bandwidth each month. In the forum, there's 100.000 posts, growing day for day, of course. We have 12.000 registered members, but we only have c. 50 members online at the same time -- maximum. Throughout a week, 2.000 members log in, but as said, they are never online at the same time. The members are mostly from Europe, but we do also have members from USA and Australia. I've had both Lunarpages and Servage as hosts, but I have experienced problems with both of them. Servage has a daily bandwidth limit which I had overlooked, and the website constantly exceeded this. Lunarpages is very, very slow when using a MySQL DB.
View Replies!
View Related
Host For My First Proxy Website
i would like to put Glype proxy and some ads on it. So which host should i choose. I was considering TMZhosting for $5.99/month. 110gb/month. How does that sound? Any better hosts for around this price? BTW i already registered a domaine at godaddy.com
View Replies!
View Related
Host For Affliate Website
I'm not familiar with hosting issues at all, and I'm planning to set up an affiliate webisite for online gambling. Hostgator, which after reading the posts on this forum has been my choice doean't accept affliate webistes.
View Replies!
View Related
Website Hacked. Time For A New Host
I have a small but somewhat popular space-history website. Very simple HTML that I typed into wordpad, but it has long pages full of photos. Since 2003, I've been using media3.net with their business-class Windows service. A few weeks ago, mypages were hacked, and a one line script inserted that called an Adobe Flash file. Apparently this was a server-wise attack, not just my web pages. Media3.net cleaned this up, but now it has happened again. This is bad, because Google blacklists my site, and folks on Wikipedia get upset because there are a lot of links to my site. How are they breaking in to media3.net? I think I must change hosts, but I don't want to put my image-intensive site on overbooked hardware with limited bandwidth.
View Replies!
View Related
Using A Website Host For Computer Backup
If I get a reseller account with like 50 gigs more space (or any amount) than I actually use, can I use some of that space I'm paying for to backup my home computer? This isn't really a question of how (although I'll accept advice) but more a question of 'is this typically allowed' or 'does anybody else do this'?
View Replies!
View Related
|
TRACKER
