How Do I Move MySQL From 4.0 To 4.1 With RPMS
Apr 4, 2007
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.
Code:
>> rpm -qa | grep -i mysql
php-mysql-4.3.11-1.1.rhel3.ct
MySQL-shared-compat-4.0.18-0
MySQL-Max-4.0.18-0
libdbi-dbd-mysql-0.6.5-5
MySQL-server-4.0.18-0
perl-DBD-MySQL-2.1021-4.EL3
MySQL-python-0.9.1-6
MySQL-client-4.0.18-0
MySQL-devel-4.0.18-0
There doesn't seem to be anything newer on the up2date server I use:
Code:
>>up2date --showall | grep -i mysql
MySQL-python-0.9.1-6.i386
libdbi-dbd-mysql-0.6.5-5.i386
mod_auth_mysql-20030510-2.ent.i386
mysql-3.23.58-16.RHEL3.1.i386
mysql-bench-3.23.58-16.RHEL3.1.i386
mysql-devel-3.23.58-16.RHEL3.1.i386
mysql-server-3.23.58-16.RHEL3.1.i386
perl-DBD-MySQL-2.1021-4.EL3.i386
php-mysql-4.3.2-39.ent.i386
qt-MySQL-3.1.2-14.RHEL3.i386
View 5 Replies
ADVERTISEMENT
Apr 15, 2009
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 14 Replies
View Related
Apr 21, 2008
Is it possible to move my mysql database to another server?
View 9 Replies
View Related
May 24, 2007
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 2 Replies
View Related
Jun 20, 2008
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.
View 11 Replies
View Related
Jul 12, 2007
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?
View 8 Replies
View Related
Mar 21, 2008
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:
1. inmotionhosting VPS.
2. rackforce.com DDS.
3. Iweb.com
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.
View 16 Replies
View Related
Oct 2, 2007
how to do this in myphpadmin
also got cpanel if it helps.
View 5 Replies
View Related
Oct 17, 2007
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.
View 6 Replies
View Related
Apr 8, 2008
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.
View 1 Replies
View Related
Mar 12, 2007
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.
View 0 Replies
View Related
Mar 4, 2008
I keep getting stuck here....
PHP Code:
---> 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.
View 1 Replies
View Related
May 8, 2009
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..
View 4 Replies
View Related
Jan 21, 2007
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 1 Replies
View Related
Jan 17, 2007
how can i move db from old server to new server using SSH?
(both of server are UNÝX )
View 4 Replies
View Related
Oct 7, 2007
Have any one got any script to genrate cp move backup on remote FTP , but it should also have date in filename on which backup was genrated
View 5 Replies
View Related
Jul 31, 2007
i'm wondering if i want to move from a company to another
if i have a files with approx 4gb to 6 gb files
is it safe to transfere my files from a vps to another?
i have 4 acounts in my VPS
View 12 Replies
View Related
Oct 5, 2005
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.
View 4 Replies
View Related
Jun 1, 2009
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?
View 4 Replies
View Related
Oct 29, 2009
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?
View 14 Replies
View Related
Jun 25, 2009
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?
View 2 Replies
View Related
Sep 22, 2008
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
View 3 Replies
View Related
Dec 16, 2008
i buy a vps with hypervm and xen on some provider.
now i have a dedicated server and i set it as vps node.
hot to transfer it?
View 4 Replies
View Related
Aug 15, 2008
way to move vps accounts from a node, without root access, to a new dedi.
have hyper vm and haven't done a move of this type before.(without root)
View 7 Replies
View Related
Apr 19, 2008
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.
View 4 Replies
View Related
