how to import .sql file UTF-8 in mysql databse with php

Question

Problem when importing database UTF-8 encoded file table Arabic language change within the table How can I import the table encodes UTF-8 This is the current code I want to modify it

    $sqlFile = 'sql/plugins.sql';
    $queries = file_get_contents($sqlFile);
    $queries = explode(';', $queries);

    foreach ($queries as $query) {
        mysql_query($query);
    }

Possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Qirel, Jun 10 '16 at 00:01

score 0 · Answer 1 · answered Jun 13 '16 at 17:17

0

You don't need PHP. (And, when using PHP, do not use the deprecated mysql_* interface.)

Probably all you need is the commandline tool:

mysql < sql/plugins.sql

answered Jun 13 '16 at 17:17

Rick James

135,179
13
127
222

How can I have been add it database automatically call in the php file – Makarious saad Jun 18 '16 at 16:33
Another approach is to use `LOAD DATE INFILE ...` from PHP. Be sure to include the `CHARACTER SET utf8` clause. – Rick James Jun 18 '16 at 16:51

how to import .sql file UTF-8 in mysql databse with php

1 Answers1