Recently one customer asked if he could upload his MySql database to subfolder in his root and have MySql pick it up from there instead from default location.
This sounds crazy, but request is legitimate, and I was wondering what could be done to enable this user update MySql db this way, or what would be the closest alternative?
i would like to update my CentOS Linux 5 but i don't want to update mysql and apache i need to use mysql 4. When i entered yum update i can see Total download size: 245 M i can see mysql i386 5.0.45-7.el5 base 4.1 M
how can update my server without updating mysql and apache
I finally broke down and just got a cPanel license to fix my multiple account problems, and had it installed... But now I have a problem that I can't seem to fix - MySql won't update to 4.1.21, its stuck at 4.1.18 which means I can't use PHP 5+... I can't update to MySQL 5.0+ because my databases (Which I have yet to move over) are 4.1 and should probably stay 4.1 until I know for sure it won't break anything.
Does anyone know whats going on and how I can fix this? I've tried "/scripts/mysqlup" and "/scripts/upcp --force", as well as Apache update in WHM, and manual cPanel update in WHM.
Heres what it says when I use mysqlup:
Quote:
MySQL Setup Script Version 7.0
This is the MySQL installer for OS FreeBSD
mysql-client-4.1 (4.1.18_1) is already installed.
mysql-server-4.1 (4.1.18_2) is already installed.
Install Complete
I run a wordpress blog with apache2+mysql5+php5 in a Debian vps with 1024mb ram (plus swap).
When you read the website everything works quick and smooth, but when you have to add data to the database (edit posts, write posts, write comments) something weird happens.
monitoring the system with the top and I see that, for example, as soon as an article has been posted (already got the "article posted" message in the page) the free ram goes suddenly down (some seconds) from 800mb to 0. Swapping starts and the website stops responding. in the meanwhile cpu "wa" goes high (90%++).
Typing ps aux I can see that is not mysql process's fault, actually it seems more that it's apache to cause this ram hogging, in fact an apache restart brings back tons of free ram.
this is my current my.cnf:
Code:
client]
port= 3306
socket= /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket= /var/run/mysqld/mysqld.sock
nice= 0
[mysqld]
#
# * Basic Settings
#
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
language= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address= 127.0.0.1
#
# * Fine Tuning
#
myisam_sort_buffer_size=64M
max_connect_errors=20
connect_timeout=15
interactive_timeout=100
join_buffer_size=1M
sort_buffer_size=1M
read_buffer_size=1M
bulk_insert_buffer_size=16M
key_buffer= 64M
max_allowed_packet= 16M
thread_stack= 128K
thread_cache_size= 8
max_connections = 600
table_cache = 256
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id= 1
#log_bin= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
#expire_logs_days= 10
#max_binlog_size = 100M
#binlog_do_db= include_database_name
#binlog_ignore_db= include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
I am using Parallels panel 11.5.30 Update #44 on CentOS 6.5 (64bit version) located on VPS. What is the easiest way to update:
- PHP 5.3.3 to PHP 5.5.12 (current stable version) and
- MySQL 5.1.73 to MySQL 5.6.18 (current stable version).
Is it possible to update these from Plesk's control panel?
Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies View RelatedAfter installing Plesk 12.0.18 Update 43 on windows when I try to connect to Plesk Panel (https://myurl.com:8443/) I get error:
ERROR: PleskMainDBException: Host '127.0.0.1' is not allowed to connect to this MySQL server (db.php:435)
I tried to reset mysql admin password as described in article - with no luck : [URL] .....
I even tried to reset password:
%plesk_bin%plesksrvclient -set "newpassword" true
Again I get "Faild to connect to database: Host '127.0.01' is not allowed to connect to this mySQL server
All websites that uses mySql works but Plesk Panel is dead?
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?
I get the following error, when I run 'yum update':
Quote:
[root@moloko ~]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www2.atomicorp.com
* base: mirrors.usc.edu
* updates: mirrors.serveraxis.net
* addons: styx.biochem.wfubmc.edu
* extras: mirrors.gigenet.com
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package file.i386 0:4.17-15.el5_3.1 set to be updated
Traceback (most recent call last):
File "/usr/bin/yum", line 29, in ?
yummain.user_main(sys.argv[1:], exit_code=True)
File "/usr/share/yum-cli/yummain.py", line 229, in user_main
errcode = main(args)
File "/usr/share/yum-cli/yummain.py", line 145, in main
(result, resultmsgs) = base.buildTransaction()
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 647, in buildTransaction
(rescode, restring) = self.resolveDeps()
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 704, in resolveDeps
for po, dep in self._checkFileRequires():
File "/usr/lib/python2.4/site-packages/yum/depsolve.py", line 939, in _checkFileRequires
if not self.tsInfo.getOldProvides(filename) and not self.tsInfo.getNewProvides(filename):
File "/usr/lib/python2.4/site-packages/yum/transactioninfo.py", line 414, in getNewProvides
for pkg, hits in self.pkgSack.getProvides(name, flag, version).iteritems():
File "/usr/lib/python2.4/site-packages/yum/packageSack.py", line 300, in getProvides
return self._computeAggregateDictResult("getProvides", name, flags, version)
File "/usr/lib/python2.4/site-packages/yum/packageSack.py", line 470, in _computeAggregateDictResult
sackResult = apply(method, args)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 861, in getProvides
return self._search("provides", name, flags, version)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 43, in newFunc
return func(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 837, in _search
for pkg in self.searchFiles(name, strict=True):
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 43, in newFunc
return func(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 586, in searchFiles
self._sql_pkgKey2po(rep, cur, pkgs)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 470, in _sql_pkgKey2po
pkg = self._packageByKey(repo, ob['pkgKey'])
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 413, in _packageByKey
po = self.pc(repo, cur.fetchone())
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 68, in __init__
self._read_db_obj(db_obj)
File "/usr/lib/python2.4/site-packages/yum/sqlitesack.py", line 94, in _read_db_obj
setattr(self, item, _share_data(db_obj[item]))
TypeError: unsubscriptable object
I have two packages in Centos 5.3 that refuse to update via YUM. Coreutils and Findutils.
coreutils.i386 0:5.97-19.el5
findutils.i386 1:4.2.27-5.el5
The error code returned is:
error: unpacking of archive failed on file /usr/bin/find: cpio: rename
error: unpacking of archive failed on file /bin/ls: cpio: rename
I checked that the files are not immutable via chattr and that I am logged in as root. The directory is also writeable.
I can't remove them or change their permissions.
Any idea on how to force an upgrade? I checked with the support at Cpanel but they had no idea how to fix it and were less than helpful.
root@server[~]# yum install fileutils
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* extras: mirror.fdcservers.net
* updates: mirror.fdcservers.net
* base: pubmirrors.reflected.net
* addons: chi-10g-1-mirror.fastsoft.net
Excluding Packages in global exclude list
Finished
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package coreutils.i386 0:5.97-19.el5 set to be updated
--> Processing Dependency: findutils for package: coreutils
--> Running transaction check
---> Package findutils.i386 1:4.2.27-5.el5 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved ...
I am researching how to upgrade my server, I have already tested #yum update and seen all the patches and upgrades that could be made for my server. My question is that by upgrading all these (mysql, php, etc) do i need to backup all my mysql databases or should the upgrade not affect my databases?
View 1 Replies View RelatedI just did yum update and got this error:
There are unfinished transactions remaining. You mightconsider running yum-complete-transaction first to finish them.
how can i update my host files on my 2nd server
running as ns2 when i change something on the ns1 server?
using BIND DNS, centos, webmin.
Did anyone have this problem when upgrade to PHP 5.2.8?
This is the error that i got when i upgrade from PHP 5.2.6 to 5.2.8.
"Failed loading C:PHP5ioncubeioncube_loader_win_5.2.dll PHP Warning: PHP Startup: Unable to load dynamic library './ext/php_mssql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './ext/php_msql.dll' - The specified module could not be found. in Unknown on line 0 "
I don't have Ioncube install and when i upgrade from PHP 5.2.5 to 5.2.6. I didn't have the above problem. Is Ioncube a included .dll in for the Windows package? How do i fix the above error? Is there any problem with PHP 5.2.8? Is it stable?
My server is Win2003 Standard/IIS6.
i installed APF ( firewall ) in my dediated server 2 years ago. i want to update my APF to new version,
Current Version : APF version 0.9.6
how to update to last version?
I tried to update packages by yum and got this message:
Error: djbdns-localcache conflicts with bind
I installed QmailToaster from this url:
[url]
and I replaced bind with djbdns-localcache*.rpm.
Seems it causes the problem.
What should I do now?
I'm trying to update my vps box using centos distro.
but i got this error.
Code:
---> Package libgcc.i386 0:3.4.6-8 set to be updated
--> Running transaction check
--> Processing Dependency: glibc-common = 2.3.4-2.25 for package: glibc-dummy-centos-4
--> Processing Dependency: libcap.so.1 for package: nscd
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for libcap to pack into transaction set.
libcap-1.10-20.i386.rpm 100% |=========================| 4.4 kB 00:00
---> Package libcap.i386 0:1.10-20 set to be updated
--> Running transaction check
--> Processing Dependency: glibc-common = 2.3.4-2.25 for package: glibc-dummy-centos-4
--> Finished Dependency Resolution
Error: Missing Dependency: glibc-common = 2.3.4-2.25 is needed by package glibc-dummy-centos-4
running centos 4.4.
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 Related