I could not get the backup to work using the mysql client program.
The table is a MyISAM type and I have a version (3.23.36) that should
support the BACKUP TABLE SQL command.
First I created a directory called "dbbackup" and then used the following:
mysql> BACKUP TABLE Example.Import_Web TO '/dbbackup';
+--------------------+--------+----------+--------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+--------------------+--------+----------+--------------------------------------+
| Import_Web | backup | error | Failed copying .frm file:
errno = 13 |
| Example.Import_Web | backup | status | Operation failed
|
+--------------------+--------+----------+--------------------------------------+
2 rows in set (0.02 sec)
Anyone recognize the error?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php