MySQL Forums
Forum List  »  Other Migration

Problem with using InnoDB data files from Dropbox directory
Posted by: Miloš Rašić
Date: October 28, 2010 06:20AM

I work on my project from office and from home. After months of backing up my data on a usb flash drive, I decided to try Dropbox so I can work on the same code and database wherever I am. I installed Dropbox at home and moved the mysql directory with data files (/var/lib/mysql/dbname) to Dropbox. I went to work, installed Dropbox and it downloaded my database directory. I created a symlink in my /var/lib/mysql/ at work to ~/Dropbox/dbname and gave mysql access to the Dropbox directory in my apparmor.

After apparmor and mysql restat, mysql sees the database fine and all SELECT queries without a WHERE clause work fine. However, when I try to run a SELECT with WHERE clause from command line, I get "ERROR 2013 (HY000): Lost connection to MySQL server during query". When I try to edit a row from phpMyAdmin, it displays "#1030 - Got error 1 from storage engine ".

I was suspicious about indexes at first because I'm not sure if they are stored in the same files as the other data about tables, but phpMyAdmin sees and displays the indexes so I'm not sure that this is the problem.

Any ideas? Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with using InnoDB data files from Dropbox directory
4378
October 28, 2010 06:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.