restoring mysql db after mysqldump
| From: | Jay Paulson | Date: | Wed, 22 Aug 2001 16:29:12 +0000 |
| Subject: | restoring mysql db after mysqldump | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-11665@lists.php.net to get a copy of this message | ||
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