forums › forums › SQLyog › Using SQLyog › How do you reload the database
- This topic is empty.
-
AuthorPosts
-
-
July 29, 2003 at 4:34 pm #8118BooBooMember
I thought that I saw that you could reload MySQL database. I know that this feature is available in phpMyAdmin, but I was sure that I saw it in SQLyog.
Am I mistaken or did I miss it?
-
July 29, 2003 at 4:42 pm #14731RiteshMember
Do you mean Reloading Database from SQL Scripts?
-
July 29, 2003 at 6:52 pm #14734BooBooMember
I think that I found the information that I was looking for on the http://www.mysql.com site. There is a command to reload the privileges table. This is required after adding a user/modifying the permissions (grants) that a user has.
You can issue a reload command, which flushes the grant table. It appears that another method of doing this is to use flush-privileges, which reloads the grant table.
I was able to find this command under Tools -> Flush. I can then select which tables that I want to flush/reload.
Since I had always used the reload command, I was not familiar with the flush command(s). Now I am and see that I need to use.
Thanks for the responses! 😀
Keith Roberts
IT Manager
Your source for laptop batteries, pda batteries, digital camera batteries, and cell phone batteries
-
July 29, 2003 at 6:54 pm #14732BooBooMember
In phpMyAdmin, you have to reload the database after adding a user or modifying the users permissions. This is the reload that I am referring to. If it can be done via a script, then what is the script command to do this?
Thanks!
-
July 29, 2003 at 7:13 pm #14733RiteshMember
Can you elaborate?
I guess I am not able to understand you problem….
-
July 30, 2003 at 7:00 am #14735ShadowMember
FLUSH is a standard MySQL command, you can read more about it in the MySQL manual's 4.5.3 FLUSH Syntax chapter.
-
July 30, 2003 at 9:20 pm #14736CalEvansMemberBooBoo wrote on Jul 29 2003, 06:54 PM:In phpMyAdmin, you have to reload the database after adding a user or modifying the users permissions. This is the reload that I am referring to. If it can be done via a script, then what is the script command to do this?
Thanks!
This is more of a defect in phpmyadmin than a feature than needs to be in sqlyog.
If you use the user/permissions manager in sqlyog, you can make changes without having to FLUSH PRIVILEGES
If you edit the permissions tables in the mysql database directly, then you do have to issue a FLUSH PRIVILEGES before the changes will take affect.
You can issue any of the FLUS commands form the command window though. The only thing you can't do is restart the service. (and I argue that that is a 'feature' you don't want in a client!)
HTH,
=C=
-
-
AuthorPosts
- You must be logged in to reply to this topic.