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