MySQL Help

**DarkElf** · 08-30-2005 09:16 PM

I'm moving sites from a busted server. I can get the sites themselves to move correctly, but due to mysql not working correctly on old server, cannot get the tables from databases moved. I have the mysql backup tzr.gz file, but not siure how to get it into place witrh correct permissions, etc?

Can someone please help?

**ecwebtechie** · 08-31-2005 01:36 AM

all the files and directories under the directory

/var/lib/mysql

should be owned by mysql.mysql

once you copy the files from the old server.. restart your mysql in the new server before you try accessing any db. you might get 127 storage error.

**AndyReed** · 08-31-2005 04:55 AM

Use scp command to transfer the zipped file from the old to the new server.

**Murtaza_t** · 08-31-2005 10:32 PM

I think the best way is to get the dump of database (.sql file)
Transfer them with ftp and restore it. This has always worked for us...
you may find it difficult restoring .tar.gz files unless to are wel known to Linux.

LinkBack

Thread Tools

MySQL Help

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Remote MySQL and /var/lib/mysql/mysql.sock

Mysql fails with Can't connect to local MySQL server through socket '/var/lib/mysql/m

Fix: Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock'(2)