Re: restoring mysql db after mysqldump

You probably just need to mess around with which users can do what to the table... -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Jay Paulson <jpaulson@lbjs.com> Newsgroups: php.db,php.general To: <php-db@lists.php.net>; <php-general@lists.php.net> Sent: Wednesday, August 22, 2001 11:29 AM Subject: 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 >