MYSQL import Database from UTF-8 file

We need to restore our backup we can do that with phpmyadmin, but there is big problem

beacuse default upload file must be 2 mb .

We have two soluotions to slove that problem.

1st solution is to edit php.ini and chage upload limit.

To do that we must reastart apache .

That is not very good solution beacuse we will chage global setings on our server .

Better  solution is to import our base from  console:

databse name = testbase

sql file = testbase.sql

host = localhost

user = test

password = we don't have password on that database

This is the the console command to inmport database with encoding command:

mysql -u test -p -h localhost --default_character_set utf8 testbase < test_base.sql

Tweet