Is there any way to export a database using MYSQL Command Line Client?

Question

Is there any way to export a MySQL database using MYSQL Command Line Client?

I have a database named as naukri_portal, which contains 3 tables. I am trying to export the database using MYSQL Command Line Client but it didn't work.

mysqldump -u root -p naukri_portal > naukri_portal.sql

Not working means? what error you got? From which location you executed script? Any screenshots? — PraveenKumar Lalasangi, Sep 01 '19 at 12:55

ANIK ISLAM SHOJIB · Accepted Answer · 2019-09-01T13:27:20.960

3

you can use this command which will ask for a password and download your database into the current directory

 mysqldump -u root -p database> dump.sql

if you are form windows use PowerShell administrator mode and if you are using Linux use Sudo command. Then run those query.

You can also follow below steps

Step -1 First download SQLyog https://sqlyog.jaleco.com/, then install it.

You will get something like Now create a new connection for your localhost then connect to your remote database. You must remain connected to both servers together.

Step -2 Then right-click to your remote database you will get the following options.

step-3 Now click copy database to a different host then you will get another window like

step-4 Finally, select localhost and your database from the dropdown option. If you want structure and data check below option. Then click copy. The database will be copied. Due to my old version interface could be different but process will remain the same.

edited Sep 01 '19 at 13:27

answered Sep 01 '19 at 13:02

ANIK ISLAM SHOJIB

3,002
1
27
36

actually, I want to use the database from one system to another. Is there any way to do that? – farhanlq Sep 01 '19 at 13:06
What do you mean my one system to another system would you elaborate please – ANIK ISLAM SHOJIB Sep 01 '19 at 13:07
I have a database which contains some tables, now I want to use that database to my laptop, or you can say I want an exact replica of my database into my laptop. So how can I do that in SQL workbench we can export the database and it generates a SQL file which we can execute in another system and the database with tables is generated? – farhanlq Sep 01 '19 at 13:10
You can use SQLyog which will connect with both of your databases then you can simply copy your remote database into a local database. – ANIK ISLAM SHOJIB Sep 01 '19 at 13:13
Or in simple term, I want to export my database to a SQL file. How can I achieve that? – farhanlq Sep 01 '19 at 13:13
I'm updating my answer check that – ANIK ISLAM SHOJIB Sep 01 '19 at 13:13
ok, sure I will. – farhanlq Sep 01 '19 at 13:14
Try the 2nd process will be easier for you – ANIK ISLAM SHOJIB Sep 01 '19 at 13:27
Please give upvote if it helps – ANIK ISLAM SHOJIB Sep 01 '19 at 13:58
I tried the above query but it says, access is denied. – farhanlq Sep 01 '19 at 16:48
what kind of system you are using?? windown or linux – ANIK ISLAM SHOJIB Sep 01 '19 at 16:57
I am using windows – farhanlq Sep 01 '19 at 17:05
1

Search for Powershell in your windows then right-click on it then select run as an aminstrator, then run ``mysqldump -u root -p databaseName> dump.sql``. Your mysql password will be asked, just give that password then sql will be dumped into your current directory – ANIK ISLAM SHOJIB Sep 01 '19 at 18:02
Thanks, I tried the above snippet and it works. – farhanlq Sep 02 '19 at 09:22
Then please accept my answer – ANIK ISLAM SHOJIB Sep 02 '19 at 09:24

Is there any way to export a database using MYSQL Command Line Client?

1 Answers1