Newbie questions – setting up and getting started

[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