Mysql and VirtualBox

[Sara]

Dear All,

Recently, I had installed VirtualBox in Debian Sequeeze distribution ..

I just had a question about importing a huge database on my real machine to my virtual machine using mysql ?

Anyone has an idea about that ?

Thanks a lot
Sara

[vbox4me2]

Such as?? just do it, I run mayor sql and mysql clusters as VM's, no problem whatsoever.

[Sara]

Thanks..
Actually, I know that but is there anyway that avoids installing mysql cluster ??
Iwish to import the DB once and that it all ..

[vbox4me2]

Basicly all a mysql database is, is a bunch of files, you can commandline run any mysql server, copy over the files, adjust the ini file and fire it up. The same goes for SQL server but a bit more tedious todo the same with logfiles. There's no real need to 'import' anything if its the entire database. In cluster mode run mysql as any-master mode, in sql cluster mode just ignore missing mirrors and such messages.

[Sara]

will do that..
Thanks