Help I'm at a loss...

[Guest_imported]

Hi there.... I really could do with pointing in the right direction...

I am a novice ASP developer using access 97 & win 98...
The access database is using 2 tables with less than 100 records...

For various reason's I'm having to move My site to a different host...

Unfortunately my new host doesnt allow access 97 only mysql...
And guess what I've never touched it before...
I dont wish to install mysql on my own machine... Just use the DB provided by my hosting company.

I've spent hours searching various sites and I just cant find the answers to some very simple questions...

The Hosting Company does not offer any support(domainnames.com)but will create a DB..
However they will not create a table or fields within a table...

To upload files to the normal webspace they suggest using a ftp(this is no Problem).

To have access to the mysql server they state I should use SSH(not Telnet)...
Does the SSH allow me to create tables within the mysql DB or is SSH just an encrypted ftp software..

If SSH is not a tool which can be used for creating tables within a mysql DB can anyone recommend a freeware tool/software which will...

I understand that tables cant be uploaded to mysql db so I dont understand how a access db can be converted to a mysql file and then uploaded.

My mind really is blank at the moment from trying to study various help pages and documentation pages....

Please help.....ezeee

 

[mcdougall]

You can access your new DB on the MySQL server using PHP. You can also build your tables, get information from them and have them show in your browser all with PHP.

I'm very new at it too... working on my first project at the moment, but have found it pretty easy (if a little overwhelming at first). I also am moving from Access to MySQL, and you are going to LOVE the difference!

There are tons of tutorials out there as you've already discovered... Maybe if you focus on searching the PHP ones that will help you.

Good Luck!
~Carrie

 

[djhawthorn]

SSH just stands for "Secure Shell" - basically, telnet, but all traffic is encrypted. So yes, you can login and create tables and stuff using the mySQL command line interface, through SSH.

You need to download an SSH client to connect though. A recommended, freeware SSH client would be TeraTerm Pro, (which is a telnet client), then you can get an SSH addon for it. (Make sure you unzip the ssh addon into the TeraTerm directory, and execute ssh.exe, not teraterm.exe).

Alternatively, phpMyAdmin (I think its called) is a really good browser-based mySQL administration platform, and would make creation of tables and fields a lot easier. PHP is a requirement though for it to work.

Downloads..
TeraTerm Pro / SSH:

http://www.enteract.com/faq/ssh/teratermssh.html

phpMyAdmin:

http://phpmyadmin.sourceforge.net/

 

[djhawthorn]

Ack, TTP/SSH downloads don't work..

Use this link:

http://www.zip.com.au/~roca/ttssh.html

 

[Guest_imported]

Thanks to everyone for responding so quick.....

The SSH sounds very promising.....

Ive been using ASP and have no experience of PHP...

I've created a listing directory using ASP and Access 97..

Everything I've learnt has been Through back engineering and I've solved problems as I've come accross them..

I've just got a little out of my depth but thanks to your help I can see light at the end of the tunnel..

I'd post my site but I dont know if that allowed on this forum... If it is let me know... Any feedback would be appreciated...

Once again many thanks.... If you have any further advice it would be very much appreciated...

ezeee