export tables of mysql in sql file and import it directly

Question

0.00/5 (No votes)

See more:

I want to export the table of mysql in .sql file using query and i want to import it again in database.i have tried it but at the time of import it gives error.Please suggest mi the solution for that.

[EDIT, CHill60 - OP Comment]

Quote:
I want to export using query in phpmyadmin not directly by clicking export button.

Posted 21-Jan-15 1:37am

sushma14

Updated 21-Jan-15 23:26pm

CHill60

v2

Add a Solution

Comments

CHill60 21-Jan-15 7:38am

Show us what you have tried and tell us what the error is. We can't see your screen, your HDD or your thoughts

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)

_Asif_ · Answer 1 · 2015-01-21T02:02:00

Solution 2

I believe this is what you want! Check below link

5.5 Database Export and Import[^]

Posted 21-Jan-15 2:02am

_Asif_

Comments

sushma14 21-Jan-15 8:09am

I want to export using query in phpmyadmin not directly by clicking export button.

CHill60 21-Jan-15 8:21am

Perhaps you should have included this information in your question

sushma14 21-Jan-15 8:31am

I have mention it in description of question in detail.

CHill60 21-Jan-15 9:11am

No mention of phpmyadmin anywhere in your question! Only in this comment

sushma14 22-Jan-15 0:20am

ok by mistake its not mention...is there any solution?