RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump
| From: | Don Read | Date: | Thu, 23 Aug 2001 02:59:49 +0000 |
| Subject: | RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-64020@lists.php.net to get a copy of this message | ||
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@texas.net
-- 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.