MySQL import database

akines · 04-18-2006, 04:06 PM

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...

Byez!

zener · 04-18-2006, 04:13 PM

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

zener · 04-18-2006, 04:13 PM

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

akines · 04-19-2006, 02:14 AM

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

Byez!