Recent Posts

326

General Software Discussion / Re: Changing from MyISAM to InnoDB in MYSQL DB

« Last post by questorfla on January 03, 2015, 06:42 PM »

That could be it as the error I got was something about invalid values.  What I changed was the TYPE=MyISAM to ENGINE=MYISAM as I had been told of that change.  but I knew there had to be more than just that. And it is a long jump from 5.1 to 5.5.  Additionally I ran into some issues in PHP handlers.  Way over my capabilities in that department.  That is why I gave up Software support of Hardware support.
But lately even hardware has begun to morph at a rate faster than I can keep up with it.
At least I feel a little better to know I am not alone in my despair.

327

Living Room / create a list of paths to a speific subfolder name underneath a parent folder

« Last post by questorfla on January 03, 2015, 06:36 PM »

Short of loading up on GNU commands is there an easy way to do this?   MS completely left out all ability to specify any boundaries on the "dir" or "search" or any other windows/dos commands.  I need a list of all the paths to subfolders named "cache" underneath a parent folder.  Most are at the 2nd level and none are more then 3 or 4.  I had thought maybe Dos "find" might do it but they have no recursive abilities or if they do they won't for me.  I end up being the one doing al the "curs" ing  instead.  I also tried to preload the Utility "everything" to just look for every occurrence of that name using the Parent folder as a starting point but for some reason even that doesn't want to cooperate.
If I run the search inside the parent, there will be many of these subfolders named "cache".  While the cache subfolder may contain other subfolders I only need to get a list of paths to the top level "cache" subfolder.  A simple text file would be nice showing the full path all the3 way back to c:\.

328

Coding Snacks / Re: The Best Way to handle finding and removiong Duplicate Files

« Last post by questorfla on January 03, 2015, 06:17 PM »

THANK YOU TOMOS!
I fixed it I hope.  In the future I will try to be more on target as well.

329

General Software Discussion / MySql ver 5.3 <>ver 5.6 and MyISAM tables/deprecated terminology

« Last post by questorfla on January 01, 2015, 04:48 PM »

I wondered if anyone has made the transition from that far back and if so whether it would be easier to rewrite a SQL template using current MySQL  than t would be to modify an existing template created for use with 5.3 especially in light of the MyISAM table structure being demoted in favor of InnoDB?
After making a few changes such as:  'TYPE' now = 'ENGINE' and such I am still not able to get a working script made for 5.3 converted to load the tables structures under ver 5.6 without errors of one kind or another. 

330

General Software Discussion / Re: Program to copy contents of a cloud drive to a local drive -slowly

« Last post by questorfla on January 01, 2015, 04:19 PM »

Happy New Year to everyone!
Thanks for all the good suggestions.
One or more of you mentioned the use of the sync provided by the Cloud Service.
Yes, they DO provide "something" that should od it.
BUT with the caveat (provided by them) that in a case like I have now, where I first need to get a local copy equal to the cloud copy, they say to use their "restore" feature.
It got kind of complicated because of various differences in naming and the fact that the only way I could TELL what was IN the cloud copy anyway was to copy it all down.
Running any kind of "dir" check or any other on the map cloud drive gave me totally incorrect answers.

I Knew that there were more than it said there was.  But the only way to Prove it was to copy every single file down to "earth" again.  Which I began doing over the Holidays.  And I have to do this one folder at a time or sometimes one subfolder at a time if they have a lot of files.  If I don't, I start getting a ton of "errors" that show up in a "window" in their application.  These "errors" are also "too late" to do anything about.  This is all due to the way they have this whole mess configured to work through a "hidden cache" folder on the server in Program Data.  Long story but.. the best (and only working) sync app I ever found was AllwaySync. 

The company is named JungleDisk and they sell Rackspace storage through their own apps.  I had to use them due to a need for being able to have the storage accessible to the user via a mapped network drive and this all started before windows 8 was released.
Windows 8.1 I had hoped would give me a better way since it is supposed to provide native support for drive letter mapping to FTP folders but if it does, I can't get it to work.  Not without using NetDrive or Webdrive

I still don't fully  understand why those apps can so easily handle the change to a drive letter while windows (even though it SAYS to click here to get easier access via mapped drive" simple wont do it.  The best you can get is a mapped network place. which won't work for the program that needs access.  It can ONLY recognize a mapped single drive letter.

If anyone knows a way around the windows limitation please let me know.  This is also partially the reason I could not use OneDrive for the same storage.  We have tons of Free OneDrive space but I cant Map to it so.. I cant use it either.
(It also originally had a lot of other limitations but I  have had a lot of material supplied by Microsoft that indices some big changes coming this month, Jan 2015. re: One drive and I still have hopes for it)

331

Coding Snacks / Re: The Best Way to handle finding and removiong Duplicate Files

« Last post by questorfla on January 01, 2015, 04:01 PM »

First:  Happy New Year to all.
2nd.  Tomos:    I can't see a way to change th tile of an existing post?  Maybe here is one but nothing  I clicked on would get me there.
I appreciate everyone's good advice and even if it doesn't help ME, I am sure someone who reads these posts can use something of it.  Tough I agree I should have been more on topic when I named it

3rd:  Stoic.  This DE-duplicator in server 2012 sounds great and I can probably manage that.  I had looked at 2012 a while back but not sure what version.  Whatever it was, it seemed to be a command line only version of some sort, I am not sure I ever looked at a full GUI setup and probably should.
Thanks again to all.

332

General Software Discussion / Program to copy contents of a cloud drive to a local drive -slowly

« Last post by questorfla on December 22, 2014, 06:32 PM »

I guess that is the best way to put it.  I have a need to get the contents of our CLOUD storage onto a local system.  This is a pretty big pile of files and while I can sit here and manually do this one folder at a time, I would rather not as there are several hundred folders.  My first though was to simply run a SYNC program but I really don't need a Sync, other than maybe as a "one-way" thing.  There is nothing to Upload or sync back to.  I just need to "back-up" the Cloud.

I have used a couple like 'All-way Sync' before and maybe that is still the best way to go.  Some of the Sync programs tend to get Overly in a hurry which in this case I am not and preserving enough bandwidth to function would be a main concern. 

I need to download about 60GB of files.. Slowly!  Which in most cases is not what people are after. Using Windows, for instance, is hopelessly chaotic.  At least the GUI part.   If I try to drag and drop the whole thing at once it always crashes.  Folder by folder works but is getting tedious. 

Maybe a program that would drag and 'drop-to-copy' one folder at a time and do the next when the first is done?  Or a program that gave a way to limit the number of files it would try to copy at once?  Some way to limit the amount of computer overhead and bandwidth use so that everything copies... eventually.. and the system can run normally all the while albeit a little slower? 

The Cloud drive is mapped as a network drive and I have already begun the local folder copy of it but ran into these issues and thought I would see if anyone else has ever tried to "back-up" out of a cloud before and knew a better way.    Every time I Google Cloud Backup .. Well I am sure you know what I find,  Everyone going the Other Way

333

Living Room / Re: Website access for someone in a temprarily Down Zone

« Last post by questorfla on December 18, 2014, 05:47 PM »

And thanks to you as well Shades.  I explained the dilemma to them as well.  One is the company owner here where I am the IT department.  SO..... I just take it as it comes.   I explained everything y9ou just went through to them.
Just FYI, I did try direct IP as I did a remote session to their system.  No Good.  So something in their Internet cant even locate my IP.

There is something not working in Philadelphia right now,  I also found that report.  And being the "overkill" type I ran Speed test checks to PA as a whole state for every server there.

Speed tests showed about a .9Mbps down and .1Mbps UP .  The same test to some remote outcrop in South Dakota showed 150+ Down and 25+ UP .  (of course I also got those results to almost anywhere BUT  Pennsylvania.

So I am in the clear for my performance but.. It is my duty to at least try.

334

Living Room / Re: Website access for someone in a temprarily Down Zone

« Last post by questorfla on December 18, 2014, 05:39 PM »

Many thanks and I LOVE the idea of a portable browser.  YES!  100% they travel a lot and this particular time they were with a GROUP who all needed access.  I could allow ONE person to link back direct (i.e.: rdp or similar) but that would not have helped as they were making a presentation and needed all of them to get in and no one at the entire Hotel could.
The Hotel of course Blamed Me!  So I was forced to prove it was them.  But this infighting did nothing to solve the problem nor prevent future occurrences so I really appreciate this.  I was also looking at PROXY which would allow one person ONCE they were able to connect to share that same connection locally.
Have you ever tried configuring a portable (read> flash drive) install of IE using this?  So they could run it ONLY in emergences as this one without worrying about any possible affects to the copy of the browser on their system?  As in plug in flashdrive and have it auto run with the tunnel client app already in it.
When done, remove flashdrive and reboot?   I need to be able to be 1000% certain that they could not accidentally do anything to their normal setup since this is a once in a blue moon occurrence caused by forces unknown at this time.  I cannot risk making any changes to their normal browser or laptop

335

Living Room / Website access for someone in a temprarily Down Zone

« Last post by questorfla on December 18, 2014, 04:32 PM »

Anyone know of a way I can help someone get access to our website if the area they are in is having "problems".  I think it has to do with DNS but cant prove it.
If they run "IsItDownRightNow.com" it says the website is UP and must be down just for them.
We have had this happen before along similar lines.  I have checked from coast to coast and cannot find anyone who cannot access the site or the IP.
Does IE or Firefox offer any methods of rerouting their requests through to a different area via proxy or >??  It was important enough to the people who wanted to connect  to ask but I don't know what to tell them as I have never had to deal with it,  Things like that usually fix themselves (and may eventually for them).  At the same location they were able to access no problems last week so I am leery of going to far with trying to change anything but if I could provide them with a way to "get out" to somewhere that the Internet was better served I would.  They have a perfect signal at a large Hotel and are able to get to a lot of places .  Just not here. 

336

General Software Discussion / Re: auto switching of network drive mapping

« Last post by questorfla on December 18, 2014, 12:54 AM »

Oh well.  Backup and Punt on both fronts I guess.  

NetSetMan looks good in description and maybe it is just me but it hit all around the problem without actually giving me what I need.  I have seen such a program somewhere that is like a pumped up version of netsetman.  I remember it allowing you to set up such a way that even included what printer would be the default for a given profile.  I guess i can write s imple script with net use to kill the one mapping path and use the other.  But Hope Springs Eternal.  Maybe... It's outr there somewhere.  Because its a little more complicated than that.  

While in office it has to use an actual mapped network drive to get to R: , if NOT in the office, it has to run NETDRIVE2 to create the FTP mapping for the exact same drive letter but get there with FTP.  I have already played enough with netdrive to know that it isn't happy if there are any leftover maps that USED to be connected to that same setup with normal networking

I am tempted to try amputating "mountpoints2" from the registry before letting netdrive even run. It just gets recreated anyway.
 
These are people who I guarantee will shut the lid on their laptop putting it to sleep and while it "dreams" about the old "\\10.0\x.x.x\sharedfolder" connection being mapped to R: and wakes up in a Radison Inne somewhere, connects to a 192.168.1.x dhcp and cant find the way to get to the files on R:.  In their case, NetDrive2 won't even run automatically since they never turned the sytem off.,  ANd if they RUN it, it will try to do a real FTP connect to the Server's Working FTP connecton but fail because the internal Windows config still shows the user connected via another method (The old 10.x.x.x\sharedfolder).  

So it gives an error report which no one will understand.  EASY to fix.  IF! they Reboot.  But they won't.    A scripted app to close the old drive setup and /Disconnect and remove it completely is probably the only sure way.  Then continue run Netdrive2 which will have no problem making the FTP connection to the public IP.  Either way, it is the SAME files on the SAME Server.  I just have to get them in through a different type of door.  FTP has checked out so far to work every time at any location so it beats out trying VPN's that connect every time but wont allow a mapped drive letter much of the time, giving only a "network Place".  This used to be so simple to map drive letters over IP across the net.  Those were the days.  I can also add in the removal of the primary printer so they can grab whatever is where they are because most of them don't know that the default printer STAYS as the defrault printer until they change it.  That is a feature you would think MS would have already added.  Maybe by Windows 14.  ?  
Sometimes I feel like I work for a 3rd World (no  make that 4th or 5th world) company where technology has yet to arrive and most are better off with pencils and REAL "Paper Notepads"  not "Notebooks".  If I told them i could get cheap paper "notepads" that had an unlimited Battery Run time they would jump all over that before anyone ever figured it out..

337

General Software Discussion / Re: auto switching of network drive mapping

« Last post by questorfla on December 17, 2014, 02:50 PM »

Thanks 40hz.  I think you hit the nail on the head.  The program called NetSetMan sounds very much like it.  This was maybe a year or so ago it seems.   I was looking for the same thing then but for a slightly different reason.

By the way, do you happen to know WHY I can map a drive letter to an FTP drive using NETDRIVE2 with Zero problems but cannot do the same thing with any other program.  WEB-DRIVE works but NETDRIVE2 is Free is used for only 1 drive (it says).  Windows also "says" it can map to an FTP with no problem and it appears to allow you to do so but when done, you still only have the old "network place" as always.

There has to be some simple tweak to the ftp settings because that is all I need.  I know that it took me forever to figure out the trick to getting a mapped drive to Windows OneDrive.   It was all in how you worded the connect string PLUS you  had to add the site to IE's SAFE SITES and I am starting to wonder id UAC has anything to do with it.

338

General Software Discussion / auto switching of network drive mapping

« Last post by questorfla on December 17, 2014, 01:04 PM »

I know here is a way to do this.  There may be both a commercial program as well as a simpler method but i have seen it somewhere.
When users are Inside4 an office network they have access to a folder on a server that is mapped as a local network drive on the office subnet.
When they leave, they need to also access this same folder but it will be via FTP.  And in both cases the drive has to remain mapped as a specific drive letter.  That is the trick that I am having problem with.
Short of writing a script they would have to run when not in the office, I have seen a utility that can do this based on the IP address in use by the NIC. If they are on the Office IP, it maps the drive to the local IP it is on.
If they are anywhere else BUT the office IP, it can be set to use various other paths to reach that same drive.
Windows has no problem mapping it to Both a local drive letter AND a network Place Via FTP but the need is for the Drive Letter Mapping to switch from a local IP to using the Network Place sort of automatically.
Any Ideas appreciated but the key is the drive letter used MUST stay the same whether inside the office on local mapping or outside on mapped FTP access.
Thanks

339

General Software Discussion / Changing from MyISAM to InnoDB in MYSQL DB

« Last post by questorfla on December 10, 2014, 07:21 PM »

Given the following statements in a "template.sql" used as the starting point for building a MySQL DB.

Code: Text [Select]

1. DROP TABLE IF EXISTS `cat_permissions`;
2. CREATE TABLE IF NOT EXISTS `cat_permissions` (
3.   `category_id` int(11) NOT NULL default '0',
4.   `user_id` int(11) NOT NULL default '0',
5.   `permission` enum('View') NOT NULL default 'View',
6.   PRIMARY KEY  (`category_id`,`user_id`)
7. ) TYPE=MyISAM;

If I change the 'Type' to "Type=InnoDB" ...        When I run the install, I just wondered what the chances of it working?   I would like to convert a DB from MySQL to InnoDB and not real sure about the consequences of the making the change.  Either that, of find out why this won't run under MySQL Vesion 5.5, or any version since 5.1

340

General Software Discussion / Re: Where is select all?

« Last post by questorfla on December 09, 2014, 02:03 PM »

yeah, i know.  I am a ctrl+a ctrl+V Ctrl+P etc guy too but this was something i was asked to show someone and they are NOT a keyboard shortcut type.  In addition, I noticed that for some reason I have a completely different type of ribbon than they do.  I still don't know what's up with that.  Not sure if i t is something I installed or if I am actually running a different version of windows 8.1. 

Mine has all kinds of "stuff" in it and isn't even always there.  When it is, it shows options theirs doesn't. 
It is possible that the system in question was ordered with 8.1 pro instead of home premium but i did not know the ribbon would be different.

341

General Software Discussion / Re: If someone can tell me where i am missing the boat on this Mysql script?

« Last post by questorfla on December 08, 2014, 06:01 PM »

OK Solved.
No password needed but location when runing the command is essential.  I tried this using a "fake" location for %main% and it failed.

Code: Text [Select]

1. set db=joe
2. set main = (this variable must be the full path to the databases normal location I think )
3. cd %main%
4. mysql -u root  -e "CREATE DATABASE IF NOT EXISTS %db%";

This returned no errors and checking with PhpMyAdmin showed a nice MySql DB empty and waiting to be loaded.

Thanks for the help. and maybe this will be of some use to someone one day.

342

General Software Discussion / Re: If someone can tell me where i am missing the boat on this Mysql script?

« Last post by questorfla on December 08, 2014, 05:12 PM »

I would bet you are correct.  Adding a password to the MySQL access for root may be the best way.  This is something that in my opinion SHOULD be there anyway but the people who wrote the original script recommended that I leave it blank.

I do not know why but always have done as they said.  Not having a PW and trying to connect through a script sounds very likely though and I will know in just about 10 minutes as I skipped that part and went on with the rest. 
I am now ready to compile and the only holdup is the darned DB.

That and I am not sure about the correct method of continuing the operation of what is now a PHP script normally accessed via web that I will be finishing inside the batch if possible.  This is all part of a long drawn out install procedure for a tiny website

343

General Software Discussion / Re: If someone can tell me where i am missing the boat on this Mysql script?

« Last post by questorfla on December 07, 2014, 09:33 PM »

will try that next.  Still reading a ton of places where others asked about creating a MySQL DB in a batch file and so far I just don't see what I am doing wrong.  Thanks for your input.  This has gotten to be a really out of control project.  One that is more a challenge than a real need.  Skipping over the DB creation for the moment I finally got to the "good part" where I have to edit a couple of php files inside the bat.  The whole thing is just a long running procedure that I normally just type in and get it done but I wanted to see just how far I could go with automating the whole thing.  It only has two inputs from me and the rest is using those inputs in various places to do different things.  Perfect setup for a batch script  but it has been years since I worked with system variables like chdir etc. to get the path to the files I need to edit stored in a variable long enough to do the deed. 

I'm getting there but... If I could just stick with it till done but it is Monday tomorrow   and back to day to day grind.  I will probably forget where I was at by next weekend 

344

General Software Discussion / Re: If someone can tell me where i am missing the boat on this Mysql script?

« Last post by questorfla on December 07, 2014, 08:00 PM »

yes  the errors I get all seem to be saying I am not connecting to MySQL properly as though the name "root" or the password of "nothing" is somehow not getting me into MySQL.  Since this is a line in a windows batch file I cannot have even one error in spacing or anything else or it all gets tossed out.  Once I enter MySQL the rest of the statement has to be a perfect fit so that the ";" at the end puts me back into windows with the DB created.

I tried adding the -e to see what the error was and got the whole nine yards.  Every possible one was listed.  One thing I have not check (just thought  about) is the version of MySQL which I doubt is far enough off to be relevant. 
(it is 5.1.57 if it matters).  And Mr. Shades double " %%" is also something that I am not sure about as I am only sot of using his script.  It is more of a uiline in what to do when not exactly HOW I have to do it.

I thought maybe this is one where I have to be inside the "/bin" folder that contains the MySQL.ini or other MySQL parts in order to run?  Maybe add the full path back to the database folder instead of already being inside the db folder when it reaches that point?  Or maybe it is even tied to the location where I start out running the batch file which right now is just a "TESTBED" folder on desktop full of failed tries.
I had assumed that the path of the command structure would follow through the file as each stage is active.  MySQL is the ONLY part that fails.  And no matter where I put it in the run, (The whole thing looks more like SHADES's script as it goes through multiple actions to get everything done)  I might need a set environment variable at the start?  It will be another DUH moment when I find it.

345

General Software Discussion / If someone can tell me where i am missing the boat on this Mysql script?

« Last post by questorfla on December 07, 2014, 05:48 PM »

Code: Text [Select]

1. set /p  db="Enter Search Database Name :  "
2. cd C:\Database
3. mysql -u root -p -e ‘create database %db%’

This is something so simple and I have read multiple "How To" but nothing seems to want to cooperate.
This is part of a batch file where I am trying to create an empty MySQL database in the "c:\database" folder.
I have tried several different versions of the statement but each seems to have something not quite right.
on this system, root (the user) has no password and I can login using PHPMyAdmin and create this same DB with no problem using root and no password to get in.
The more I change the script from simple the worse the errors get but it never creates that DB.
>   4WD , as you already pointed out, I did have to go through this before but the circumstances apparently were different enough that the same statement from that script wont work either.  It has to be something from the way I am trying to use a batch file to run a MySQL command?>

346

Coding Snacks / Re: Quick method to do simple task -must be a one click fix for those who need it :)

« Last post by questorfla on December 07, 2014, 04:08 PM »

OMG!  LMAO!  Thanks so much you guys.  I think the issue is time differences.  I never consider that where some of you are it is still sleepy time.  I had a bunch of frantic people who needed that stupid cfg file edited to a new IP and not one of them is smart enough to just turn on hidden files and manually edit the stupid thing so I spent hours trying to find a way to beat MS at hiding stuff.

The ULTIMATE WINNER was the inno solution and I thank you very much Mr. ATH for that nifty compiler and if you had not taken the time to create that example script I would probably have never been able to figure it out soon enough.

These are people who cannot even extract a ZIP file ( I am dead serious!) so even with a working solution, I still had issues with a bunch of them as they kept trying to run it from inside the zip which was still in the attachment of their email.

The fact I told them NOT to do that and told them specifically how to extract it in the same email notwithstanding.
Anyway, I like the proggy and probably will get the paid version from the site as I can see it being useful again one day.

I have another quick post but it is a different subject so I will run it up the flagpole on another header.
Thanks again to all.

347

Living Room / Re: need a quick fix for something easy. Script to change a single word in text file

« Last post by questorfla on December 06, 2014, 05:55 PM »

OMG!  I solved the problem and I knew there would be a "DUH" factor in it but this one is so big I almost cannot believe it!  Problem solved and I even found others researching how to do this on other forums so I don't feel so bad.  As I expected, I was trying way to hard. 

Solution:  Take the corrected file, Zip it with regular windows 8 compress.  Attach it to an email to send who needs it, they save attachment to desktop (or anywhere). Right click and choose extract and the next step was the solution.

Just change the destination to be c:\programdata\foldername\.  The fact that it neither needed nor asked for any permissions to do this is what I could not believe as this is a hidden folder that needs admin permission to even edit files already there.  Yet it allows you to overwrite the old one with the new one and only has the normal "YES, Overwrite" option no matter who you are apparently.
Anyway, thanks to all those who read and any who offered options  I am sure that the other solutions will come in handy one day but for now, I know how to write files to a hidden protected folder no matter who I am.  Just extract them there.    I even tried putting a copy in c:\windows\system32 just to see what it would do and the worst I got no matter where I chose was a window asking permission to proceed.  it went there every time.   In case anyone ever needs to get files to somewhere they normally can't.

348

Coding Snacks / Re: Quick method to do simple task -must be a one click fix for those who need it :)

« Last post by questorfla on December 06, 2014, 03:53 PM »

If you got it you may see an easier way to do this.
I swear I almost used AHK or some other mouse move capture this is SO easy and simple but if I were to show any of these people HOW to get into hidden files and get Admin permission to their own system it would be opening Pandora's Box for sure!

I can't even email them a corrected copy since THEY could not copy it to a folder they cannot see or have permission to write to.  Yet I KNOW there has to be a simpler way to do this.  I just can't seem to find it.  Probably TOO easy.

At this point though, the Best fix is going to be one I can zip up and email only to the ones who could not run it from the site where I keep utilities for them to use.

349

Coding Snacks / Re: Quick method to do simple task -must be a one click fix for those who need it :)

« Last post by questorfla on December 06, 2014, 03:40 PM »

I already sent to you in your PM box

350

Coding Snacks / Re: Quick method to do simple task -must be a one click fix for those who need it :)

« Last post by questorfla on December 06, 2014, 03:07 PM »

might need you to as I do not know anything about "inno setup"  Never heard of it but if it does what I need this time, there are other times I have had (and will have) to do this again.
any way you can PM me or email or something so I don't have to clog up the board with something that probably wont help anyone but me?