← Back to team overview

maria-discuss team mailing list archive

New Question: Changing location of database



A new question has been asked in "MariaDB community" by mdavies5:
Using 5.5.31 on Linux Mint. By default datadir is /var/lib/mysql. Like most users I do not want my data on my boot drive so I moved it to a different physical drive which is always mounted. I then stopped server, reset the basedir in my.cnf and restarted. No problem. After a reboot the log shows multiple errors "Table xxx doesn't exist" although it does. In Mysql workbench the tables are listed in the schema tree but any attempt to access causes workbench to abort.
I also tried deleting all data, recreate the schema folders and then the scripts to create the tables and routines and data. Again ok until a reboot. The only thing I haven't tried is dropping the schemas and recreating them in workbench. 
Relevant data: The new data drive is NTFS. The error messages include:
[ERROR] Cannot find or open table pword/pword from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
Would appreciate any suggestions.


To view or answer this question please visit: http://kb.askmonty.org/en/changing-location-of-database/