Results 1 to 11 of 11
-
12-26-2005, 10:26 AM #1Aspiring Evangelist
- Join Date
- Aug 2004
- Posts
- 417
WHM account transfer: MySQL error
Hello,
I'm trying to move all accounts from one server to another. However I'm getting the next errors when it tries to transfer the accounts:
/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!
Grabbing mysql dbs............
DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 40
Can't call method "prepare" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 724.
DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 40
Can't call method "prepare" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 502.
Done
Grabbing mysql privs...DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 40
Done
Copying mailman lists....Can't call method "prepare" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 724.
Done
Thanks
-
12-26-2005, 11:51 AM #2Hosting provider
- Join Date
- May 2002
- Location
- Moscow
- Posts
- 1,602
this mean that your mysql server just not work (even if you see his process in top). you should check error log filr for your mysql server (usually it is located in /var/lib/mysql anbd called as your-hostname.err
TK Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR
-
12-26-2005, 12:19 PM #3WHT Addict
- Join Date
- Nov 2005
- Posts
- 109
Make sure you tranfers between 2 server with same Mysql version . If not Upgrade Mysql before tranfers . Check some module install between 2 servers are same . Note : Tranfers manual if your's account bigger 500MB .
-
12-26-2005, 12:44 PM #4Disabled
- Join Date
- Oct 2005
- Posts
- 515
make sure MySQL is running on the server. Run:
/var/lib/mysql/bin/mysqld_safe &
what does that show?
-
12-26-2005, 02:30 PM #5Aspiring Evangelist
- Join Date
- Aug 2004
- Posts
- 417
Originally Posted by FirmbIT
root@server [/tmp]# /var/lib/mysql/bin/mysqld_safe &
[1] 14017
-bash: /var/lib/mysql/bin/mysqld_safe: No such file or directory
root@server [/tmp]# locate mysqld_safe
/usr/share/man/man1/mysqld_safe.1.gz
/usr/bin/mysqld_safe
[1]+ Exit 127 /var/lib/mysql/bin/mysqld_safe
root@server [/tmp]# /usr/bin/mysqld_safe &
[1] 18624
root@server [/tmp]# A mysqld process already exists
[1]+ Exit 1 /usr/bin/mysqld_safe
root@server [/tmp]
Number of processes running now: 1
mysqld process hanging, pid 32642 - killed
050929 22:36:25 mysqld restarted
050929 22:36:25 Warning: Asked for 196608 thread stack, but got 126976
050929 22:36:25 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.25-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
051226 17:15:56 mysqld started
051226 17:16:03 Warning: Asked for 196608 thread stack, but got 126976
051226 17:16:24 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.25-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
A mysqld process already exists at Mon Dec 26 17:16:47 GMT 2005
I'll try to upgrade the MySQL servers now.
-
12-26-2005, 02:33 PM #6Aspiring Evangelist
- Join Date
- Aug 2004
- Posts
- 417
I checked phpMyAdmin on both servers and they both say:
MySQL 4.0.25-standard running on localhost as root@localhost
-
12-26-2005, 02:59 PM #7WHT Addict
- Join Date
- Nov 2005
- Posts
- 109
Why you don't download folder /var/lib/mysql/folderxxx and move to new server
-
12-26-2005, 04:24 PM #8Newbie
- Join Date
- Dec 2005
- Location
- Planet Earth
- Posts
- 24
Originally Posted by HoangJav@When you say "I wrote a program that crashed Windows", people just stare at you blankly and say "Hey, I got those with the system, *for free*".
-
12-27-2005, 10:21 PM #9Aspiring Evangelist
- Join Date
- Aug 2004
- Posts
- 417
Originally Posted by WebScHoLaR
But I already have accounts on the server to which I want to move the accounts to. Won't that overwrite anything?
Edit: also, can't I just symlink the mysql.sock file to /var/lib/mysql/mysql.sock? The file exists but not in that directory...
-
12-27-2005, 10:31 PM #10WHT Addict
- Join Date
- Nov 2005
- Posts
- 109
it does'nt problem . a folder in /var/lib/mysql/ is a database you had been create . You can move some databases to new server don't overwrite if have an exits . If you have any folder is same name between 2 server you can't conpy by WHT too . That's why Cpanel create database with name account_name .
-
12-29-2005, 10:17 PM #11Aspiring Evangelist
- Join Date
- Aug 2004
- Posts
- 417
Ok thanks. Will this also solve this issue:
Copying mailman lists....Can't call method "prepare" on an undefined value at /usr/local/cpanel/Cpanel/Mysql.pm line 724.
Done