How do I insert data from local database to the new database with tables that I have just created in command line?

June 12, 2015 2.3k views
MySQL DigitalOcean PHP Ubuntu
meenasamo
By:
meenasamo

In my local database, I have hundreds of data and it would be a worrisome for me if I have to insert all over again one by one. Is there any way I export the local data mysql to the server database so my website (php) can display those data.
Please help and I would be really grateful.
Thank you.

2 comments
  • sierracircle June 12, 2015

    For your local database you can do this:

    mysqldump  --user=YOURMYSQLUSER --password=YOURPASSWORD  --host=localhost YOURDATABASE > thedata.sql

    which will create a data file with all of your data.
    then, upload that file to your server (your users home directory), and then run this command:

    mysql --user=YOURMYSQLUSER --password=YOURPASSWORD  --host=localhost YOURDATABASE < thedata.sql
  • meenasamo June 13, 2015

    Thank you very much. I got it done. You're awesome.

Log In to Comment
1 Answer
ryanpq MOD June 7, 2016

This question was answered by @sierracircle:

For your local database you can do this:

mysqldump  --user=YOURMYSQLUSER --password=YOURPASSWORD  --host=localhost YOURDATABASE > thedata.sql

which will create a data file with all of your data.
then, upload that file to your server (your users home directory), and then run this command:

mysql --user=YOURMYSQLUSER --password=YOURPASSWORD  --host=localhost YOURDATABASE < thedata.sql

View the original comment

Reply
Have another answer? Share your knowledge.

Related Questions