How to automate Social Media Marketing

Standard

If you’re a startup or a small business, it’s likely that you are not able to spend as much time and efforts as you want on social media marketing for your business despite knowing it well that social media can be an incredibly effective way to gain more traffic and generate new leads. Reasons are manifold – lack of time, lack of clarity on where to start, unavailability of affordable tools to manage and automate social media activities, not knowing how to do things the right way and so on.

Wouldn’t it be better if there was a tool which would not only help automating your social media marketing activities but also provides you an effective way to research targeted content to share on social media as per your requirements. Well, you’re in luck because now there is a tool available which does it all, and more.

Let me introduce you to Social Media Marketing Dashboard. It helps reaching your social media goals in the most easy yet in a very efficient way without taking up lot of your time and money. Did I mention it doesn’t cost you a dime? Yes, that’s right. The tool is FREE of cost and there are no limitations on how long you can use it for. All you have to do it create an account and start using it. There is a pro version which comes with more powerful features however you will find even the basic version fully functional and extremely useful.

You must be wondering though this tool sounds great but how does it actually work?

How Social Media Marketing Dashboard works?

  • It finds relevant content including videos, news, trending content all of which can be posted on your social media accounts with the click of a button.
  • It creates incredible image posts without any photo editing experience.
  • It saves time by having all social media in one place with the ability to schedule posts across multiple platforms.
  • It measures all campaign performance to help you get more traffic and generate new leads.

Here is how the social media marketing dashboard would look like once you have setup your account.

Get your free social media marketing dashboard

Get your FREE Social Media Marketing Dashboard

Moving MySQL InnoDB data files

Standard

If you ever need to move around MySQL data files for InnoDB tables or getting the error mentioned below then follow the instructions in this post.

Note that this post might be helpful only if you have a backup of complete data files directory from your source MySQL installation. Otherwise please refer to the links at the bottom of this post.

Take backup of your data files (source)

Copy your data files from /usr/local/mysql/data/ on Mac or /var/lib/mysql/ on Ubuntu/Linux to a safe location, e.g. inside your home directory. Location of data files can be different so refer to your MySQL configuration file (my.cnf) for correct path.

mkdir ~/db-files/

On Mac

On Ubuntu/Linux

Do not forget to copy the period (.) at the end of commands above.

Restore files (destination)

Stop the MySQL server on target system, if running.

On the new/target installation, replacing the target data directory contents with source data directory may not work, specifically if you have InnoDB tables.

Take a backup of data files on the destination and keep them safe somewhere in case anything goes wrong. Assuming that target data directory location is /usr/local/newmysql/data/

Extract the compressed archive of source data files.

From the extracted contents, manually copy the database folders under destination data files directory. Do not copy/overwrite any files or folders inside destination data directory, for example sys and mysql folders. For example, if one of the database name is mydb and destination data directory path is /usr/local/newmysql/data/ then execute the following command.

cp -R mydb /usr/local/newmysql/data/

This needs to be done for all your databases one by one. Any files or folders which pre-exist in the target data directory must not be overwritten. If you do then there is a fair probability that you are doomed.

Once you have copied all your databases manually (without overwriting any existing folder or file) to the target data directory, copy/replace ibdata1 file from your source directory to target data directory

Finally, ensure that ownership and permissions of folders and files inside destination data directory are correct. Data directory itself and it’s content must be owned by mysql user, _mysql  in Mac and mysql in Ubuntu/Linux.

On Mac

On Ubuntu/Linux

I am not 100% sure but permissions should be as mentioned below. These permissions work on my Mac correctly.

755 (rwxr-xr-x) for mysql top data directory

700 (rwx——) for each database directory

660 (rw-rw—-) for database files inside database directory

Lastly, restart the MySQL server and verify if everything is as expected.

Summary

The most important part is the one related to ibdata1 file. This file stores lot of information and data about your InnoDB tables along with an internal index to all the InnoDB tables. If you don’t replace the ibdata1 file related to your original/source data files then that index would be lost and MySQL would fail to understand the schema and data too would be lost despite having ibd and frm files in place.

Here are links to some useful discussions/posts related to the topic for reference.

What is the ibdata1 file in my /var/lib/mysql directory?

How to restore table stored in a .frm and a .ibd file?

Recovering an InnoDB table from only an .ibd file.

InnoDB Corruption Repair Guide