MySQL Forums
Forum List  »  General

Re: Is it possible to add Binary data tables into a MySQL DB?
Posted by: Edward R
Date: May 10, 2005 08:37PM

Hmmmm.

MySQL stores data in a "binary" format. All "binary" format means is something that isn't a text file. As an example a Microsoft Word document is technically in a "binary" format. So it's frankly nonsense.

What your programmer is suggesting is that you could simply ask the hosting service to copy your MySQL data files over onto their server. Technically you can do this. All you'd have to do is stop the MySQL server, copy the files over and then restart the server. But you risk having inconsistencies as the version of your server and their server might be different.

The hosting service is requesting the data in an ASCII format, a straight data dump as Mr. Hill suggests, because it's fast, simple, easy and the generally accepted method of transferring data between servers. In this way you won't have to worry about version inconsistencies or incompatibilities. Which is why the hosting service isn't going to accept the MySQL files directly. I'd also suggest the hosting service is probably not that keen on shutting down the MySQL server just for your programmer's convenience. While you are paying for a MySQL server host it is unlikely, unless you specifically are paying for it, that you have a dedicated MySQL server. In which case you are sharing the server with other users.

Summary: Tell your programmer to dump the data, compress it and send it to the host.

Options: ReplyQuote


Subject
Written By
Posted
Re: Is it possible to add Binary data tables into a MySQL DB?
May 10, 2005 08:37PM


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.