Re: restoring mysql db after mysqldump

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... jay ----- Original Message ----- From: "Rick Emery" <remery@excel.com> To: "'Jay Paulson'" <jpaulson@lbjs.com>; <php-db@lists.php.net>; <php-general@lists.php.net> Sent: Wednesday, August 22, 2001 12:18 PM Subject: RE: [PHP-DB] restoring mysql db after mysqldump > Are your privileges in MySQL set correctly? If ROOT doesn't have read/write > access, the script will crash. > > rick > > -----Original Message----- > From: Jay Paulson [mailto:jpaulson@lbjs.com] > Sent: Wednesday, August 22, 2001 11:29 AM > To: php-db@lists.php.net; php-general@lists.php.net > Subject: [PHP-DB] restoring mysql db after mysqldump > > > Hello everyone- > > I have done the mysqldump function and got the db in a all_database.sql > file. Now I am running this command at the shell prompt of my Linux > machine: > > mysql -u root -p -e 'all_databases.sql' > > When I do that it works fine until it starts to insert the information into > the database. I get the error that the table it is trying to read the > information into is 'read only'... Is there anyway around this problem? > > Thanks, > Jay > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >