i have a dedicated server, (free hosting company) that most of my clients use free forums that arent compatible for mysql5 so i need the latest version of mysql4
can i just install mysql 4 too?
Where do i change the language of mysql(4.0) i have WHM on a centos 5 box i checked that the current path is /usr/share/mysql/spanish and it must be /usr/share/mysql/english is there any way to do this?
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
I have a client on a dedicated IP, today we needed to downgrade the web hosting plan. As the web hosting plan puts users on a default shared IP, this plan change also changed the dedicated IP to the shared one causing some propagation issues for a small period of time.
I have contacted WHMCS about this asking if they had a way of changing the clients plan but keeping the IP address intact as this could lead to some very undesirable outcomes. They explained that it is not their fault and to contact Parallels.
I know I can change the plan directly in Plesk however by initiating the plan change via WHMCS, everything is automated.
Has anyone helped clients transition from one domain to another? Maybe dissolving a partnership or renaming their company... so a new domain name has been registered and a new website created.
2 Issues:
#1 Using .htaccess 301 redirect We used the following command line in their old website's htaccess file
Redirect 301 / [url]
The goal was to get people try to visit any page of their old website (i.e. OldWebsite.com/contact.html) redirected to their new website (i.e. NewWebsite.com/contact.html). Isn't that supposed to change the address bar's URL, too? For some reason, I visit their old site and I seem to be redirected to their new website but the address bar still has their old domain name? Something is going on???
#2 Having their new company name for 2 years now. People can enter her new company name in Google, MSN or Yahoo. Her new company name appears in the search results but has the old domain name associated with it. We are trying to get rid of any reference to that old domain name? What's the easiest way to do this? So what people see in search engines is:
New Company Short Meta Description www.OldDomain.com
What steps did I miss in this transition?
What steps do I have to take on their old website/old web server to control it's appearance on search engines and make sure people get to the new website?
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?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
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?
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line: shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0: shell> rpm -i MySQL-server-VERSION.i386.rpm shell> rpm -i MySQL-client-VERSION.i386.rpm
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
A client of mine just recently asked for a new IP. His subscription near to expiry date.
He considering to renew but only will renew if I can give him a new IP. Not to buy another but instead a new IP to replace the old one. If it helps, he use the vps of his to run proxy, a socks proxy perhaps.
I am familiar with proxies and have quite an experienced running several group of successful proxies thus asking for an IP probably means his old IP is more than 50% blocked.
We are moving to a new rack at our DC. Now the IP addresses will change. BUT.. we have a mailserver running, and all users are pointed at the current name "mailserver.domain.com" which itself is pointing to the old IP.
So far so good...
BUT we need to move that server to the new rack, and so we need to change the IP. But if we change the IP in the DNS, it will take till 24 hours for all the providers to propogate the new IP. For those users, the mailserver will be offline.
How can we fix that properly? So that no-one has any serious downtime?
root@linux [~]# lynx -dump [url] Your ip is: 10.20.30.40 i want to change this ip to: 10.20.30.41 when i execute: lynx -dump [url] i dont know how to do it.
One of my clients are wanting to use a 3rd party spam screening service, which is supposed to only require a change of their MX entry, but it's not working for me.
When I change the MX, and send a message to the account, I get the following message kicked back at me.
Quote:
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:
receiver@theirdomain.com SMTP error from remote mail server after RCPT TO:<receiver@theirdomain.com>: host mail.mailroute.net [199.89.0.201]: 554 5.7.1 <receiver@theirdomain.com>: Relay access denied
------ This is a copy of the message, including all the headers. ------
Return-path: <me@mydomain.com> Received: from d142-179-125-92.bchsia.telus.net ([142.179.125.92]:62140 helo=WorkLaptop) by server.mydomain.com with esmtp (Exim 4.63) (envelope-from <me@mydomain.com>) id 1HAZU5-0000Rk-8c for receiver@theirdomain.com; Fri, 26 Jan 2007 16:23:49 -0600 From: "Work" <me@mydomain.com> To: <receiver@theirdomain.com> Subject: Test Date: Fri, 26 Jan 2007 14:23:49 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01C74155.999394C0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AcdBmJ0b1GRT8lMDSveqOjg5CgqmkA==
This is a multi-part message in MIME format.
I know this has something to do with my mail server only trying to send the message once, and not again. I'm setup with RHEL w/cPanel.
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
i have changed the nameservers in one of my domains and now on it is loading from new server but only when i type mydomain.com.. When i type www.mydomain.com my site stills loading for the old server...it have passed 12 hours from the time i made the change...it is something else i must do to have my site also available from the new server when someones type www.mydomain.com ?
I am teetering on the edge of over using my shared account and have decided it is time to move on to a VPS. This has been a long time coming, but the economy has held me back and now I am running out of options. I have looked at several hosts and just wanted some recommendations. Since this is the first time to run a VPS, I assume a managed VPS is better for me. I am currently looking at KnownHost.com and VPS.net since they are both well reviewed here. I would just like recommendation on what to consider based on my wants.
I do not need much horse power behind the server as I have just pushed passed 20meg of ram at my current host; about max for them. I need a LAMP setup (PHP5, MySQL 5) for 4-5 sites of which only two get any real traffic, the others are just family blogs.
So this is what I think I need, please feel free to make suggestions on hosts or other considerations.