Import/Export database from server using command

Connect to server using PUTTY or other server connecting tools. After connection connected to server successfully run following

Import Database:

mysql -p -u username database_name < file.sql

Export Database:

mysql -p -u username database_name > file.sql

 

Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.
Yes0
No0
Harinder Singh

Harinder Singh

My name is Harinder Singh and I specialize in Software industry. I consider myself as a life learner. I love learning new concepts, embracing new ideas and reading and searching for innovation.