Transfer a few data databases

[Hubert CANEVET]

Hello everybody,

Sorry, the topic is probably already treated in a documentation.

But I presume that can be as in .Net : there are several ways to do the same, some grant a much higher productivity, but at the cost of a non negligible time to assimilate the technology.

So, here is the topic : I have got a machine that has to go to revision, and a new machine that must receive its data.

I know that SQL Server has somewhere a tool to generate a script to generate the database, and you obtain something this kind for each table (I did not verify the syntax, anyway I presume it is not the same on MySql) :
CREATE TABLE Test(String String1, String String2)
INSERT INTO Test(String1, String2) VALUES ('str1Exemple1', 'str2Exemple1');
INSERT INTO Test(String1, string2) VALUES ('str1Exemple2', 'str2Exemple2');

Is there any possibility to obtain that quickly with MySql, or is it up to me to develop it, and to manage the different types of fields, with the adequate formatting for each ?