Question
How do I insert data from local database to the new database with tables that I have just created in command line?
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.
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.
×
For your local database you can do this:
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:
Thank you very much. I got it done. You’re awesome.