This is a discussion on Problem of "Incorrect information in file: '.\xxx\xxx.frm'"? within the MySQL Database forums, part of the Database Forums category; I want to duplicate one MySQL database to another. I've copied the files from directory 'mydatabase1' in MySQL's &...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
I want to duplicate one MySQL database to another. I've copied the
files from directory 'mydatabase1' in MySQL's "data" directory. After I copied to another machine, and I want to query the table. It shows: ERROR 1033: Incorrect information in file: '.\mydatabase1\xxx. frm' Do any one know what is the problem? And how to solve it? Thanks. |
|
|||
|
On 6 Sep, 10:40, vincent...@gmail.com wrote:
> I want to duplicate one MySQL database to another. I've copied the > files from directory 'mydatabase1' in MySQL's "data" directory. > > After I copied to another machine, and I want to query the table. It > shows: > ERROR 1033: Incorrect information in file: '.\mydatabase1\xxx. > frm' > > Do any one know what is the problem? And how to solve it? > > Thanks. ....how to solve it? Use mysqldump |