How to export mysql database with terminal

May 29, 2017 131.5k views
Ubuntu MySQL Ubuntu 16.04
levan100
By:
levan100

Hello Everyone

I want to get (export) mysql database , i cant use this url http://site.com/phpmyadmin
because does not exists i have already installed phpmyadmin in terminal but there is nothing, so i decide to export database from terminal , do anybody knows how to export mysql database from terminal

i used this code
mysql -u [username] -p newdatabase < [database name].sql

maybe a database exported but where is that files location dont know :/ i want just sql file

thanks

Sign In to Comment
2 Answers
levan100 May 30, 2017

hansen

Thank you so much, you really helped me.

PS:
Digitalocean Support is USABLE AS MEAT OF DONKEY
NO ONE HELPED ME IN SUPPORT TICKET WHICH I OPENED ,THEY ARE ALL BOT

Report
hansen May 29, 2017

Hi @levan100

The code example you’ve supplied is for importing data - not exporting.

You should use mysqldump, since it tries to do the data dump without blocking the database tables.

mysqldump -u [username] -p [database-you-want-to-dump] > [path-to-place-data-dump]

So it could be something like this:

mysqldump -u root -p mydatabase > /home/myuser/database-dump.sql

Then the database dump would be /home/myuser/database-dump.sql

You can read more about mysqldump here:
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

Report
Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Related