How can I import a mysql dump?

Question

I have created a mysql dump for only one table in my database. The command I used to create the dump was mysqldump -uroot -p database_name table_name > backup.sql. Now, when I am trying to import the data into my machine using the command "mysql -uroot -p database_name table_name < backup.sql" I am not getting anything.

I only get text on command line which explains me how to use mysql command. Is there anything i am missing here?

Sahil Muthoo · Accepted Answer · 2011-09-12 15:26:18Z

9

Remove table_name.

mysql -uroot -p database_name < backup.sql

answered Sep 12, 2011 at 15:26

Sahil Muthoo

12.6k2 gold badges32 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sahil Muthoo Over a year ago

Do you know the root password?

Poodlehat Over a year ago

and reember that the host is included in the grants - root isn't uber everywhere unless the server is set up that way

Poodlehat · Accepted Answer · 2011-09-12 15:26:57Z

Does the schema exist on your server? If you didn't used the --databases option, I don't think it adds the create database database_name and use database_name. You might have to execute these steps manually from the command line client.

Collectives™ on Stack Overflow

How can I import a mysql dump?

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related