How I can escape backtick (´) from table name and column name?

Question

I am trying to import DB dump with following command.

mysql -u doadmin -p -f tetdb < test.sql

then I am getting all imported table name and column warped by Backtick (´).

´test_cache_menu´ ´test_cache_data´

My test.sql is too big (40GB) so I can't edit the file.

Answer 1

use these commands :

1) login to mysql by:

mysql -u USERNAME -p

2) create a database in which you want to import by

create database DB_NAME;

3) use created database

use DB_NAME;

4) then export test.sql to your database :

source /PATH_TO_DIR/test.sql;

that's all