RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump From: Don Read (dread <email protected>)
Date: 08/22/01

On 22-Aug-2001 Jay Paulson wrote:
> I've checked and the ROOT user has access to everything... but still no
> luck.. when i run the mysql -u root -p < 'all_databases.sql' it gets to the
> first table and tries to insert some information into it and says "blah
> table is read only" and it stops...
>

can you drop or create tables ?

If not then your sql daemon permissions are messed up.

stop the daemon, chown -R mysql.mysql /path/to/mysql/data,
restart the daemon.

Regards, 

-- 
Don Read                                       dread <email protected>
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>