copy mysql database with all data it contain to other computer through workbench export import

Question

0.00/5 (No votes)

See more:

i want to copy all tables i.e whole database with its contains to other computer. i did it through mysql workbench export import. i did export then exported file copied on other computer and there i import those files it import successfully but not showing that database, what is problem? or we have to do something more? to where it is located?

Posted 17-Aug-15 19:19pm

ven.in

Updated 17-Aug-15 19:20pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-08-17T19:34:00

Solution 1

The Export/Import wizard can be used to export a single table and then import it back. Just make sure that
- you select all columns
- you select the data to be included
- export to local machine
- when importing select the create new table
- and repeat this for all tables

For more information refer to 6.5.1 Table Data Export and Import Wizard[^]

Another approach could be to use backup/restore, see 6.7.3 Backup Recovery[^]

Posted 17-Aug-15 19:34pm

Wendelius

Comments

ven.in 18-Aug-15 5:20am

when table contain 60-80 columns and number of rows then this is not work it is giving error. for small table it works. thanx for reply...plz tell what to do with large size table

Wendelius 18-Aug-15 5:37am

What error do you get?

ven.in 18-Aug-15 6:27am

there are two task performed
1)prepare to export
2)export data to file

on second task it is giving error
A task has failed executing

Wendelius 18-Aug-15 15:22pm

Is there nothing else in the error message?

When the error has occurred, have a look at the file, was it created or not and if it was, what does it contain?

ven.in 18-Aug-15 6:54am

plz relpy soon its urjent