On 22-Aug-2001 Jay Paulson wrote:
> 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]
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
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]