How to increase limit on import in phpMyadmin

PhpMyAdmin allows you to import only 2 MB – 8 MB file by default. This was creating problems for me when I wanted to restore a WordPress database which was around 10 MB.
The solution is really simple just to go to the php.ini file and edit the arguments
usually in your
c:\xampp\php folder (if using xampp) or
C:\wamp\bin\apache\apache2.2.22\bin (if using wamp)
So in your php.ini change import the desired value for example 20 MB by searching for post_max_size, upload_max_filesize:

post_max_size = 20M
upload_max_filesize = 20M

Now try using the import function again and it will work for sure. Simple and easy 🙂
For more information visit the official site:  http://www.phpmyadmin.net/

MySQL php arabic not showing

In your application or in the website Arabic language or other languages appears like “????” question marks. You can use the below instructions to solve the problems.
If you have same problem in printing in the android application convert into Unicode and it will automatically show the original content in the application.
You must set charset in first connect with mysql this query: this action need before insert and before select.

SET CHARACTER SET utf8

for example in mysqli functions

$con = mysqli_connect(HOSTNAME,DB_USERNAME,DB_PASSWORD,DB_NAME)
or die ( mysqli_error($con) );
$query1= 'SET CHARACTER SET utf8';
mysqli_query($MySQL_Handle,$query1)
or die ('Can\'t charset in DataBase'); 

If it’s not working try these methods also
1.set the content type in the html header.

<meta http-equiv="content-type" content="text/html; charset=utf-8">
header("content-type: text/html; charset=utf-8");

2.try the below php qury

mysql_set_charset('utf8', $con);
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER_SET utf8;");
mysql_query("SET NAMES utf8 COLLATE utf8_turkish_ci",$db );