PHP / MySQL - Localhost与Web服务[重复]

Question

This question already has an answer here:

• How to export and import a .sql file from command line with options? [duplicate] 8 answers

I'm very new to PHP and MySQL, so this question might sound really dumb, but I am genuinely curious about the answer.

Using some tutorials, I'm creating a user login/registration system with the PHPMyAdmin and SQL tools given by MAMP for Mac. I later want to upload this whole database on a specific page of my website. My website, though, is hosted on another web server, not locally.

My question is: will I have to remake the user login/registration system when I upload all of my website files to the external web server, or will all of that be retained?

Maybe my understanding is flawed, but hopefully someone can shed some light.

</div>

Answer 1

Dump your local database to an SQL file:

mysqldump -u username -p yourdatabase_name > backup.sql

Import the SQL in to your remote database:

mysql -u username -p yourdatabase_name < backup.sql