Re: restoring mysql db after mysqldump

actually the owner of the tables/files that "all_databases.sql" creates is mysql.mysql.. and it still says read only.. and they are chmod'ed to 660... like i said before i'm really lost as to why it's doing this. jay ----- Original Message ----- From: "Brunner, Daniel" <daniel.brunner@duni.com> To: "'Jay Paulson'" <jpaulson@lbjs.com> Cc: "PHP List (E-mail)" <php-db@lists.php.net> Sent: Wednesday, August 22, 2001 12:24 PM Subject: RE: [PHP-DB] restoring mysql db after mysqldump > Hello!!! > > > Make sure that the ownership of the files are > > mysql.mysql > > > This as happened to me too!!! > > > I might be wrong.... but it worked for me.... > > > > Dan > > > > ---------- > > From: Jay Paulson > > Reply To: Jay Paulson > > 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 > > > > >