Remote Mysql Host ...
but first, is it a good idea to have mysql on a remote server? let's say my app makes about 400 reqs per second.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Remote MySQL 5.0 Hosting
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work. I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem. what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View Replies!
View Related
CPanel Remote MySQL
just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A. How do we access phpmyadmin? Do you guys experience this?
View Replies!
View Related
Remote / Off Host SQL
I've seen this mentioned before, that you can run SQL on a separate server and lot of people do it for SQL heavy applications. Only thing I wonder, how well does it work bandwidth wise? Is there a noticeable slowdown in query speed? What about bandwidth cost, does it use a lot, enough to run over a typical dedicated server monthly limit? Also what about security, are queries/username/password sent out in clear text?
View Replies!
View Related
Connecting To Remote MySQL Failing
I'm facing some odd issues with 2 servers located in the same datacenter. One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other. The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted. I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View Replies!
View Related
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2. If it is possible it would save me a lot of bandwidth for both servers.
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
Cpanel Mysql Remote Connection USE EXIST DB
A have set up a cpanel with remote mysql server. My demo config: cpanel: centos VPS with cpanel WHM (demo) mysql: debian VPS the configuration is OK, it works. We have got 200 customers, and we will to change to cpanel. The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
View Replies!
View Related
Remote MYSQL (cPanel) Small Error
I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.
View Replies!
View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB. The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2. server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times. server 2 is not very busy, around 30% CPU usage and 0.6 CPU load. Yet, users on server 2 experience *much slower* response times than the ones on server 1. The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1). I was wondering what other reasons it could be. The mysql processlist is weird: Code: mysql> show processlist; +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL | | 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL | | 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL | | 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL | | 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL | | 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL | | 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL | | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | | 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL | | 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL | | 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL | | 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL | | 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL | | 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL | | 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL | | 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL | | 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL | | 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL | | 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL | | 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL | | 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL | | 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL | | 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL | | 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL | | 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL | | 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL | | 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL | | 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL | | 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL | | 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL | | 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL | | 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL | | 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL | | 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL | | 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL | | 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL | | 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL | | 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL | | 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL | | 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL | | 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL | | 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL | | 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL | | 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL | | 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL | | 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL | | 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist | | 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL | | 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL | | 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL | | 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL | | 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL | | 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL | | 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL | | 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL | | 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL | | 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL | | 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL | | 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL | | 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL | | 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * | | 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL | +-------+----------+---------------+----------+---------+------+----------- Why so many sleeping processes from server 2, and none or almost none from server 1 ? Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently? What could be a reason for server 2 having problems to open connections on server 1, and how to solve it? Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View Replies!
View Related
MySQL Remote Connection Problem After A Heavy Usage
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously. Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts). After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
View Replies!
View Related
Failcnt Error #422: Cannot Initialize Connection To Remote Host
my site is working fine for somedays and suddenly its stoped and hanged and also my PPP is not working , and file manager in PPP its give me this error VZAgent returns error #422: "Cannot initialize connection to remote host" and the suppord admin said I have problem in failcnt [root@server ~]# cat /proc/user_beancounters Version: 2.5 uid resource held maxheld barrier limit failcnt 1592: kmemsize 18353610 18355203 65536000 65536000 0 lockedpages 0 0 256 256 0 privvmpages 166455 171964 262144 262144 119810 shmpages 4885 4885 131072 131072 0 dummy 0 0 2147483647 2147483647 0 numproc 150 150 600 600 0 physpages 101554 108439 0 2147483647 0 vmguarpages 0 0 196608 196608 0 oomguarpages 101554 108439 196608 196608 0 numtcpsock 141 141 600 600 0 numflock 7 8 300 330 0 numpty 1 1 16 16 0 numsiginfo 0 1 384 384 0 tcpsndbuf 2350036 2625064 32768000 36864000 0 tcprcvbuf 2310144 2129920 32768000 36864000 0 othersockbuf 32976 573000 32768000 36864000 0 dgramrcvbuf 0 4284 1024000 1024000 0 numothersock 32 32 600 600 0 dcachesize 642510 653661 8192000 8192000 0 numfile 2636 2663 20000 20000 0 dummy 0 0 0 0 0 dummy 0 0 0 0 0 dummy 0 0 0 0 0 numiptent 228 228 700 700 0 I want to know what is my ram site and why that all errors?
View Replies!
View Related
Better Mysql Host
my site is mainly based upon mysql ...mean I need to insert 25-30 mb data everyday .I saw several webhost saying 5 gb space ...does it mean i can store 4.5 gb data in mysql ? lets take that i will use only 0.5gb to store file&codes.
View Replies!
View Related
Best ColdFusion Host W/ MySQL
I've been with CystalTech for a while now. They're descent, but expensive. I've been hearing a lot of good things about HostNexus. A friend is recommending intermedia, but they don't offer MySQL. This is for mission critical stuff, but I can't afford dedicated. The stats don't justify it to the powers that be.
View Replies!
View Related
Mysql And Ms Sql Host
I am trying to find a reliable host that can provide both mysql and ms sql for the same site. I know this is not how the site should be designed, and a complete redesign is in the works to streamline everything to mysql, but for now I need a host that can provide both. Our current host is absolutely horrible (seekdotnet.com) as there is an excessive amount of downtime (typically a few times/day for various periods of time). Thus far the only one I have been able to find is Mosso, but it seems a lot of people on here are anti-mosso, or have had problems with mosso.
View Replies!
View Related
Best Host For ASP/PHP/mySQL
My current web host (SectorLink) has been acting flaky lately so I'm in the market for a My requirements are at least 6GB of space, the ability to run multiple websites on the same account (I'm currently at 7) and ASP, PHP, and mySQL capabilities. I'd also like the price to be competitive with what I'm currently paying ($11/month) though I'm willing to go up a bit. I'm currently looking at 3 hosts, but I'm open to any suggestions. My short list right now includes: HostGator - Not a Windows host, I know (though they're working on Windows plans), but they do offer ChiliSoft ASP capabilities. This host would give me unlimited space and domains for $14.95 per month. AllReseller - This host would give me 50GB of space and unlimited domains for $11.95 a month. Aspnix - This host would give me 10GB of space and 7 domains for $7.77 a month. Has anyone used any of these hosts? What were your experiences with them? Could you recommend any other hosts? Side Question to any classic ASP developers out there: Have you used ChiliSoft ASP and, if so, how good is it at running scripts originally written for IIS?
View Replies!
View Related
Best Host For Legacy Php < 4.47 And Mysql <4.1.21
Looking for linux and the above, on shared or virtual plan. A number of sites will be on the account and can run sites without 'www' . phpmyadmin, real FTP's (non anonymous), SSH/SFTP access, decent uptime, spam filters and support in place. No outsourcing of support, and they house their own servers.
View Replies!
View Related
Shared Host , Reliable Mysql
I know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one. I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc. What I don't like about Dreamhost: a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads). b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership. c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail. What I like about Dreamhost: a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too). b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage. So, who is my next low-cost host? a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this? b) I wouldn't mind moving to a reseller account c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage] d) I'd like to stay in the $10-20ish a month range
View Replies!
View Related
MySQL Host - Max_user_connections Exceeded
I am getting the error "max_user_connections exceeded" for database user "xxxx". So every time this happens I have to feed a new database admin login to my script. There is nothing wrong with the script since it is very popular membership script. I think my host just allows low number of "max_user_connections". please advice me on a host that allows higher number of "max_user_connections"
View Replies!
View Related
Fast UK Host With MySQL Support
I currently run a website which is hosted with storminternet.co.uk and, while I can't fault their reliability, the (lack of) performance is undermining the usefulnes of the website. Key features of the website are: - completely MySQL/PHP driven so the host needs MySQL support and processor power . Some of the MySQL queries are fairly complex and call upon multiple tables of large datasets. - monthly bandwidth is much less of an issue than speed (if that's not an oxymoron) as the number of visitors is currently <250/day. - most if not all of the visitors are from the UK In terms of budget I would be willing to go £150+/year if the service was top quality.
View Replies!
View Related
Best Host For PHP, MySQL Sites
I am reading the BYO Database Driven Website Using PHP and MySQL and I am ready to play around a bit. I was wondering if anyone could recommend a quality provider with this language. I have had problems with some in the past when using Joomla so I am trying eleviate that problem from the get-go.
View Replies!
View Related
Host That Allows MySQL Backup/restore Via FTP
I need to get the h3ll away from Godaddy, fast! However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot. Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy. As to why I need to get away from Godaddy: Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says: "Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us." They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
View Replies!
View Related
PHP And MySQL App To Test Host Performance
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it. What are people's experience on HostGator running PHP and MySQL?
View Replies!
View Related
In Search For Host With Latest PHP/mySQL Versions.
I'm desperately trying to find a hosting service that offers Linux hosting with latest versions of php (5.2.x), mySQL (5.1) and maybe CVS or SVN? Space or bandwidth are not an issue (500mb space will be more than I'll ever need) This will mainly will be a development/testing place. I really need a host that actually updates to latest versions of php/mysql/apache. (not the next day the upgrade is out but some time soon at least >_<) Things like CVS / SVN, SSH access and access to change your own php.ini settings are more than welcome but I could live without.
View Replies!
View Related
Recommend A UK LAMP Host - With Some Specific Mysql Privilege Requirements
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible. So, I need another UK host with: - 2Gb of space (the site serves up big PDF documents) - 70Gb of bandwidth (I said they were big) - mysql privs available as above Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological Ă‚Â£10/month barrier which I don't want to cross.
View Replies!
View Related
Host Recommendation (Req: PHP5, MySQL, CRON, Mass-Email)
any hosts that can provide the following: PHP5.3 + MySQL CRON (to run daily/weekly scripts at a certain time) Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly. In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
View Replies!
View Related
Reliable Shared Host Plan With PHP 5.2.+ With PDO Drivers & MySql 5.+
I switched to HostGator because they had PDO drivers enabled on shared hosting plans with PHP 5 & MySql 5. The problem is that every time they update PHP (4 times in 8 months now) they don’t include PDO in the build and its takes day to get past level 1 support and get it fixed. So I’m looking for a “Reliable” host. I had a hard time when I switched to HG finding shared hosting plans with PDO enabled.
View Replies!
View Related
How Do I Secure Remote Access To Remote Access Products
I have windows servers that I'll be co-locating very soon. I have purchased a Dell 2161ds-2 and an APC remote boot power strip. Could someone please tell me the best way to secure remote access to these products. Do I put them on public IP's and allow them through the firewall or do I put them behind the firewall and access them after I authenticate through the firewall.
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online. how can I get these database files to fully work on a new server?
View Replies!
View Related
How To Keep Email On Current Host And Forward Http Traffic To New Host
I'm configuring a website for a client who has moved their web hosting to downtownhost, but is keeping their email hosting with their current provider. They do not want to configure an MX entry on DTH to autoforward email back to their current provider because they don't want their email to pass through DTH. In order to do this, do I keep the nameserver entries on the current provider the same, and configure an http redirect to point to DTH? Or is there something else I should configure on the current provider?
View Replies!
View Related
Best Host For A Blog Site- Register With 1&1 And Host With Godaddy
with this being my first website goddady's website tonight or there blog site plan seem pretty good as I do not know how to build a professional looking website nor do I have a knowledge of HTML. Are there other hosts that offer better services such as these? Also I would want to register with 1&1 as to register privately is free but with godaddy it costs around $15 and I've heard of godaddy stealing persons domains when they haven't even expired yet i.e. familyAlbum.com? Is it allowed for instance to register my domain name with 1&1 and host my site with godaddy?
View Replies!
View Related
Can I Move /var/lib/mysql To /home/mysql
my /var partition is full, im not sure if any files i can remove to get more free space on /var partition. because there are more free space on /home, i think if i can move all the /var/lib/mysql to /home/mysql, if yes,howcan i move it and do any change, can let the sql data do not lose, andrun well in the feature ?
View Replies!
View Related
|
TRACKER
