While moving databases from development to production and vice versa it is sometimes necessary to export individual tables so that they can be imported into another database.
So in this post i will show you how to export and import individual MySQL Table
Export a single MySQL table
|
1 |
mysqldump -u username root -p dbname tablename > d:\tablename.sql |
Import a previously dumped MySQL table
|
1 |
mysql -u username -p PASSWORD_HERE -D dbname < d:\dump.sql |
That’s it.
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.
Subscribe
Login
0 Comments
