OraFAQ Forum: MySQL » How to backup Mysql DB

Home » Open Source » MySQL » How to backup Mysql DB (Mysql 5.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to backup Mysql DB [message #645425]

Sun, 06 December 2015 01:47

deepak416
Messages: 63
Registered: January 2013
Location: Pune

Member

When i am running any check optimize and repair command or any other backup command its showing below error. I need my backup of DB urgently. Any Solution ?

+--------------------------+-------+----------+--------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+-------+----------+--------------------------------------------------------------------+
| krishnamobile.rsol_users | check | Warning | InnoDB: Tablespace is missing for table 'krishnamobile/rsol_users' |
| krishnamobile.rsol_users | check | Error | Table 'krishnamobile.rsol_users' doesn't exist |
| krishnamobile.rsol_users | check | status | Operation failed |
+--------------------------+-------+----------+--------------------------------------------------------------------+

13:13:22 Dumping krishnamobile (all tables)
Running: mysqldump.exe --defaults-file="c:\users\om\appdata\local\temp\tmpt9kouk.cnf" --set-gtid-purged=OFF --user=root --max_allowed_packet=1G --host=localhost --port=3306 --default-character-set=utf8 "krishnamobile"
mysqldump: Got error: 1146: Table 'krishnamobile.old_sale_purchased_items' doesn't exist when using LOCK TABLES

Operation failed with exitcode 2
13:13:23 Export of C:\Users\om\Desktop\today.sql has finished with 1 errors

Report message to a moderator