CODEWITHSUNDEEP
mysqllinux
DinhNgocHien
DinhNgocHien

Reputation: 717

Is there any ways to import MySQL database from Windows to Linux?

I'm using Ubuntu 14.04. I expected to import a sql file that exported from Windows machine to my Linux PC. I did it by command: mysql> source /path/to/mysqlfile/name.sql; After importing completed, I realized that all table's name in my database are lowercase and my app cannot get data from these( I rename one table to uppercase to test and it worked well). So my question is: is there any ways to auto import database from Windows to Linux (table name change from lowercase to uppercase)? Because it is very waste time if we have hundreds tables and have to rename them manually.

Upvotes: 1

Views: 1229

Answers (2)

JItendra
JItendra

Reputation: 1

Import database for xampp Without using database password enter link description here

:- $ su

:- $ user password ********

:- # /opt/lampp/bin/mysql>mysql -uroot -p database_name < database path

Upvotes: 0

G&#233;za T&#246;r&#246;k
G&#233;za T&#246;r&#246;k

Reputation: 1407

You can set the lower_case_table_names option to 1 in your mysqld config file, which will cause mysql server to match object names case-insensitively. Have a look at this article

Upvotes: 3

Related Questions