[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump
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]
[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump
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... > can you drop or create tables ? If not then your sql daemon permissions are messed up. stop the daemon, chown -R mysql.mysql /path/to/mysql/data, restart the daemon. Regards, -- 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]
Re: [PHP-DB] restoring mysql db after mysqldump
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 < '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 -- __ Gabe da Silveira, Web Designer Twin Cities Student Unions University of Minnesota http://www.coffman.umn.edu wFone: (612)624-7270 eMail: [EMAIL PROTECTED] hPage: http://www.visi.com/~jiblet -- 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]
Re: [PHP-DB] restoring mysql db after mysqldump
actually the owner of the tables/files that "all_databases.sql" creates is mysql.mysql.. and it still says read only.. and they are chmod'ed to 660... like i said before i'm really lost as to why it's doing this. jay - Original Message - From: "Brunner, 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!!! > > > 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 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]
Re: [PHP-DB] restoring mysql db after mysqldump
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 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]
RE: [PHP-DB] restoring mysql db after mysqldump
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 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]
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]