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

2001-08-22 Thread Don Read
t; table is read only" and it stops... > > jay > > - Original Message - > From: "Rick Emery" <[EMAIL PROTECTED]> > To: "'Jay Paulson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> >

[PHP-DB] 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-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

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

2001-08-22 Thread Jay Paulson
Daniel" <[EMAIL PROTECTED]> To: "'Jay Paulson'" <[EMAIL PROTECTED]> Cc: "PHP List (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 12:24 PM Subject: RE: [PHP-DB] restoring mysql db after mysqldump > Hello!!! > > >

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

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

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

2001-08-22 Thread Brunner, Daniel
Hello!!! Make sure that the ownership of the files are mysql.mysql This as happened to me too!!! I might be wrong but it worked for me Dan > -- > From: Jay Paulson > Reply To: Jay Paulson > Sent: Wednesday, August 22, 2001 11:29 AM > To: [EMAIL PR

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