OK, Samba to the rescue with the copy, but could not get the new database
recognised by the mysql server, regardless of mysqladmin, refresh, flush,
reload. However when I stop and start the server it works!
At 14:28 9/04/2001, Damien Gardner Jnr wrote:
>On Mon, Apr 09, 2001 at 02:15:33PM +1000, Simon Bryan said:
>--> mine complains about the mysql#, am I reading that too literally?
>Hey Simon,
>
>Ahh, sorry the first bit was just the shell prompt.. :)
>from the /var/lib/mysql directory, run:
>
>scp -r oldserver:/var/lib/mysql/dbname ./
>
>MySql just stores each database in it's own directory inside
>/var/lib/mysql, with a separate couple of files (index, data, etc) for
>each table, so you can just copy the directory across to another machine,
>and it works fine.. That's assuming you've got ssh access on both
>machines.. - otherwise you'll have to tar up the directory, ftp it across
>or something, and un-tar it on the other side..
>
>Hope this helps :)
>
>Regards,
>
>Damien Gardner Jnr - Dip.EE StudIEAust
>[EMAIL PROTECTED] - http://www.rendrag.net/
>Ph: 0417 055 052 - Fax: 02 6255 8663
>-- It's sick the way you people keep having sex without me
Simon Bryan
____________________________________
IT Manager
OLMC Parramatta
http://www.olmc.nsw.edu.au
____________________________________
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug
