Error while uploading a media from wp-admin ?

If you face something like this: Unable to create directory uploads/2016/11. Is its parent directory writable by the server?

Generally we think this could be a permission issue,but not like that. just go in your admin, go to Settings/Media and change the upload path to that of the new server. (Keep it default)

Error while uploading Mysql database ? #1273 - Unknown collation: 'utf8mb4_unicode_ci' ?

Just follow this simple way while exporting database:

1) Click the "Export" tab for the database

2) Click the "Custom" radio button

3) Go the section titled "Format-specific options" and change the dropdown for "Database system or older MySQL server to maximize output compatibility with:" from NONE to MYSQL40.

4) Scroll to the bottom and click "GO".

Now try again to uplaod this Database.

Captcha Problem in Contact Form 7 ?

Sometimes it may happen that your default reCaptcha is not working in Contact Form 7.Then you can simply install this plugin and configure according this plugin.

1) Plugin Link: https://wordpress.org/plugins/contact-form-7-simple-recaptcha/

Let's see how to handle if you get MYSQL error code: 1064

This is basically a syntax error.This errors not have any specific solution.You have to first understand what syntax are causing your problem.Like see this error line: '#1064 - you have an error in your sql syntax check the manual that corresponds to your mysql server version for the right syntax to use near 'type=MyISAM at line 19

From this line first of all we can understand the problem is at line 19,and secondly we can see the syntax issue can be this : type=MyISAM.

Then you have to identify what version of MySQL you are using and what version of new MySQL where you are now trying to upload this DB.And do some googling to find what syntax have depricated within these version gap.

In the case of this error line that I have just showed there 'TYPE' syntax was culprit: The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

So go to your DB.find that old syntex and replace with new one.You are done !!!