need some mysql help here - GoFuckYourself.com

alex79 · 02-21-2006, 10:34 AM

i've copyed the files of a mysql database from a server to another (server1: /var/lib/mysql/database/files to server2: /var/lib/mysql/database/files)

i can access the database on the new server but all the tables are read only.. i made a chown mysql /var/lib/mysql/database/files and chmod 777 /var/lib/mysql/database/files but all tables are still in readonly format.. what do i have to do so i can have full access on the database on the server2?

thanks

Baker Rd · 02-21-2006, 11:06 AM

Did you copy the files while mysql was still running? That would be why they are read-only. You should stop the mysql service before copying database files.

You can also try doing a FLUSH TABLES.

com · 02-21-2006, 11:08 AM

make sure the group setting is correct chown user:group or chgrp

FuqALot · 02-21-2006, 11:09 AM

Try to see if the mysql account you're using has enough permissions to write.

MickeyG · 02-21-2006, 11:46 AM

wouldn't it have been better/easier to use mysql dump?

GFX Wiz · 02-21-2006, 11:51 AM

Quote:

Originally Posted by MickeyG

wouldn't it have been better/easier to use mysql dump?

That's my thought too

mikesouth · 02-21-2006, 12:03 PM

exactly...why would you copy files?

export and import the database....thats the only reliable way to do it...mysql keeps its system catalogs in tablescopying files is a sure way to get those ginked up.

02-21-2006, 10:34 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	need some mysql help here i've copyed the files of a mysql database from a server to another (server1: /var/lib/mysql/database/files to server2: /var/lib/mysql/database/files) i can access the database on the new server but all the tables are read only.. i made a chown mysql /var/lib/mysql/database/files and chmod 777 /var/lib/mysql/database/files but all tables are still in readonly format.. what do i have to do so i can have full access on the database on the server2? thanks __________________

02-21-2006, 11:06 AM	#2
Baker Rd Confirmed User Join Date: Nov 2005 Posts: 647	Did you copy the files while mysql was still running? That would be why they are read-only. You should stop the mysql service before copying database files. You can also try doing a FLUSH TABLES. __________________ money talks and bullshit walks.

02-21-2006, 11:08 AM	#3
com Confirmed User Join Date: Aug 2003 Location: Portland, Oregon Posts: 4,541	make sure the group setting is correct chown user:group or chgrp __________________ Real. Professional. Hosting. .:Expect Nothing Less:. 320-078-843 :: www.realprohosting.com :: [email protected]

02-21-2006, 12:03 PM	#7
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	exactly...why would you copy files? export and import the database....thats the only reliable way to do it...mysql keeps its system catalogs in tablescopying files is a sure way to get those ginked up. __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

02-21-2006, 11:09 AM	#4
FuqALot Confirmed User Join Date: Dec 2001 Location: Malibu Posts: 3,817	Try to see if the mysql account you're using has enough permissions to write.

02-21-2006, 11:46 AM	#5
MickeyG Confirmed User Join Date: May 2004 Location: South Florida Posts: 4,134	wouldn't it have been better/easier to use mysql dump?