Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

backup / transfer MySQL DB

Posted on 2011-03-04
3
331 Views
Last Modified: 2012-06-21
Hi, experts

I am new to MySQL
I would like to transfer a MySQL DB to another MySQL server. My MySQL is in Windows environment.

What is the simplest way to do it?
I found a tutorial on the web use "mysqldump" command. I follow it but I got an error like my attached screen shot. Could someone help me about this. thank you


error-screen.jpg
0
Comment
Question by:rmtogether
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
Patrick Tallarico earned 500 total points
ID: 35037545
Try using the mysqldump command from the windows command line, rather than from inside the Mysql cli.
0
 
LVL 6

Expert Comment

by:Patrick Tallarico
ID: 35037559
This seemed to work for me on my linux machine, I would think it would be the same for windows.
0
 

Author Closing Comment

by:rmtogether
ID: 35038078
thank you. you are right. it need be in pure dos mode
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question