Posted in Computers & Tech / Databases
Author: WeaponX Total-Replies: 11

Hi, I downloaded a backup of my forum database and wanted to import it on my computer locally for testing purposes. This has always worked for me in the past, but I'm having some problems with it lately.

I'm backing up my database via phpMyAdmin->Database->Export->Select All and downloaded as a .gz file.

I'm using Windows XP Home with WAMP installed, so it has MySQL built in. It's version 5.0.27.

I ran all the services and at the prompt typed in:

mysql -u root -p backup.sql > testDB

My root account in WAMP has no password, so when it prompts for a password, I just hit ENTER. Then it shows me this error:



The path and filename are 100% correct....I'm positive on this. I downloaded the .gz file and had to extract it to get this SQL file. I have done this numerous times in the past without any issues.

I tried restarting the service and even as far as reinstalling the whole WAMP package, but to no avail.

Can anyone shed some light on this issue?

Thanks.

Posted in Computers & Tech / Programming / Scripting / PHP
Author: TavoxPeru Total-Replies: 2

Sometime ago i found and use another webserver that you can use on a USB stick or even on your camera's flash drive, it is called The Uniform Server.

The Uniform Server is a free product that you can use on the go because no installation is required to use it, and also it is an Open Source Project.

The Uniform Server is a WAMP package that allows to run a web server on Windows 95 or Windows 98 or Windows ME or Windows NT or Windows 2000 or Windows XP with the TCP/IP protocol installed correctly. You can use The Uniform Server as a production/live server or as a test server for your applications. There are also a miniServer Line of it that are smaller versions of the Uniform Server to make a more portable and mobile server environment on the GO, are fully secure and use the architecture of The Uniform Server for portability purposes.

Some of the products included in The Uniform Server Packages are:

1. Apache Httpd Server.
   
2. GoPear.
   
3. MySQL.
   
4. PHP Hypertext Proccessor.
   
5. phpMyAdmin.
   
6. phpMyBackupPro.
   
7. ActiveState ActivePerl.
   

Also this web server has some additional plugins available that you can download and use, including:

1. AWStats, to view your server's statistics.
   
2. Quick 'n Easy FTP Server, an easy to use FTP server.
   
3. PHP 4, a PHP downgrader that downgrades your PHP to version 4.X.X.
   
4. UniTray, run and control the server from your tray icon.
   
5. Resin 3, a Java Servlet for running JSP pages and serving java online.
   
6. SlimFTPd, another FTP server.
   
7. Tomcat 5, another Java Servlet for running JSP pages and serving java online.
   
8. Error Pages, some additional shtml pages along with a .htaccess to run the error pages for Apache.
   

I think that this is another option that deserves a try.

BTW, The Uniform Server works very fine when i run and test it, but the only problem i had with it was related with the port 80, so if you use this port first disable the program or whatever it is that is using it.

Best regards,

Posted in Computers & Tech / Programming / Scripting / PHP
Author: frazz86 Total-Replies: 6

If you need the link to download xampp here they are
Linux XAMPP
Window's XAMPP
Mac OS XAMPP
Solaris XAMPP

After the download has finished it should automatic come up with its setup if it does not come up with a set up follow these instructions:
Step1: Go to where you Installed the files
Step2:Click Setup_XAMPP
Step3:Follow its steps
Step4 Your back to where you should be!

Now click XAMPP_start and wait for it to load
OR
Click XAMPP_control This also serves the same purpose as XAMPP_start
Once you have opened the control then click start on Apache and Mysql

Once (xampp start) has finished loading and auto close
Once (xampp control) you have started Apache and Mysql
You can now start making PHP files Oh YEY!
once you have made a php file you can test it Put the php file in your XAMPP folder Under HT_Docs
And then type in your browser http://localhost/phpfilename
And your Php file will load !!
Have fun

Posted in Computers & Tech / Programming / Scripting / PHP
Author: marijnnn Total-Replies: 13

i meant the installer on www.php.net
you have a windows installer there.
should work fine.
but i think that, if you let it configure you iis automaticly, you won't be able to use php4 anymore. it will automaticly configure all .php files to work with php5
php4 & php3 files would probably still use php4, though you can choose to have them handled by the php5 engine during the installation.
i'm not sure why you would want to keep php4. almost everything still works with php5 engine. give it a try!

Posted in Computers & Tech / Software / Freeware
Author: t0nedef Total-Replies: 7

i've been playing around with html-kit for about a day and a half, it serves my purposes, all i wanted it for was syntax highlighting, i never did get the hang of all the wysiwyg editors, they never seem to do it right. the code almost always ends up messy, and doesn't look the same. for simple syntax highlighting support, the html-kit was perfect for me... but then again some people want more

also i find that for testing purposes, sami http server *on windows machines* along with php works great, the only problem that i have with it is updating the server directory when i add files... i have to individually add the file.... i'll be looking for an alternative server soon, but for its small size and memory footprint it has worked in my situation much better then apache could have *i don't need a full fleged web server to test php, just a simple on* on my laptop...

Posted in Computers & Tech / Programming / Scripting / PHP
Author: Houdini Total-Replies: 12

I generally notice confusion with new users to PHP and or MySQL and first of all I believe that unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox Netscape or any other browser that has been set.

PHP is a different matter to view the output of a PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply will not work. (Note serverside langauge requies a server) HTML is client side and requires only a browser so it will display by double or single clicing the file itself and the program associated with it will open it, but not so with PHP or ASP (Window servers only) or Perl. You must have a working webserver like IIS PWS Apache Solaris and so on, and the file must be accessed with a browser that sends a request for a page that resides on the server like one of the above mentioned.

All webservers have a ROOT where they keep files and other subdirectories. Normally you will have an index.html or index.php file (the server looks for these type files and serves them upon request of that file. With a PHP file the server will look up what you typed into to address bar and try to PARSE it (unlike HTML) to do whatever it is supposed to do, if PHP is not set up properly it will produce either errors or unexpected results or both. The webserver must know where the executable file is and this is set up in the servers sonfiguration file, then there are dlls that the PHP or other langauge will need to perform certain operations when asked to do so, if these are not set they will fail with errors.

If you are using astahost as a server usually you do not need to worry about this, but if you have some ideas about creating something that requires PHP on you site it would be best to place a webserver on your home PC or MAC and develop these programs there and when debugged to the point where you are satisfied then upload them to astahost.

I am a regular contributor to PHP Builder Forums and Dev Shed here and see these question all the time, I used to answer and try to help, but now it seems that installation of these services. My PAT answer anymore is to just download and install either XAMPP available here or you could use WAMP available here

This is not a tutorial but a post to try to help those that are new to PHP to get started in the right direction. While it is possible to install a server and MySQL and PHP on your own (with much frustration and questions) the programs I suggested will help you if all you really want to do is write PHP and MySQL routines to develop a site. This is just my opinion for newbies and I am sure that there will be those that tell me you should actually learn something from doing it on your own, but when I see people getting more and more confused trying to do this then I really wonder if the satisfaction of self installation is really that much a benefit unless that is your desired career.

Posted in Computers & Tech / What's New...?
Author: 8ennett Total-Replies: 5

This has taken me the best part of two days to solve and now I've got it working I feel so relieved I think I'll share the solution for anyone online who has the same problem. After constant googling I came up with either useless solutions that state the obvious or contain responses from people who offer no help what so ever.

The problem was I installed Apache 2.2.17 and PHP 5.2.14 on a x32 Vista Home SP2 HP Laptop. When I tried to start the apache server it wouldn't work. It did initially but when attempting to restart or stop and start the server it wouldn't. I even tried manually starting the apache server through the windows services app but it kept returning an Error 1067, which was no help at all, and the apache error log simply said it was PROBABLY a bad shutdown of the server previously.

I eventually narrowed the problem to PHP and not apache, after a lot of tedious trial and error work I might point out. As soon as I realised this then I gave up for the night and watched some DS9. Today I ran through a lot more tedious trial and error (because yet again the error log was NO help) and eventually narrowed the problem down to the extensions. If you don't have any PHP extensions included in your php.ini file then php and apache work perfectly. I thought it might have been a particular dll however the same error occurred no matter which or how many extensions were included in the .ini file. Obviously having no extensions in php is useless if you want to use a database, use OpenSSL in your php and so on so to make the whole excercise worthwhile I had to knuckle down and work on this specific problem as fast as I possibly could without hesitation or delay...12 hours later I finally got a working solution which you need to follow exactly if you are having the same problem.

Download Apache 2.0.64
Download PHP 5.2.9-2

Install apache as you normally would, then when installing PHP ensure you install EVERY sub-option. A spare copy of the php manual and also PEAR can't hurt really can it? Plus the client script is essential.

Next right-click on "Computer" (either on your desktop or start menu depending on how you have vista configured), "Properties" then on the side bar "Advanced system settings" and at the bottom of the new window click "Environment Variables".

Now in the lower box scroll down until you find an entry where the "variable" name is "Path", double-click on it and check the value of "Variable value" contains: C:\Program Files\PHP\ext\;

If it doesn't contain that value then add it to the start of the "Variable value" value, just MAKE SURE THE REST OF THE TEXT IN THIS BOX REMAINS UNCHANGED OR YOU CAN REALLY SCREW YOUR SYSTEM.

Right, now the problem should be solved. There seems to be some kind of problem with PHP 5.2.11-5.2.14 when installing it on Vista, and personally the 2.0.x version of apache is in my opinion the most stable.

So I hope this solves the problem in case anyone is having similar problems, and if one single person mentions Wamp in this thread then I swear to god I will e-Punch you lol Wamp is terrible, a complete novices choice, it's both unnecessarily complicated to configure both apache and php and also doesn't enable all configuration options in either as well. What they fail to mention is that it is a stripped down version of apache, mysql, apache and phpmyadmin and serves no advanced uses what so ever. So yes, any mention of Wamp and I will hunt you down and slap you round the face with a wet kipper. And don't even get me started on Xampp lol

Posted in Computers & Tech / Software / Internet & Network Clients..
Author: varsoft Total-Replies: 13

where do you test your applications? any 3rd party hosting or in your local machine.

what is the local machine 's OS

if its windows better choice is IIs that comes with windows 2000 and above or PWS that comes with windiows NT windows 98 till ME.

Posted in Computers & Tech / Software / Internet & Network Clients..
Author: sparkx Total-Replies: 38

I think port 80 is a default closed port for some modems and routers, you need to go to the router (type in your IP) if a router/modem page pops up then you need to do some configuring and you will NOT be able to access your site from your home network. I have never actually gotten this to work on my modem from quest but you may also want to try localhost. If your site appears it's a network error and not your computer (however since it's a windows computer it might some glitch). If it still doesn't work you need to edit httpd.conf and change the port to another port (reminder when changing ports the url changes to url:port ex port 8080 becomes localhost:8080. If it works then you may need to try port 80 from a computer not attached to your network (that is if you have a router).

If you still can't get it to work please post if you have a router or modem and what type of firmware it uses. This will allow people to help you better.

Thanks,
Sparkx

Posted in Computers & Tech / Designing / Web Design and HTML
Author: wanhafizi Total-Replies: 28

You know the best combination of webdesigning for me?

1. OS: Microsoft Windows XP
2. Web Server: Apache web server
3. Database: MySQL database
4. Dynamic page language: PHP
5. Page designer: Macromedia Dreamweaver
6. Graphic Designer: Adobe Photoshop

Honestly, i would like to use Mac or Linux instead. But, i was born with M Windows. I can't help it. What about u guys?

Posted in Computers & Tech / Databases
Author: xboxrulz Total-Replies: 5

Thing is that you need a webhost that supports MS Access, which unfortunately since Astahost only offers Linux hosting, you cannot use MS Access databases. You would have to resort to SQLite or MySQL for your databasing needs. They work similar to MS Access, but they just require server access, which Astahost provides. If you truly need MS Access databases, you would want to get paid hosting at ComputingHost.

As for having your form to be able to connect to a MS Access database, just simply upload your form and your database in the same folder and use ASP to store the data into the MS Access Database that you created.

xboxrulz

Posted in Computers & Tech / Software
Author: BooZker Total-Replies: 60

What is your most used software on your current system? Do not count anything that is deault on your PC such as Windows Movie Maker or Windows Media Player (Sorry if this is already a topic, but i searched and didn't find any)

Mine are:

Dreamweaver 8 (Website Creation/FTP/code editor/ect. Software)
Fireworks 8 (Graphics Software)
Adobe Photoshop 8 (Graphics Software)
AIM (AOL Instant Messenger)
Opera (Internet Browser)
iTunes (Music Player)
LimeWire (P2P Software)

Thats about all my software i use from day to day.