Newbie questions – setting up and getting started

[bronsti]

I'm sure these qeustions have been asked somewhere in here many times over… and I'm sure the answers are VERY simple to someone who is familiar, however it is not yet simple to me! 🙂 I know there are a lot of questions but if you know the answers to any of these… I'd appreciate it!

Here's my setup….

currently using live remote production server to test from Dreamweaver MX. Just got set up mySQL on the HOST server. Downloaded WebYog on my PC/Windows XP. I'm told I do not need to use mySQLadmin (or PHPadmin?) on my host's server and that I can/should use this instead as it's much smoother and easier to operate. (1) True or false? (2) and are there advantages to having a testing server on my own pc other than to save bandwith which is not an issue at this point because i have no visitors and a “light site” with broadband connection? – – – I key in my “mySql” database id and name from my host setup on the very first screen in webyog The first time (and only time) I did this it hung up and had to reboot. (3) Perhaps I was using the wrong info or does this indicate a bad install? (4) This initial info. should be what my host provides, correct? and finally – – – the web pages i'm working with i've had coded simply with a .htm extension as i haven't coded database or php yet, but just renamed them all to .php. (5) Do I also need to change the header code to reference php or is the extension enough to start adding php code? (6) i can't seem to change my entire site setup in DWMX2004 to php for some reason. am i missing something completely obvious here? (7) can i run both asp and php code in the same webpage? Sorry if these questions seem to elementary but i very much appreciate anyone's assistance…. i promise to help the next person someday!

[peterlaursen]

1) Maybe true and maybe false!

if your ISP has blocked port 3306 on which mysql normally communicates, you will EITHER need to use a program running on the server system at the ISP (such as phpMyAdmin) and connect through an ordinary web browser OR use tunnelling. Tunneling is supported by sqlyog entreprise but not the free version of sqlyog.

2) Personally I prefer a complete test system locally (web server + php-system + mysql-server – and if you like support for .asp and .jsp etc.). Then you can test your solutions before uploading to the production server. Further when using features such as SSI includes, php pages etc. they will not always show up correctly when just opening the file in the browser (though Dreamweaver in that respect is much better than fx. Frontpage). Opening from a local webserver will show the page correctly.

3) I don't quite understand. If you can't connect it could be because the 3306 port is blocked at the ISP or it could be a firewall-problem. I don't think you'd have to reboot – you should be able to shut down the sqlyog proces from task manager if it does not time out by itself. Current version o sqlyog is not multithreaded, so it seems like the program “hangs” when it's busy. the upcoming yougmax program will be fully multithreaded.

4) yes .. you should use this information. Look at a copy of my connection screen below. But again – if port 3306 is blocked you will have to use tunnelling.

5) It should normally be OK just to change .htm files to .php – provided of course that php is installed as a module in the web server. Your start page however maybe will have to be exactly “index.html” – but maybe you can configure that – that varies!

6) Don't understand! If Dreamweaver wont let you save the files as .php-files then just use an ordinary ftp-klient to rename the files on the server. I recommend SmartFTP http://www.smartftp.com.

7) concerning asp and php in the same webpage. I know absolutely nothing about asp –

– but it's likely that you run into a limitation with the server system that won't let you configure the same filetype as supporting both. (actually I can't even use SSI in php-pages due to a silly limitation with my ISP – on my local system it's no problem!)

[Ritesh]

1.) True. You need to use HTTP Tunneling feature available with SQLyog Enterprise.

2.) It is always advisable to have a complete development environment setup. It will make sure that you dont corrupt your data accidently. 😀

3.) Does SQLyog crash? If it is not able to connect to the MySQL server, then SQLyog will return you an error. Are you getting any kind of connection error?

[bronsti]

Thanks to both of you…

Regarding (2) re: testing server…. is there a one-stop download available to install Apache/PHP/webyog on my local PC w/ XP? …. and a new one…. using webyog… is it accurate that i will be able to syncronize/delete/create my entire database from here and simply upload it to phpmyadmin? or am i misunderstanding where the “live” database will be? I'm thinking that webyog is mearly a “translator” that pulls from and puts to my host's mysql database. i.e. will i still need to use phpmyadmin or would i ONLY use webyog?

Thanks again for the responses!

[peterlaursen]

you will NOT need to use phpadmin.

Differnt methods of connecting to a mysql-database are available. PhpMyAdmin uses the php interface – sqlyog uses the C-api's from mysql that are compiled into sqlyog.

[bronsti]

Mission complete…. thanks for everyone's responses!

[Author]

Posts