I'm not sure I really understand the ins and outs of upgrading MySQL and I'm afraid to mess it up. From the MySQL site I see there's a 4.1.22 RPM available [url] and I'm running 4.0.18 (Your MySQL connection id is 2763253 to server version: 4.0.18-Max-log)
I'm not sure I want to bump it up all the way to 5, but I would like to run 4.1, but I also would like to stick with the RPMS, even after reading whatever I can find, I'm still not sure I understand what RPMs to install, here's what I have currently.
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now.
After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process
I am moving from a VPS to a dedicated server - both have root access.
I have two hard disks, and I would like to move all of my MySQL data onto the second drive. My dilema is this; what is the best way to go about doing this? The tutorial I followed last night had me use cp to copy the /var/lib/mysql folder over to the second drive. However, it took ages to move one of my databases. It's a forum hosting database which has tons and tons of tables. It ran for about 5 hours and still didn't finish because I decided to stop it right there. I know it was working; but still, it took forever and I had to put it back up.
What would you do? Do you recommend say, copying just the 'mysql' database that has the users, and then taking a dump of all databases with mysqldump and moving it that way?
Also, is there any way using the cp command to continue what I started last night, but not write a database file if it hasn't chnaged at all?
After 2 years of application hosting on ixwebhosting.com i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.
Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.
I now need to sireously move to a VPS / Dedicated server or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.
The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.
I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.
Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.
I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.
I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:
Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.
looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.
I upgrade my 1and1 server and I need some help here. I need to install Latex, I downloaded the RPM and it has many dependencies. Once I install a dependancy it asks for more dependencies... What is the easiest way to install an RPM and all its dependencies.
This is a bit off topic but I am looking for a person kind enough to test install a few RPM packages on an AMD 64 bit system with a 64 bit OS (Fedora or otherwise), preferably an Opteron but not required. The RPMs in question are IBM's DaCS which is something designed for a supercomputer yet to be created. We have one part of the DaCS model but oddly enough, we don't have any AMD systems (tons of high end Intels however).
On Intel machines, after installing these RPMs, the binary that is to be run (/usr/sbin/hdacsd) fails with a "Floating point exception" so I'd like to find out if this is an issue caused by a 3DNow optimizations to these RPM binaries (Intel does not support 3DNow) or something else.
I've put up the RPMs at [url] and the main one to be installed is dacs-hybrid-3.0.0-7.x86_64.rpm
After installation, run hdacsd (possibly in /usr/sbin) and tell me if you get the floating point exception.
I am trying to install some packages on my system and sometimes they depend on different, sometimes earlier, sometimes later versions of library packages on my system.
In that situation is it better to get the source for the package and recompile it with what you have on your system?
I am assuming that the dependent libraries the packages where compiled with were what was available on the package developer's system and do not necessarily contain new features lacking in the older versions.
Will recompling such packages from the source rpms fix the problems in most cases?
One particular group I persistently come across is the libcX.so libraries.
---> Downloading header for syslinux to pack into transaction set. [url] : [Errno 14] HTTP Error 404: Not Found Trying other mirror. [url]: [Errno 14] HTTP Error 404: Not Found Trying other mirror. [url]: [Errno 14] HTTP Error 404: Not Found Trying other mirror. [url]: [Errno 14] HTTP Error 404: Not Found Trying other mirror. Error: failure: RPMS/syslinux-3.62-1.el5.rf.i386.rpm from rpmforge: [Errno 256] No more mirrors to try.
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?
I have a reseller account with 20 or so accounts using WHM. I now have my own dedicated server loaded with WHM. I want to move the accounts to the new server, but WHM asks for the reseller server's root pass which of course I don't have.
I guy I knew transfered 1 account a few weeks ago, with the information I gave him. Unfortunately, I can't get back in touch with him.
How do I move these accounts?
I have my WHM access on my dedicated server. I have my reseller WHM access on my reseller server, but not root access on that server.
i run a vbuletin forum, right now i am on a virtual dedicated
All my ips are stored on the same root ip, i am moving one of my forums from the default IP to a separate IP. I populated the DNS and my webite shows up properly on the new IP, but my forum is comming up as a database error.
Does anyone know what I can do to fix the problem? Or tools I can run? Or is it merely not connecting to the database yet, because of some name server or other issue?
I'm with Dreamhost right now.. got in on a cheap deal years ago. I've been too lazy to keep myself at the best host, but my friend keeps telling me to move over to Host Gator?
Should I? I'm just on one of the shared hosting plans. I run a Wordpress blog I find to be extremely slow on Dreamhost. Maybe I customized it too much or maybe they just totally oversell CPU resources. Do you think it would be wise to move over and expect an improvement?
I just moved a website I took over to a new host. The programmer hard-coded the DB in. The old code refers to the mediatemple address:
mysql_connect("internal-db.s5363.gridserver.com", "db5363", "-removed-") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db("db5363_bb", $link)
how I can configure this for the new (CPanel) IGX Host server?
I'm going to be moving to a new server soon. Does anyone have a list, or recommended reading describing what one needs to do when moving to a new server?
I can't seem to find any info on this.. probably because i'm not wording it correctly
What is the best hosting solution for a $600k/year company needing 100% uptime email and a simple (no forums or ecommerce) website?
The company does not need huge volumes of disk-space or bandwidth so a dedicated server seems to be overkill. That said, a $20/month shared package seems cheap.
