transferred my DB files to new comp, but now tables are read only...

[spewn]

here is the code i'm using:

$dbh9 = DBI->connect('dbi:mysql:gtc','','');
$sth9 = $dbh9->prepare("INSERT INTO orders VALUES(0,'orderDate','no')");
$sth9->execute;
$orderNumber = $dbh9->{'mysql_insertid'};

this was working fine on the original box, and i'm able to access the table data, but i'm unable to insert or alter the table. i went to the actual table in mysqlcc and tried to delete the info in the table, and that's how i found out the files are read only.

i tried checking the permissions for users and found that they both have full permissions and grant option is checked.

still no go.

any ideas?

- g

 

[sleipnir214]

Did you simply copy the database files from one machine to the other? If so, you need to tweak the ownership and permissions of the files. Just compare them to database directories and table files that were created on that system and match them.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[spewn]

thanks. late last night i decided to check the actual files that i transferred and that's where i found the 'read-only' status. after unchecking the box, the site worked fine.

thanks for your help!

- g