RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

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... > > 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 >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- 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.