Page 1 of 1
Mysql and VirtualBox
Posted: 17. Feb 2011, 19:07
by 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
Re: Mysql and VirtualBox
Posted: 17. Feb 2011, 21:15
by vbox4me2
Such as?? just do it, I run mayor sql and mysql clusters as VM's, no problem whatsoever.
Re: Mysql and VirtualBox
Posted: 17. Feb 2011, 21:29
by 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 ..
Re: Mysql and VirtualBox
Posted: 17. Feb 2011, 22:00
by 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.
Re: Mysql and VirtualBox
Posted: 17. Feb 2011, 22:04
by Sara
will do that..
Thanks