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