Is it possible to install prosper202 on multiple domains? I’m totally new to prosper202, and have a very little idea what I’m doing. The problem is that I have installed prosper202 on a subdomain (prosper202.site1.com). I guess that it is not required to install it for a second time in order to use it on a second domain of mine. Then as I want to install it in site2.com, I simply have to create a new subdomain in cpanel and move to: prosper202.site2.com. However the trouble encountered here is that I was getting the same data on the overview panel, whether I log into prosper202.site1.com or prosper202.site2.com. Is it true that the only way to keep the data separated is to install different instances of prosper202 in different directories? Continue reading
Online video streaming improvements that you should consider these days.
Think about where you watch most of your video. It’s your living room on your television. And was your most recent television purchase an increase or decrease in screen size? It was an increase, I’ll wager. We demand big, gorgeous video that fills the screen. This has been our expectation since we watched Sesame Street a hair’s breadth from the set. Anything less is simply unacceptable. Continue reading
What are the benefits of streaming media?
Time shifting – let me watch it NOW. Content targeting and depth – I can pick the content that interests me. While broadcast media can simulate each of these benefits to some extent, the real strength of streaming media comes when you can combine these 2 benefits – something that is almost impossible for a broadcast model to emulate. Continue reading
CAD drawing processing is looking as follows:
The client provides the drawings along with specifications for conversion to any format as desired. The studio converts them to CAD drawings utilizing their skilled manpower which included architects, engineers and industry specific professionals as per the client specifications and requirements. Continue reading
As mentioned in the previous post, Excel has a whole bunch of objects that can be manipulated to do whatever you need. The collection of all objects and how they relate to each other is referred to as the Excel … Continue reading
Posted in Programming
We’re now going to write a macro (not record it!) that will carry out the following task: Put the value 10 into cell A1. Put the value 20 into cell A2. Put the value 30 into cell A3. Put the … Continue reading
How to run CGI scripts written in Perl on Windows?
For testing purposes while building websites I’m using a web server (Apache) installed on the local computer on which I installed Windows. At some point, I needed to run on it the one available on the Internet CGI script, which was written in Perl. But in spite of that I had Perl installed which I downloaded from ActiveState and properly configured Apache (Options ExecCGI), the script didn’t work – server was showing error 500 (Internal Server Error), and server logs had two error messages: “The system can not find the specified path.: couldn’t spawn child process” and “The system can not find the path specified.: couldn’t create child process “. As it turned out, the server could not find the Perl interpreter. It was looking for it where the first line of the CGI script was pointing, which is in /urs/bin/perl. Because there isn’t such path in Windows, so there is no wonder that the script could not run.
The first solution that I tried was to replace Unix to Windows file paths – instead of /usr/bin/perl I put the path to the directory where I had Perl installed on Windows. The solution proved to be effective – the script launched. Despite this, however, I decided to look for another solution, because I wanted to have one version of the script, which will run both on Unix and Windows.
Fortunately, in Windows, you can also use slash “/” in the paths to files. It is possible to use the paths that start with slash – this refers to the path to the root directory of the current hard disk drive. In the case of CGI scripts running on Apache server the current drive is the one where server is installed on. The solution was therefore to create a directory on a disk where I installed the server /usr/bin and copy the file perl.exe there from ActiveState Perl directory. After this simple action I could use CGI scripts written in Perl also on Windows, without the need to modify them.
Importing large number of records in the sql file to the database – how to?
Importing large quantities of records to a MySQL database can cause many problems. By “large amount” should be understood a database dump file. Sql file that exceeds 500,000 records. In my case, the discharge had more than 2.8 million records. Importing such a database through phpMyAdmin was not possible because the script ends operation after importing about 190,000 records and importing it by pieces, available in the administration panel, did not pass the test (omitting the initial 190,000 records did not result in the addition of new). Interestingly, importing the file using the command line mysqlimport.exe also failed. What can you do in this situation?
Fortunately, this problem is by no means hopeless, and as it turns out, is very easily resolvable.
Please go to the website and download http://www.ozerov.de/bigdump/ php script, which is then placed on your server. The file bigdump.php serve a MySQL database configuration parameters with which the script is to connect and to which you import the data. Also send to the server database dump file: Bigdump.php sql file and serve its location. It is important that it was not extended (insert extended mysqldump option). This option is selected by default when you export the database in phpMyAdmin so be sure to deselect it. The only thing we have left to do is run the script and wait.
BigDump is a brilliant booster for importing large sql files. It is an ideal solution for servers that have set a short execution time. BigDump reads only small fragments of the sql file and imports it into the database, and then restarts at the point where you ended the previous cycle.
Posted in PHP
Tagged database, sql