I do this all the time at my work for really large tables. Just scp, ftp the entire data directory over to the linux box and restart the MySQL service. The only addition thing you might want to do is compress the file before sending them just so you have some way to check them and tables usually compress very well.
On Tue, 2003-11-04 at 11:21, Matt Babineau wrote: > Well, he could do that but being inexperienced with Linux, I figured it > would be more beneficial to use a familiar WYSIWYG so he doesn't blow > and hour playing the with CLI like I did :) > > On Tue, 2003-11-04 at 16:58, Big Brother wrote: > > err why not do a mysqldump then just import that? > > > > --- > > > > > > Quoting Matt Babineau <[EMAIL PROTECTED]>: > > > > > Check out SQLYog, could can connect and copy databases...pretty much > > > like MSSQL Enterprise manager. They have a trial version on their site: > > > http://www.webyog.com/sqlyog > > > > > > > > > > > > On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote: > > > > Hi there, > > > > I have taken the plunge and dropped windows in favour of linux. My > > > > question is what is the best way to get the data from my windows mysql > > > > databases into linux? Can I just copy some files from one partition to > > > > another or what? > > > > > > > > Thanks, > > > > > > > > Matt > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- Benjamin Arai <[EMAIL PROTECTED]> Araisoft Corp.
