[PHP] RE: [PHP-DB] restoring mysql db after mysqldump From: Rick Emery (remery <email protected>)
Date: 08/22/01

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 <email protected>]
Sent: Wednesday, August 22, 2001 11:29 AM
To: php-db <email protected>; php-general <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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>