Re: [SLUG] mysql restore

On Wed, August 18, 2010 4:54 pm, Ben Donohue wrote: > I'm doing a mysql restore to a new server that has a mysql database on > it. As in just installed mysql. > > show databases shows two databases "mysql" and "information_schema". > > My backups from a previous server has many db's including two

Re: [SLUG] mysql restore

Hi Ben, > I'm doing a mysql restore to a new server that has a mysql database on > it. As in just installed mysql. > > show databases shows two databases "mysql" and "information_schema". > > My backups from a previous server has many db's including two called > mysql and information_schema. >

Re: [SLUG] mysql restore

Thanks Rick, did exactly that and working well now. Thanks for you help. Ben On 19/08/2010 6:06 AM, Rick Phillips wrote: Hi Ben, I'm doing a mysql restore to a new server that has a mysql database on it. As in just installed mysql. show databases shows two databases "mysql" and "informati

Re: [SLUG] mysql restore

I replaced all except those two and it seemed to work ok. Not sure that they are needed or connected to the other db's. I was going to restore them if needed but it looks like they are not. Thanks for your reply. On 19/08/2010 12:16 AM, Voytek Eymont wrote: On Wed, August 18, 2010 4:54 pm, Ben

Re: [SLUG] mysql restore

mysql contains info that mysql uses for things like user accounts, permissions and the like information_schema keeps information about the databases etc inside mysql. Basically they do not contain user data, however you may wish to copy across the mysql.users table or at least the elements that

[SLUG] Retail/out of the box Hardware running Linux - show and tell at SLUG meetings

At the July SLUG meeting, Jim Donovan talked about micro linux - the FriendlyARM micro 2440SDK For a time there was the Kogan EEEPC. and Zonbu http://blog.tomw.net.au/2007/11/zonbu-t

[SLUG] University of Sydney - Career Opportunity of Interest

SYSTEMS ADMINISTRATOR – IDENTITY & ACCESS MANAGEMENT INFORMATION AND COMMUNICATIONS TECHNOLOGY REFERENCE NO. 2109/0710 · ˱ Prestigious international university · ˱ Provide large enterprise level IT infrastructure services · ˱ Negotiable salary The University of Sydney ha