I am trying to dump and restore devportal MySQL/MariaDB database using mysqldump -u root -p devportal > devportal_dump.sql
I am getting
mysqldump: Got error: 1146: "Table 'devportal.accesslog' doesn't exist" when using LOCK TABLES
Based on http://www.linux.org/threads/resolving-mysql-error-1146-table-doesnt-exist-when-doing-backup.2480/ the suggestion is to drop these tables. Is this the correct fix for this?
Has anyone come across this error with Drupal?
@Vineet Bhatia , DO NOT drop the tables... It will lead to fatal errors. Are you sure you are in right instance? Can you execute select commands / show tables command to make sure you are trying to take right instance backup ?
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |