Nobody ever really wants to move a database, but it is a frequent necessity. Here are the most common options and when to use each one ...

When you import a spreadsheet into an OpenOffice.org database, you lose any text styling, number formatting, macro scripts or charts that you previously used to enhance the data.

Come to think of it, you may actually need to create your database first. I'm not sure that using # mysql orsee -uroot -ptest < install.sql will actually create the orsee database or not.

In this article, author Deepak Vohra discusses the details of migrating an on-prem database to a MySQL database on the cloud, using AWS Database Migration Service.

Appart from the 'Natural Detox', gilbrikc mayhave a point:- All MySQL prior to 4.1 are UTF-8 unaware and that may be causing fun on the import, it's a long shot but something to consider.