l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
December 2: Social gathering
Next Installfest:
TBD
Latest News:
Nov. 18: Club officer elections
Page last updated:
2009 May 21 21:29

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] NIS and MySQL migration
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] NIS and MySQL migration



On Tue, 2009-05-12 at 12:47 -0500, Ken Bloom wrote:

<snip>
> 
> The fourth machine, which I haven't touched yet, runs a MySQL
> database, and is the NIS server for the other three machines. I now
> need to upgrade these machines subject to 3 constraints:
> 
> 1. The mysql database must not be lost, and I must be able to move the
> data reasonably quickly. (Downtime is OK since it's not public facing,
> and gets sporadic use, but forcing me to dump/reload would be a royal
> pain because one of the databases contains 15GB of linguistic data.)

Very easy: Copy the three, raw, MySQL database files for each table to
the new computer. The filenames have the following format: $table.frm,
$table.MDY, and $table.MYI, depending upon your version.

On my MySQL installation, they're located in /var/lib/mysql/$database.
Also, you can check /etc/mysql/my.cnf and search for the keyword
"datadir".

<snip>
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.