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]

Reply via email to