Home » Open Source » MySQL » How to backup Mysql DB (Mysql 5.6)
How to backup Mysql DB [message #645425] Sun, 06 December 2015 01:47 Go to next message
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
Re: How to backup Mysql DB [message #645426 is a reply to message #645425] Sun, 06 December 2015 02:28 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Note there is a specific forum for MySQL (where I moved your question), "Backup & Recovery" one is about Oracle genuine RDBMS.

Previous Topic: Application Instantiation Error: Could not connect to MySQL
Next Topic: New REPORT
Goto Forum:
  


Current Time: Thu Mar 28 12:41:06 CDT 2024