Uncategorized

Mysql InnoDB Backup

11 de Junho de 2018 – 19:53

The key to safe database management is making regular backups. Depending on your data volume, number of MySQL servers, and database workload, you can use these backup techniques, alone or in combination: hot backup with MySQL Enterprise Backup; cold backup by copying files while the MySQL server is shut down; logical backup with mysqldump for smaller data volumes or to record the structure of schema objects. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore.

Using MySQL Enterprise Backup is the recommended method for backing up InnoDB data.

Note

InnoDB does not support databases that are restored using third-party backup tools.

Hot Backups

The mysqlbackup command, part of the MySQL Enterprise Backup component, lets you back up a running MySQL instance, including InnoDB tables, with minimal disruption to operations while producing a consistent snapshot of the database. When mysqlbackup is copying InnoDB tables, reads and writes to InnoDB can continue. MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. In conjunction with the MySQL binary log, users can perform point-in-time recovery. MySQL Enterprise Backup is part of the MySQL Enterprise subscription. For more details, see MySQL Enterprise Backup Overview.

Cold Backups

If you can shut down the MySQL server, you can make a physical backup that consists of all files used by InnoDB to manage its tables. Use the following procedure:

  1. Perform a slow shutdown of the MySQL server and make sure that it stops without errors.
  2. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place.
  3. Copy all the .frm files for InnoDB tables to a safe place.
  4. Copy all InnoDB log files (ib_logfile files) to a safe place.
  5. Copy your my.cnf configuration file or files to a safe place.

Logical Backups Using mysqldump

In addition to physical backups, it is recommended that you regularly create logical backups by dumping your tables using mysqldump. A binary file might be corrupted without you noticing it. Dumped tables are stored into text files that are human-readable, so spotting table corruption becomes easier. Also, because the format is simpler, the chance for serious data corruption is smaller. mysqldump also has a --single-transaction option for making a consistent snapshot without locking out other clients. See Section 1.3.1, “Establishing a Backup Policy”.

Replication works with InnoDB tables, so you can use MySQL replication capabilities to keep a copy of your database at database sites requiring high availability. See InnoDB and MySQL Replication.

 

https://dev.mysql.com/doc/mysql-backup-excerpt/5.5/en/innodb-backup.html

Tags | Permalink | Comentários fechados em Mysql InnoDB Backup
Code Snippets

Exporting AD user list

7 de Junho de 2018 – 14:05

> dsquery user -name * -limit 0 >> c:\users.txt

Permalink | Comentários fechados em Exporting AD user list
Exchange Office365 Tips & tricks

MRS Proxy Error “The connection to the server could not be completed”

6 de Junho de 2018 – 15:21

Check MRS endpoint user and password.

read more »

Permalink | Comentários fechados em MRS Proxy Error “The connection to the server could not be completed”
Exchange Microsoft

Exchange 2013 not receiving external emails

6 de Junho de 2018 – 10:14

Backpressure,  check for free space on the disks.

 

read more »

Permalink | Comentários fechados em Exchange 2013 not receiving external emails
Notepad++ Utils

Find duplicates and delete all in notepad++

5 de Junho de 2018 – 10:06

example:epshetsky@test.com,
rek4@test.com,
rajesh1239@test.com,
mohanraj@test.com,
sam@test.com,
nithin@test.com,
midhunvintech@test.com,
karthickgm27@test.com,
rajesh1239@test.com,
mohanraj@test.com,
nithin@test.com,

I need results back like

epshetsky@test.com,
rek4@test.com,
sam@test.com,
nithin@test.com,
midhunvintech@test.com,
karthickgm27@test.com,

 

  1. sort line with Edit -> Line Operations -> Sort Lines Lexicographically ascending
  2. do a Find / Replace:
    • Find What: ^(.*\r?\n)\1+
    • Replace with: (Nothing, leave empty)
    • Check Regular Expression in the lower left
    • Click Replace All

How it works: The sorting puts the duplicates behind each other. The find matches a line ^(.*\r?\n) and captures the line in \1 then it continues and tries to find \1 one or more times (+) behind the first match. Such a block of duplicates (if it exists) is replaced with nothing.

The \r?\n should deal nicely with Windows and Unix lineendings.

 

https://stackoverflow.com/questions/35329122/find-duplicates-and-delete-all-in-notepad

Permalink | Comentários fechados em Find duplicates and delete all in notepad++
Utils

Worldwide payment methods (some)

3 de Maio de 2018 – 15:16

read more »

Permalink | Comentários fechados em Worldwide payment methods (some)
Exchange Microsoft Office365

Remote Server returned ‘550 5.1.8 Access denied, bad outbound sender

12 de Abril de 2018 – 17:22

Remote Server returned ‘550 5.1.8 Access denied, bad outbound sender’

Solution:

–Non-Office 365 user use this https://sender.office.com (self-service delisting portal) to remove themselves from the blocked senders list.

–Office 365 user, as an admin you can unblock your blocked Office 365 email account via using Exchange admin center.

• Go to the EAC, navigate to protection > action center.
• Select the Search icon and enter the SMTP address of the blocked user.
• Click Unblock Account in the description pane.
• Click Yes to confirm the change.

For more detailed information, please refer to the article: Removing a user, domain, or IP address from a block list after sending spam email

Permalink | Comentários fechados em Remote Server returned ‘550 5.1.8 Access denied, bad outbound sender
Exchange Microsoft

421 4.4.2 message submission rate for this client has exceeded the configured limit

26 de Fevereiro de 2018 – 10:09

Solved after run the command Set-receiveconnector “Server Name\Client Connector” -Messageratelimit 100.

Permalink | Comentários fechados em 421 4.4.2 message submission rate for this client has exceeded the configured limit
Utils

Níveis de qualificação – Quadro Nacional de Qualificações (QNQ)

6 de Fevereiro de 2018 – 10:38

Imagina que a meio do curso tens necessidade de ir viver para um outro país da União Europeia ou que depois de teres terminado o curso quer mesmo ir trabalhar ou estudar para o estrangeiro. Ora, tudo isto é hoje mais fácil, pois desde outubro de 2010 Portugal tem em vigor um Quadro Nacional de Qualificações (QNQ).

read more »

Permalink | Comentários fechados em Níveis de qualificação – Quadro Nacional de Qualificações (QNQ)
RFID

Technology Companies Create RAIN to Promote EPC UHF RFID Adoption

29 de Janeiro de 2018 – 16:07

Four technology companies have teamed up to form RAIN RFID, an organization whose mission is to promote the adoption of EPC ultrahigh-frequency (UHF) RFID. The organization—founded by Impinj, Intel, Google and Smartrac, and hosted by automatic-identification trade association AIM—is focused on driving UHF RFID deployment through education, testing and support of technology developers and end users. The group announced its launch today at RFID Journal LIVE! 2014, taking place this week in Orlando, Fla.

The word RAIN—an acronym derived from RAdio frequency IdentificatioN—is intended as a nod to the link between UHF RFID and the cloud, where RFID-based data can be stored, managed and shared via the Internet. With a six-member board consisting of an AIM liaison, four elected directors and a president, the alliance was conceived following standards organization GS1‘s ratification of the UHF Gen2v2 standard in November 2013 (see GS1 Ratifies EPC Gen2v2, Adds Security Features, More Memory). That ratification, says Chris Diorio, RAIN’s chairman of the board and Impinj’s chief strategy and technology officer, signifies further maturity in the UHF market, at the same time that item-level UHF RFID tagging for the retail sector has grown exponentially.

read more »

Permalink | Comentários fechados em Technology Companies Create RAIN to Promote EPC UHF RFID Adoption

« Página anterior — Página seguinte »

« Página anterior — Página seguinte »