How do you reload the database

This topic is empty.

Viewing 6 reply threads

Author

Posts
- July 29, 2003 at 4:34 pm #8118
  
  BooBoo
  Member
  
  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 #14731
  
  Ritesh
  Member
  
  Do you mean Reloading Database from SQL Scripts?
- July 29, 2003 at 6:52 pm #14734
  
  BooBoo
  Member
  
  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 #14732
  
  BooBoo
  Member
  
  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 #14733
  
  Ritesh
  Member
  
  Can you elaborate?
  
  I guess I am not able to understand you problem….
- July 30, 2003 at 7:00 am #14735
  
  Shadow
  Member
  
  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 #14736
  
  CalEvans
  Member
  
  BooBoo 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=
Author

Posts