[gutterboy]

'peterlaursen' wrote on '28:

if you have a (file-based) backup of you mysql data folder, you can simply copy the …mysqluser folder and restart MySQL.  This can be done for MyISAM tables like this (and the 'mysql' database is solely MyISAM tables).

Hey there…… yeah, I tried this before but MySQL wouldn't start…. but ended up figuring out all I needed to copy over was the db.* & user.* files. 🙂

Thanks for your help!

[gutterboy]

Yes… I realized that this had nothing to do with SQLYog after I posted it, but just thought I would leave the post anyway as maybe you would be able to guide me on where to find the users.

Quote:

SQLyog will query the server about user accounts information. It does not (and cannot) have this information 'client-side'. User tables are stored by the server – not the client. If you have reinstalled Windows + MySQL you have deleted the users installed in MySQL – unless you backed up the 'mysql' database.

If you reinstall Windows + your Word Processor you will also lose everything unless you backed up your documents. What do you expect when you reinstall the OS?

Well as I said above, I did make a backup of everything…. I was just wanting to find out where the user information was stored so I could restore it all… you mentioned the mysql database….. I actually did restore that folder but still didn't get my users back….. maybe I did something wrong…. I will try again.

Thanks! 🙂

[Author]

Posts