We can take backup of MySQL database by using musqldump.
1. Creating a dumpfile from database/ Taking backup of MySQL database:
We can transfer a MySQL database from
one PC to another PC using mysqldump command. We have to create dump file of
database to transfer database from one PC to another PC.
MySQL databse is not portable database
i.e. we cannot transfer it from one PC to another PC by copying and pasting it.
We can use following method to transfer database.
1. Creating a dumpfile from database/ Taking backup of MySQL database:
- Open
command prompt.
-
Execute
following commands to change directory
>c: “press enter”
>cd program files/MySQL/MySQL Server 5.1/ bin “press
enter”
>mysqldump -u root -p databse_name > database_name.sql “press enter”
Enter password: password of MySQL
Copy sql
file and paste it in PC where you want to transfer database.
.
2. Dumping
sql file into database:-
- Open MySQL command line client
command prompt.
- Execute following command to create database.
>create database database_name; “press enter”
Database name
is must as that of your database _name.
Copy that
sql file into location “c:/program files/MySQL/MySQL Server 5.1/bin”
- Now open
command prompt and execute following commands.
>C: “press
enter”
>cd program
files/MySQL/MySQL Server5.1/bin “press enter”
>mysql –u
root –p database_name < database_name.sql “press enter”
Your database
is created on PC.
Now in MySQL
command prompt check your database.
thanks
ReplyDeletemy pleasure
Deletenice one buddy
ReplyDeletewhat is the path of dump file in windows xp, how should i copy it to another pc???
ReplyDeleteThanks Friend....Nice Work...it works for me...
ReplyDeleteThank you very much!!! :) :)
ReplyDeleteDoes all tables and their content in database get transferred by this way
ReplyDeleteit says Access dined when i enter command after reaching bin
ReplyDeleteeven it doesn't ask me the password of database
same here. not access denide but. lots of other info. didnot understand
ReplyDeleteNice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks to offer such a helpful information here.
ReplyDeletepython training institute in chennai
python training in chennai
python training in chennai
python training in tambaram
python training in annanagar
python training in velachery
python training in OMR
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeleteBlueprism training in annanagar
Blueprism training in velachery
Blueprism training in marathahalli
AWS Training in chennai
Good Post, I am a big believer in posting comments on sites to let the blog writers know that they ve added something advantageous to the world wide web.
ReplyDeleteData Science Training in Chennai
Data science training in bangalore
Data science online training
Data science training in pune
This is good site and nice point of view.I learnt lots of useful information.
ReplyDeletejava online training | java training in pune
java training in chennai | java training in bangalore
Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
ReplyDeleteangularjs Training in bangalore
angularjs Training in btm
angularjs Training in electronic-city
angularjs online Training
angularjs Training in marathahalli
I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.
ReplyDeletemachine learning course
artificial intelligence course in mumbai
Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteData Science Training In Chennai
Data Science Online Training In Chennai
Data Science Training In Bangalore
Data Science Training In Hyderabad
Data Science Training In Coimbatore
Data Science Training
Data Science Online Training
I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
ReplyDeleteartificial intelligence course
http://easywayprogramming.blogspot.com/2012/07/how-to-copy-mysql-databse-from-one.html
ReplyDeleteHow to resolve database issue of aseo tools website.
ReplyDeletepersonally, i love Java. however its seems that web development would be more easy as people are gradually moving to Group Buy SEO Tools as its the easy tools to develop a websites and apps instead of using scratch coding.
ReplyDeleteThe most recognised hearing aids center in Singapore . We offer high quality and modern hearing aid devices that help people to listen and hear better.
ReplyDeleteIf you are trying to get ahead of the competition in
ReplyDeletethe search engine results pages, you should try purchasing SEO group buy tools.
Very nice blogs!!! i have to learning for lot of information for this sites.Group Buy SEO Tools
ReplyDeleteVery nice blog.
ReplyDeleteFind Best SEO tools from esolution.center
Wonderful blog post.
ReplyDeleteJuan Francisco Estrada vs Roman “Chocolatito� Gonzalez Live
estrada vs chocolatito 2 live stream free
StockTrim is inventory planning and demand forecasting software available as a subscription. It helps SME's gain optimised inventory levels and preserves up to 40% of their working capital.Stock Control
ReplyDeleteHow to Create an Outstanding Spotify Playlist Cover. If you don’t want to create it on your own and spend time making it perfect you can do it here as free. Spotify Playlist Cover
ReplyDeleteTwo full thumbs up for this magneficent article of yours. I've really enjoyed reading this article today and I think this might be one of the best article that I've read yet. Please, keep this work going on in the same quality.
ReplyDeletedata scientist training in hyderabad
I genuinely appreciated understanding it. Sitting tight for some more incredible articles like this from you in the nearing days.
ReplyDeletedata science training in bangalore
data science training institute in bangalore
I respect your work, regards for all the interesting blog posts.
ReplyDeletesatta matka
Thanks for sharing the descriptive information. It’s hard to come by well-informed people in this particular topic, but you explained this really good.
ReplyDeleteDevOps Training in Hyderabad
You are looking for the most reliable, cheap and reliable seo tools supplier in 2021. You can join the best group buy seo tools here
ReplyDeleteThanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post .
ReplyDeletedata analytics courses in hyderabad with placements
This is very useful post for me. This will absolutely going to help me in my project.
ReplyDeletedata scientist course in malaysia
A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one
ReplyDeletebusiness analytics course in hyderabad
Data Science course is for smart people. Make the smart choice and reach the apex of your career. Learn the latest trends and techniques from the experts.
ReplyDeletedata science course