MySQL import database
 

Sorry for the silly question: how can I import a mysql database on another pc (not in the same lan)? Is it enough to copy all the folders?
Sorry again... :rolleyes:

Byez!

First you export the database from mySQL:

(terminal, not in mySQL)
mysqldump –u user_name –h localhost –p db_name > file_name.sql

Then you send it to the PC you want to and then you import it in that PC's mySQL database with the same command but using "<" instead

First you export the database from mySQL:

(terminal, not in mySQL)
mysqldump –u user_name –h localhost –p db_name > file_name.sql

Then you send it to the PC you want to and then you import it in that PC's mySQL database with the same command but using "<" instead

Thanks, thanks very much.
Have a good day!!

Byez!