copy mysql database in linux

peterhsy · #1 (**permalink**) 04-17-06, 10:42

How to copy mysql database in linux and use it on windows

jfulton · #2 (**permalink**) 04-18-06, 17:04

Well, since this question hasn't been answered before...

Quote:

The most common use of mysqldump is probably for making a backup of an entire database:
shell> mysqldump --opt db_name > backup-file.sql

You can read the dump file back into the server like this:

Code:

shell> mysql db_name < backup-file.sql

Or like this:

Code:

shell> mysql -e "source /path-to-backup/backup-file.sql" db_name