CODEWITHSUNDEEP
mysqllinuxubuntuinnodbdatabase-migration
Brady Zhu
Brady Zhu

Reputation: 1405

How to copy MySQL InnoDB database from Windows server to Ubuntu Linux server?

To upgrade our application deployment platform from Windows to Ubuntu Linux Server, we need copy a MySQL InnoDB database from Windows to Linux server, and I tried 2 ways to do it:

1, use mysqldump tool to export to a sql and then import it from Linux server, this way got a lot of problems, like Chinese character garbage and InnoDB type tables are incorrect.

2, directly copy the database file (under mysql/data/) to Linux MySQL data folder (/var/lib/mysql/), and restart the MySQL, and by typing command lines, I can see the database we copied, and can see all the tables in the database, but when I type command line 'select * from sample_table', it shows error 'ERROR 1146 (42S02): Table 'sampleSchema.sample_table' doesn't exist', I know this table really exists. I don't why this happened.

So hope anybody knows this gives me help, thanks.

Upvotes: 1

Views: 1570

Answers (1)

Mark
Mark

Reputation: 8451

If you can access your Ubuntu Server remotely from your windows pc, you can use MySQL Workbench 5.2

Upvotes: 3

Related Questions