Computer and Programming VFP

Are you have trouble to open database MySQL here i will show you in 4 step : 1. First Backup your database folder make sure you have 3 file and 1 folder frm(database name) or 2 folder or have more folder frm backup all (remember) - ibdata1 - ib_logfile0 - ib_logfile1 - Folder database frm 2. see what trouble you have - Access denied for user 'root'@'localhost'(using password:YES) if you try and try reinstall mysql but security not apply answer: - delete folder mysql in folder data - reinstall mysql - copy all folder frm and 3 file ibdata1,ib_logfile0,ib_logfile1 3. you should try to open database, and if you can open your database enjoy. 4. If you still can't open your database please send me email elchansoft88@gmail.com i will help you as soon as possible

As we know, speed is always the most important element in developing a website especially for those high traffic database driven website. You can try to turn on query cache to speed up query. To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini) - 1st, set query_cache_type to 1. (There are 3 possible settings: 0 (disable / off), 1 (enable / on) and 2 (on demand). query_cache_type = 1 - 2nd, set query_cache_size to your expected size. I’d prefer to set it at 20MB. query_cache_size = 20M If you set your query_cache_type = 2 ( on demand ), you would wan to modify your sql query to support cache. SELECT SQL_CACHE field1, field2 FROM table1 WHERE field3 = ‘yes’ To check if your mysql server already enable query cache, simply run this query:- SHOW VARIABLES LIKE ‘%query_cache%’; You will see this result:- +——————-+————————————————————————+ | Variable_name | Value | +——————-+———————————————

Example: BEGIN SELECT * FROM CITY WHERE CITY_NME=NAME; END Save Store Procedure with TEST name ***** In Paramter Textbox fill with NAME CHAR(20) click run an entry "BATAM" or what ever CITY name the query should be display with city fill **************** now how to call within VFP **************** Here an example: MYSTS = "CALL TEST('BATAM')" SQLEXEC(1, MYSTS, "MYCURSOR") SELECT MYCURSOR BROWSE

Ahhh, IIS, gotta love it. Nothing can ever be easy. So, as I am trying to install IIS on my Dell that I just reformatted, I get this: Cannot find the file STAXMEM.DL_ in my C:\i386 dir. hmm…. well, after a little looking, if you run this command esentutl /p %windir%\security\database\secedit.sdb If you then retry the install, it should work