RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
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...

RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
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...

[PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Gabe da Silveira
I know nothing about this, but did you investigate 'SHOW TABLE STATUS' for any clues? In article <018601c12b3c$2c2970b0$6e00a8c0@webdesign>, [EMAIL PROTECTED] (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

[PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
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: "

[PHP] RE: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Rick Emery
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