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
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?
>
> ---
>
If you can mount the Windows partitions under LINUX, you can copy file files
from partition to partition. If that's not possible, you'll have to export
the data under Windows to another location/media, then boot into LINUX and
load the data into your LINUX database.
You can dump the databases fro
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
