Question

How to export mysql database with terminal

Posted May 29, 2017 149.2k views
UbuntuMySQLUbuntu 16.04

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

Add a comment
levan100
By:
levan100
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
levan100 May 30, 2017

hansen

Thank you so much, you really helped me.

edited by MattIPv4
Reply 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

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help