I'm a beginner to these mysql. i used the command
"mysqldump -u root -p magento > magentobackup.sql"
but returned a
"Got error: 1036: Table 'catalogsearch_fulltext' is read only when
using LOCK TABLES"
. whats the safe command to back up?
backupdatabase
I'm a beginner to these mysql. i used the command
"mysqldump -u root -p magento > magentobackup.sql"
but returned a
"Got error: 1036: Table 'catalogsearch_fulltext' is read only when
using LOCK TABLES"
. whats the safe command to back up?
Best Answer
I've never had a lock tables issue. But the problem is that the search table is trying to be updated whilst you are Dumping.
Generally speaking you should consider putting the store into maintenance mode during a dump to prevent data loss or other issues as MySQLDump does attempt to lock the tables so it can see how much data it needs to load from the whole table. (It doesn't want to miss newly added data so it locks the table but something else has locked it.
You can use the
--lock-tables=false
option on the MySQLDump command line. But I'd go with Maintenance mode myself.