CODEWITHSUNDEEP
mysqlcentoscentos6
Jony kale
Jony kale

Reputation: 85

SQL File won't restore

What I have done:

mysql -u root -p -h localhost gx < gxe.sql

Result:

[root@jony html]# mysql -u root -p -h localhost gx < gxe.sql
Enter password:
[root@jony html]#

It actually doesn't do anything.. I tried refreshing my SQL client (Heidi SQL), and still nothing?. What have I done wrong? Thanks!

OS: CentOS 6 - Linux

Upvotes: 0

Views: 47

Answers (1)

yunzen
yunzen

Reputation: 33439

mysql and mysqldump have slightly different syntax

mysql needs -D parameter to set the database.

So try

mysql -u root -p -h localhost -D gx < gxe.sql

Upvotes: 1

Related Questions