MySQL Forums
Forum List  »  Backup

Transfer a few data databases
Posted by: Hubert CANEVET
Date: March 02, 2021 04:05AM

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 ?

Options: ReplyQuote

Written By
Transfer a few data databases
March 02, 2021 04:05AM
January 12, 2022 02:37AM

Sorry, only registered users may post in this forum.

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.