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" <[EMAIL PROTECTED]> To: "'Jay Paulson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 11:29 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]