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 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]