restoring mysql db after mysqldump

admin

Administrator
Staff member
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
 
Back
Top