" yes "
What should be done is to use mysqldump.exe to get a backup of the original database- you can then restore whatever parts you want. (other than the INFORMATION_SCHEMA -- becasue that would destroy the database)http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
that SQL service has to be running
command line is (in that installation's mysql/bin folder)
- Code: Select all
mysqldump.exe --databases nameofdatabase -- user root --password rootpassword > targetsqlfilename.sql
you can also dump certain tables if you require - the output file is plaintext SQL statements that will recreate whole databases if needed.