Posted on

How To backup MySQL DB on Windows severs

Backing up database is essential to eliminate the risk of losing data whenever there is a hardware failure or software issues. In this post, I’ll be showing the possible ways to create backups for MySQL databases.

In fact, There are several ways to Backup MySQL databases, you need to evaluate each one and select the best fit into your needs. I’ll list the possible ways, but I’ll be focusing on the data dump approach.

Types of MySQL backups:

  1. Logical: By using MySqldump utility, you will be able to create a data dump of your database. The Expected output is a .sql file that has all insert statement needed to re-create the database again.
  2. Physical: by coping the actual database files into another location. – This approach usually is recommended for huge databases as it is faster to do the backup and faster to restore in case of any failure. The limitation of this approach, is restoring the database has to be on the similar hardware as the original one.
  3. Partial: Partial backup is meant to have a backup of single table. This is usually useful when you wat to do a bulk operation on that table and you want to create a restore point in case of any failure happened.

For the purpose of this article, I’ll be focusing on the first option; Logical Backup. It is the easiest way as well as it is using a built in tool called mysqldump. This utility tool is being shipped with MySQL engine, Thus it will be installed by default on your MySQL Server. – So no third party tool needed.

You can create a .bat file to do the backup and get benefits of the built-in Windows Task Scheduler to have the backup done on daily basis. Let’s dive into it.

  • Creating backups for all databases on my MySQL engine:
mysqldump --user=root --password=******* --result-file="C:\MySQLdump.sql"  --all-databases

On this command line, you are telling mysqldump utility to have a backup of all databases and store it on the C:\MySqlDump.sql file. If you open the result file in any texts editor, you will find a normal sql statements to insert the data.

  • Creating Backup for a single database:
mysqldump --user=root --password=******* --result-file="C:\MySQLdump.sql"  --[DbName]

it is the same command as all databases, but you need to replace the all-databases option with the name of the database that you are looking for backing it up.

Advantages of using data dump approach over other options:

  1. You are not limited to specific MySQL version. The output of this dump, is normal SQL CRUD operations which means all what you need to do is to connect to the new MySQL engine and execute the datadump file.
  2. You can edit the datadump file in case you are looking to do few tweaks before executing it again.
  3. No 3rd party tools are needed. The MysqlDump.exe tool is built in utility and will be installed within MySQL installation.

For more information about mysqldump, please see the MySQL related documentation here

Posted on

JQuery/JavaScript: how to split string based on Caps letter

In certain cases, you might got a need to change a string content in order to display it in more human readable format. recently I faced a need where I need to tokenize a string based on caps letter and add spaces between words

Using the built-in RegEx feature on Javascript, you can split the string and tokenize it based on the capital letters on the string. For example if you would like to split the string “TestStringValue” to be “Test String Value” you can simply use the following syntax:

/*split string based on Cap letter, then joins the resulted array elements with space between each array entry*/
split(/(?=[A-Z])/).join(" ") 

to try it, use the following code:

alert(  window.prompt("Tokenize String: ", "TestStringValue").split(/(?=[A-Z])/).join(" ")  )
Posted on

Why do I need CRM Software

More businesses adopting the hybrid working style and mixing having employees on the office and working remotely. The nature of this model putting more pressure on management on how they will be managing businesses, team, customers and making sure they are doing really good job on that. Google, Microsoft and other giant software companies are moving into the hybrid model. But to be able to move to hybrid model or the remote-working model, you need to make sure that you have the right tools to empower employees and get the best out of them.

Being lucky and select the right CRM system (customer relationship management ) can empower your business like nothing else. Storing and managing customer and prospect information, will help your marketing team find new customers faster by boosting your lead generation speed. Ultimately, this will make you closing more deals and winning more customers. It will definitely make your customer happier and more satisfy with your service with integrating your help desk solution with CRM.

Being customer-oriented will be easier while having the right CRM solution and you will never lose the precious information. It will keep the whole team on the same page about the customer status and needs.

There are so many benefits of using CRM on your day to day business, with MS365 CRM, we built-it while keeping in mind the needs for you and your customers and we built it to be customer-oriented. Adopting MS365 CRM will help you:

  1. Being on top of your Massive lead generation and never miss any.
  2. Store and retrieve customer information like never before. You will not need anymore to depends on your memory or on your notebook to store customer information. It is all on the cloud.
  3. Managing teams remotely and easily
  4. Better customer service and better customer satisfaction.
  5. Build a long term customer relationship
  6. Generate reports that will help you making data analysis.
  7. Utilizing built-in dashboards that is helping you taking decisions based on data-points.

in order to get the most benefits of CRM, you need to have it customized and tailored to your internal process. There are general rules and processes that all businesses have in place but there will be some variance per each industry and business needs. It worth to mention that MS365 is a customizable CRM solution that our team can help you customizing it and making sure it is fitting into your business needs.

The main information about MS365 will be found on the this link http://crm.myspace365.com also you can send a contact us message and the CRM team will be contacting you within 1 business day.