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?
how do i switch versions?
I have a server with /var too small, then i move /var/lib/mysql to another location, i've changed in /etc/my.cnf.
Quote:
datadir=/home/mysqldir
socket=/home/mysqldir/mysql.sock
I can start / stop mysql but mysql & eximstats in WHM failed. I've try :
Quote:
mysql -vv
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
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 a problem:
When I try to change a password in my mysql, in confixx control panel I see:
Quote:
Unable to connect to the database
Anyone know the commands to change a MySQL user's password via ssh?
I found stuff for changing the root password, and tried to adapt it for the user, but it didn't work.
How can change mysql root password with ssh access?
View 6 Replies View RelatedHow do I change mass database names in mysql?
I have hundred of database names with "$" in the name? How do I change all instances of "$" with "_"?
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.
View 7 Replies View RelatedI try to change a mysql user password, but I get an error message:
Fehler: attribute name is invalid: status
Search for related Knowledge Base articles
I'm running12.0.18 Update Nr. 39
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?
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
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.
View 5 Replies View RelatedI 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?
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View RelatedI'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?
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 ?
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?
View 6 Replies View RelatedI keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
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.
What do you think? Should I just change his IP?
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?
Anyone got a clue on how to do so?
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.
I have a problem that am not able to connect with mssql_connect() function to MSSql server.
Error is: undefined function mssql_connect().
On local this problem is get solved by uncomment extension=mssql_php.dll and extension=mssql_pdo_php.dll line by removing ";" in front of it.
::But how do i same on the online server?.
::If possible with coding or is thr any other way to do this plz let me know?
::If thr is a way to change .htaccess file to make this change or any better solution with .htaccess..
::If thr ia a way to change the path for php.ini and we put our php.ini file in other folder and access that rather than php.ini on server.
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 ?
View 3 Replies View RelatedI 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.
1. 256meg of RAM.
2. 5-10 gig of space
3. CentOS
4. Control Panel - Have used CPanel
5. Less than 200 gig of bandwidth.
6. 2 IPs.
7. Can use Wordpress MU