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'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
I have Mysql installed on my Home server with Java server, and I have php WEB site hosted with Let's say Godaddy or whatever. I need to connect this WEB to my MYSQL. How can i do that?
View 6 Replies View RelatedIs it possible to move my mysql database to another server?
View 9 Replies View Relatedhow 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
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:
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.
how to do this in myphpadmin
also got cpanel if it helps.
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?
to move:
/dev/sda6 1012 506 506 50% /tmp
/tmp 1012 506 506 50% /var/tmp
to /home
and make Symlink or something.
I moved the home directory for apache from /usr/local/apache2/htdocs to /home/username/www
When I go to browse the site, I receive a 403 error, You do not have access to / on the server.
It gave the OK default page for apache before moving so I am assuming it is a permission issue.
What do I need to do? apache is running as the default "daemon" user and group.
On a standard CentOS4 installation do mysql databases get stored in the /var volume or is it /home? Does that mean I need to ask the dedicated server host to create /var really big if I'm expecting my MySQL database to get huge? Or is it better to reinstall MySQL so it puts the databases on the largest volume?
View 3 Replies View RelatedFor 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'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
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'm trying to upgrade from MySQL 4 to MySQL 5 for performance reasons. MySQL 4 was working great so I decided to just go ahead and upgrade to MySQL 5 via CPanel. The upgrade appeared to go fine however I now get this error when trying to start MySQL.
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
I went ahead and did a forced re-install of MySQL 5, but that didn't help. Apache has been updated as well since then, but that did no good, and the MySQL process isn't starting at all.
Its CENTOS with PHP5.
I am not sure what difference between --with-mysql and --with-mysql=/usr to compile php 4.4.7
because I get error message when I use --with-mysql=/usr
the error message is like Mysql header can not be found or similar thing.
it ok when I use --with-mysql
so, I am afraid that can I use php and mysql without problem by using --with-mysql?
I'd like to upgrade my current mysql 4.1 version to mysl 5, but i can't find a good tutorial or explenation! I've been searching for hours now without any good results.
I've downloaded the lastest stable mysql 5 .rpm, and tried to install it with rpm -i mysql.version.rpm, but it says the following:
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
MySQL-server conflicts with mysql-server-4.1.20-1.RHEL4.1.i386
I guess that means i have to uninstall mysql 4.1 first.
ok...
# rpm -e mysql-server-4.1.20-1.RHEL4.1.i386
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Let's try to install it now.
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
Ok, let's remove that.
# rpm -e mysql-4.1.20-1.RHEL4.1.i386
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-devel-4.1.20-1.RHEL4.1.i386
Does upgrade work?
# rpm -Uvh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
Clearly not.
How do i upgrade mysql?
I have a big issue importing 4.0 databases with mysql 5.0.27.
I did a mysqldump -pxxxxx --force --all-databases > file.sql on server with mysql 4.0
But when I tried to import the file on server with mysql 5.0, this is what I got:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
I even tried to force import and I got:
ERROR 1046 (3D000) at line x: No database selected for every database.
I checked sql file and CREATE DATABASE xx and USE xx were both added.
I tried this with a single database and worked but with all not
loading a phpinfo() shows that the mysql variable "Client API version" on my server doesn't match the version of mysql installed ( 4.0.20 when mysql version is 4.1.21).
Can this cause trouble and php or mysql errors on scripts i'm running?
What are the files in this directory - /var/lib/mysql/
Files like
#sql_2a6c_0.MYD
#sql_2a6c_2.MYD
etc
etc
I have a stack of them all 200MB plus in size
I need to cleanup /var as its 99% full, what else can I clean up?
MySQL 5.1 GA
Has anyone tried to migrate already?
