I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
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 Replies!
View Related
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
I 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?
View Replies!
View Related
Can I Move /var/lib/mysql To /home/mysql
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 Replies!
View Related
What In /var/lib/mysql/
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?
View Replies!
View Related
/var/log/mysql - Can I Delete It
Question: Is it safe to delete the files in /var/log/mysql ? Also, is there some way I can disable logging so that this folder does not get filled up again? Explanation: Last night I started running a Perl script to process the data contained in some files, and then do a series of INSERTs to put them in a MySQL database. When I checked on it this morning, I found that it was very close to being done, but had locked up. I had trouble doing anything at all, actually, until I realized that 100% of the disk space on my hard drive had now been used. I went to investigate, and I quickly realized that my /var/log/mysql folder was over 120GB! My intuition tells me that this folder is just used to store logs of what MySQL is doing. However, I have no need for these logs, and seeing as they are (unnecessarily) using over 120GB of my hard drive space, I would like to delete everything in that folder. But I'm still fairly new to Linux, and I'm not sure if this is safe. Can I just delete these files? And also, to prevent this from happening again, is there some way I can disable MySQL from creating such enormous log files?
View Replies!
View Related
/var/lib/mysql Out Of Space
Quote: Number of processes running now: 0 070924 15:56:00 mysqld restarted 070924 15:56:00 [Warning] Asked for 196608 thread stack, but got 126976 070924 15:56:00 InnoDB: Started; log sequence number 0 24343504 070924 15:56:00 [ERROR] /usr/sbin/mysqld: Error writing file '/var/lib/mysql/server3.dotcom.sg.pid' (Errcode: 28) 070924 15:56:00 [ERROR] Can't start server: can't create PID file: No space left on device I took this out from the error logs, and realized that the reason why my mysql connections all ended up in error is due to insufficient space left on the device. How am i able to increase the size of it? It is currently taking up 7.2G. I removed a log file that's 2.4MB in size, and i suppose it'll be filled up soon again.
View Replies!
View Related
Odd Files In /var/lib/mysql
The mysql dir on my server seems to fill up sometimes and I see these files that aren't actually DB's. They all vary in size. Quote: u15149596-bin.000001 u15149596-bin.000002 u15149596-bin.000003 u15149596-bin.000004 u15149596-bin.000005 u15149596-bin.000006 u15149596-bin.000007 u15149596-bin.000008 u15149596-bin.000009 u15149596-bin.000010 u15149596-bin.000011 u15149596-bin.000012 u15149596-bin.000013 u15149596-bin.000014 u15149596-bin.000015 u15149596-bin.000016 u15149596-bin.000017 u15149596-bin.index I can remove them and I see no problems with the server after that. Does anyone have any idea what these are? I'm running Plesk 8.0.1
View Replies!
View Related
/var/tmp/mysql.sock Strange Persmissions
I'm running a cpanel box with fedora and cannot connect to mysql from the web (Horde, phpmyadmin, java, etc...). I looked at the permissions for mysql.sock in /var/tmp/ and this is what I found: ?--------- ? ? ? ? ? mysql.sock I've never seen this and am wondering if this is the source of the problem?
View Replies!
View Related
MySQL Monitor Shows MySQL As Offline When It's Not
I'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?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
MYSql Backup From V5 To V4
I am trying to backup and restore a database and seem to be running in to the following errors. ERROR 1005 (HY000) at line 29: Can't create table './tcadmin/tc_bandwidth_type.frm' (errno: 121) Source machine Windows Server 2003 mysql 5.0.11 destination machine RHEL 4.x MYsql 4.1.20 I think it is the way I am backing up the database that is the real problem I have checked the compatibility mode option in the administration panel for backup, run full backup, and lockled the tables and still I get the error. I have done some research and I think there is a command line I need to run to make it compatible with mysql 4.x systems but nothing seems to be right that I am doing. Can anyone here offer some insight to what the problem might be?
View Replies!
View Related
MySQL Backup - How Do You Do It Right
today when the indata1 file got corrupted and I found out that rsync was NOT backing it up. I had thought the rsyncing the life files was good enough and that if I had to restore I could just run mysqlrepair and get everything back. what is the RIGHT way to backup MySQL databases and do I want to somehow get rid of the inoddb stuff?
View Replies!
View Related
Incremental MySql Backup
Does anyone have experience in backing up mysql incrementally? From what I've read in the docs it's possible using the binary logs but I haven't been able to find a good resource on how to make this work. I have a database that is over 5GB. There are a few Myisam tables that are insert/select only and one innodb table that receives updates/deletes/selects/inserts. Ideally I wouldn't have to backup the 5GB every night, I'd prefer to only get the items that have changed. If I could make this work, then I could also get backups more often rather than once a night.
View Replies!
View Related
How To Fix Mysql Backup
I have some NAS storage to do backups to with my dedicated hosting provider. I setup automatic daily backups with WHM to backup the databases and accounts. The server is hosting one site. When it does the backup, it does a mysql dump, and essentially takes the site down for the whole time it is doing the backup because nobody can connect to the database while the dump is happening. Is there a better way to do the backup so that this won't happen, whether it be a different method of backing up to NAS, or just not using NAS at all and using some other method.
View Replies!
View Related
Mysql Backup, 2 Different Sizes Why
Using Cpanel: -I went to backup option and downloaded the database backup. 951kb -I went into phpadmin and checked addrop table. 1.5m Using SSH: command mysqldump -u myusername_usernam -pmypassword myusername_name > /home/name/backupz/name.sql = 949k 3 different sizes, I would figure maybe adding droptables would amount to higher size but the first way and third way i use, how come there is a size difference of 2kb? Which is the right way to backup mysql database safely?
View Replies!
View Related
MYSQL Backup Simple
Any of you know any good mysql backup software that does all the packages for you? meaning, backup the whole shabang with only ssh access? users,dbs, etc? and probably restore it too?
View Replies!
View Related
Backup MySQL Databases On PC
I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC? I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.
View Replies!
View Related
Backup MySQL Intensive VPS
I have two VPS's which run a single MySQL intensive site. The first VPS runs cPanel and has about 50 databases, 200mb each. Second has another 30 databases, of the same size. What would be the best method to backup this website daily? At Current; I use automysqlbackup to backup all the databases at midnight (this crashes the VPS's for about 10 minutes each night). This dumps each one into a zipped file. Then the rsync copies the changed files (forum attachmenets, cpanel changes etc(whole server)) to an off site location. Are there any easier ways to do this? The databases are most important!
View Replies!
View Related
Backup In CPanel/WHM Without Mysql
The automatic backups you can setup in cpanel/whm bundle the entire user account. Is it possible for it to save everything except the mysql databases? I have an account that has databases over 5GB+ and would like to handle backing those up separately.
View Replies!
View Related
Secure MySQL Backup Script
Is there a method of running a back-up script,as root, using MySQL, without passing or storing the root password in the clear? I have tried OpenSSH with a nologin option using certificates, but I still have problems. I need to run it as a cron job every so often, (without specifics) securely. I understand I can use another user, other than root, with read-only, but I need to back up the whole db at once, not specific users db's.
View Replies!
View Related
Backup And Restore Mysql Databases
I have a corrupted VPS, and have some mysql databases on it. I want to backup databases and restore them on the new server. Cpanel service is down on the vps and I cannot transfer accts. Is it possible to do so ? 1- Zip or Tar the username folder in /home dir. 2- zip or tar the database name in /var/lib/mysql folder Either by SSH or File manager trough HyperVM Then transfer files some where safe... When vps is rebuilt, restore the archives and databases to the folders I have backed up before rebuilt. There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them. how to do it and avoid database problems.
View Replies!
View Related
MySQL Backup Multiple Databases
My site is databases driven and runs on around 15 mySQL databases. Im wanting to download a local copy of these databases daily, however, if i try and back them up via cPanel (on a WHM VPS) they give me blank files. Each databases is around 55mb and growing. I can back them up one by one via phpmyadmin, it just takes around 5 minutes per database. Meaning around 40 minutes per night.. Is there any solution for having a script downloading them automatically so i can download them via ftp? I've tried [url].htm but it gives me blank files.
View Replies!
View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ? Quote: # mysqldump gallery > gallery.sql mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES # I checked the table, it is fine, but can't do the backup. Quote: mysql> check table 10tir_user_group; +-------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------+ | gallery.10tir_user_group | check | status | OK | +-------------------------+-------+----------+----------+ 1 row in set (0.07 sec) mysql>
View Replies!
View Related
Backup MySQL Databases By Cron
how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working. Change the commented variables in the following file and save it as backup.sh: Code: #!/bin/sh # This script will backup one or more mySQL databases # and then optionally email them and/or FTP them # This script will create a different backup file for each database by day of the week # i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1) # This is a trick so that you never have more than 7 days worth of backups on your FTP server. # as the weeks rotate, the files from the same day of the prev week are overwritten. #/bin/sh /home/user/directory/scriptname.sh > /dev/null ############################################################ #===> site-specific variables - customize for your site # List all of the MySQL databases that you want to backup in here, # each seperated by a space # If not run by root, only one db per script instance databases="mydbname" # Directory where you want the backup files to be placed backupdir=/home/mydomain/backups # MySQL dump command, use the full path name here mysqldumpcmd=/usr/bin/mysqldump # MySQL Username and password userpassword=" --user=myuser --password=mypasswd" # MySQL dump options dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables" # Unix Commands gzip=/bin/gzip uuencode=/usr/bin/uuencode mail=/bin/mail # Send Backup? Would you like the backup emailed to you? # Set to "y" if you do sendbackup="n" subject="mySQL Backup" mailto="me@mydomain.com" #===> site-specific variables for FTP ftpbackup="y" ftpserver="myftpserver.com" ftpuser="myftpuser" ftppasswd="myftppasswd" # If you are keeping the backups in a subdir to your FTP root ftpdir="forums" #===> END site-specific variables - customize for your site ############################################################ # Get the Day of the Week (0-6) # This allows to save one backup for each day of the week # Just alter the date command if you want to use a timestamp DOW=`date +%w` # Create our backup directory if not already there mkdir -p ${backupdir} if [ ! -d ${backupdir} ] then echo "Not a directory: ${backupdir}" exit 1 fi # Dump all of our databases echo "Dumping MySQL Databases" for database in $databases do $mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql done # Compress all of our backup files echo "Compressing Dump Files" for database in $databases do rm -f ${backupdir}/${DOW}-${database}.sql.gz $gzip ${backupdir}/${DOW}-${database}.sql done # Send the backups via email if [ $sendbackup = "y" ] then for database in $databases do $uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu $mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu done fi # FTP it to the off-site server echo "FTP file to $ftpserver FTP server" if [ $ftpbackup = "y" ] then for database in $databases do echo "==> ${backupdir}/${DOW}-${database}.sql.gz" ftp -n $ftpserver <<EOF user $ftpuser $ftppasswd bin prompt cd $ftpdir lcd ${backupdir} put ${DOW}-${database}.sql.gz quit EOF done fi # And we're done ls -l ${backupdir} echo "Dump Complete!" exit Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone . You should chmod the file to 777: Code: chmod 777 backup.sh If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory: Code: dos2unix backup.sh If you don't have dos2unix installed, you can install it using yum if you have that: Code: yum install dos2unix If you don't have yum, get it here. You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command: Code: ./backup.sh Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is: Code: /path/to/file/backup.sh
View Replies!
View Related
Difference Between --with-mysql And --with-mysql=dir
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?
View Replies!
View Related
Uninstall MySQL 3.23 And Install MySQL 5.0
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
View Replies!
View Related
MySQL Error : MySQL Server Has Gone Away
I 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
View Replies!
View Related
Which Volume For MySQL :: /var Volume Or Is It /home?
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 Replies!
View Related
Host That Allows MySQL Backup/restore Via FTP
I need to get the h3ll away from Godaddy, fast! However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot. Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy. As to why I need to get away from Godaddy: Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says: "Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us." They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
View Replies!
View Related
How To Easiest Do Backup And Transfer Of Mysql Files
I have following problem-i have over 20 sites on server and each site has own database.Is there a way to speed up backup and transfer or other server? Method which i use right now it's following:first i archive entire directory using command tar -pczf name.tar.gz public_html,and then repeat with each directory.But i think i could simply archive all requied directories,but that will took toomuch time,so if i drop connection during archiving it wont be archived at all then.So i think best solution will be to create some kind of batch command which can load in background,so that means command wont stop if client lost connection. So let's say i have 2 sites and two directories located and different places. One is at home/site1 and other at home/site2 So i think i would need to put command into batch file tar -pczf site.tar.gz. /home/site1 and tar -pczf site2.tar.gz /home/site2 Will that work? Also second part,mysql databases,i founded if i login into phpmyadmin as root i can see all databases.I managed to export all databases,but question will import again to phpmyadmin work.I think phpmyadmin create command for each database "if there is no db sitename_mysqlbase,create it",but howmuch i know phpmyadmin have limit with importing size of mysql database.Could that be done with import/export mysql command?
View Replies!
View Related
MySQL Administrator GUI Disappear When Restore Backup On CentOS 5.x
I have some server with OS: CentOS 5.x one day, I have to replicate 2 servers together. so, I have to stop webserver and use MySQL Administrator GUI Tool to backup it. My steps follow: (i work directly on Server 2 and i wantna to use mysql administrator gui to monitor and config replication). 1. Server 2: ssh to server 1-> connect mySQL -> add any host to root access 2. Server 2: use mySQL Administrator connect to server 1 with root 3. Server 2: backup from server 1 on Desktop location 4. Server 2: Restore it use mysql administrator tool. It works well but when i click Restore button, MySQL Administrator GUI Tool disappear! What's problem with this tools or server 2?
View Replies!
View Related
Upgrade From MySQL 4 To MySQL 5
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.
View Replies!
View Related
Upgrade Mysql MySQL 4.1 To 5
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?
View Replies!
View Related
Ugrading From Mysql 4.0.x To Mysql 5.0.x
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
View Replies!
View Related
Used Apache Update/some PHP Scripts No Longer Working
Having some issues here, I used Apache Update to install WHMCS as I didn't have Curl installed. Well had some issues using the username and password as it couldn't connect to the database, my modernbill and phpnuke scripts still work but some other scripts like joomla, some shopping cart software, and other MYSQL scripts are not working. I've run test scripts to see if I can connect to the database, got the following error with the PHP test script Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'data_invoice'@'localhost' (using password: YES) in /home/data/public_html/test2.php on line 4 I cannot connect to the database because:Access denied for user 'data_invoice'@'localhost' (using password: YES) Also attempted it in SSH and getting a similar error that access is denied. Username and password are correct. I believe I upgraded PHP which my guess is what caused this. I've searched the forum for a few solutions and I had the problem in the past which I fixed it, but it's been a while.
View Replies!
View Related
Mysql 4.1 Or 5
i've been using 4.1 without problems but now i'm switching servers and i am wondering whether its a good idea to go for ver 5. How do they compare in terms of performance/security etc? Whats recommended for web use?
View Replies!
View Related
MySQL 5
I have successfully upgraded PHP 4.3.9 to PHP 5.1.6 and MySQL 4.1.20 to 5.0.48 and everything appears to working properly. Couple of questions: 1. Will the databases that were created under 4.3.9 automatically work under 5.0.48? Or do I need to do anything to them? 2. The database information appears to be fine under phpMyAdmin, but I noticed a new database file is now showing. It is named "information_schema". What is this file and is it a new part of MySQL 5.0.48? 3. Does phpMyAdmin 2.6.3 work fine with MySQL 5.0.48? Or do I need to upgrade that as well? And if so, what version works with 5.0.48?
View Replies!
View Related
MySQL
A table in my DB got crashed and I repair it via phpmyadmin it gives me status that its repaired but when I browse it, it says table is marked crashed. I've tried repairing several times,
View Replies!
View Related
Mysql
one of our servers is memory usage is very high and hard to track it down. []# mysqladmin pr +-------+------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+-----------+----+---------+------+-------+------------------+ | 29045 | root | localhost | | Query | 0 | | show processlist | +-------+------+-----------+----+---------+------+-------+------------------+ Loook at the memory usage. ]# free -m total used free shared buffers cached Mem: 1003 988 14 0 20 85 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1262 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:03.83 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1263 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:00.00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1264 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:10.37 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1269 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:25.82 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1339 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:36.99 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1344 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:26.47 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1349 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:41.44 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1397 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:27.28 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1398 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:27.71 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1401 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:37.15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1403 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:20.32 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1410 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:23.28 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1411 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:17.13 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1412 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:16.82 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1413 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:25.30 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 1449 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:31.98 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 11205 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:21.92 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 11219 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:32.17 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 10073 mysql 15 0 290m 51m 1848 S 0.0 5.2 0:09.14 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 10074 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:19.78 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 10075 mysql 16 0 290m 51m 1848 S 0.0 5.2 0:23.84 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/fas 22902 slackers 16 0 30420 20m 2028 S 0.0 2.1 0:23.25 spamd child how to track it down?
View Replies!
View Related
|
TRACKER
