MySQL database migration to MSSQLSERVER

Method 1: use mysqldump --Example:take mysql Of CHL Database migration to MSSQLserver in --1,Use mysqldump Tool export mysql Of CHL All table structures of the database; mysqldump -uroot -p --databases CHL --no-data>/chl/CHLtomssql_nodata.sql --2,Use mysqldump Tool export mysql Of CHL All data in the database. Consider tha ...

Posted on Tue, 31 Dec 2019 05:24:19 -0800 by Chetan

MySQL Full, Incremental Backup and Recovery (Theory + Practice)

Importance of data backup In a production environment, data security is critical, and any loss of data can have serious consequences Causes of data loss Program error Artificial error Computer Failure Disk failure Disasters (such as fires, earthquakes) and theft Classification of database backups From a physical and logical perspective, b ...

Posted on Thu, 12 Dec 2019 17:17:41 -0800 by greekuser

Elasticsearch log alert

Elasticsearch log alarm elastalert use posture correctly Preface In May, Github found an open-source software, elastalert, to find an ELK log alert solution online Portal Look at the latest update for two years ago, so have been in a semi questioning state to look at the software, until further... In depth Latest news: as of the time of relea ...

Posted on Sun, 08 Dec 2019 20:50:57 -0800 by alex.hughson

MySQL: pro test backup strategy instance (online real backup case) recommendation

Xiaosheng blog: http://xsboke.blog.51cto.com If in doubt, please Click here The author will reply in time (or comment directly in the current article). -------Thank you for your reference. If you have any questions, welcome to exchange Have you ever worried about the backup of online database? Here is a complete backup ...

Posted on Sat, 07 Dec 2019 06:25:10 -0800 by Dilb

Do you remember these common Mysql commands?

Preface Recording Common Command Operations of mysql Basic operation Command line login mysql Mysql-u username-p user password Increase creation time and update time for tables ALTER TABLE order_info_tbl ADD COLUMN create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time'; ALTER TABLE order_info_tbl ADD COLUMN update_time TIMESTA ...

Posted on Wed, 25 Sep 2019 08:09:44 -0700 by WilliamNz

Technology Sharing | Controlling the Transaction Size of SQL Files Exported by mysqldump

Author: Chen Juncong   background Some people asked whether insert statements from mysqldump could be organized as one insert statement per 10 row s.   Consideration 1: Parameter -- extended-insert Recalling what we learned in the past: I ...

Posted on Mon, 26 Aug 2019 19:46:35 -0700 by vishal99

MySQL Backup and Restore

mysql backup and restore 1.1 Backup Recovery - Description The core of operation and maintenance work can be summarized as two things: The first is to protect the company's data. The second is to enable the website to provide services (user experience) for 7*24 hours. Introduction to 1.1.1 Backup Logical Backup (Text Representation: SQL St ...

Posted on Tue, 14 May 2019 11:04:07 -0700 by rathlon

How to gracefully backup account information

Preface: Recently, we have encountered the problem of instance migration. After data migration, we need to migrate database users and privileges to the past. When doing logical backup, I usually get used to excluding the MySQL system library, so that the backup does not contain database user information. At this time, if you wan ...

Posted on Wed, 24 Apr 2019 16:51:34 -0700 by oddyseys