[rudynorff]

Hello,

I'm new to PHP and MySQL. I've written a site and now I want to upload it to the servers of my provider.

how do I create my db and all the tables. i remember reading something about telnet. is that true? if so, where can i learn how to use telnet?

a second question. is it somehow possible to take the mysql db on my iBook and just upload the db to my providers server? that would save a lot of time!

Rudy

[bluedog]

Read up on importing tables into MySQL. It should be a fairly easy task. I don't have the expertise in using mysql and its command language.

If you can get a shell access account with your service provider (ask them), then use a telnet application to login to the account. You can find a telnet application or ssh application at <a href="http://www.versiontracker.com/" target="_blank">http://www.versiontracker.com/</a>

Shell access is just like using the terminal under OSX. As a matter of fact you can use your terminal to access the site via a shell command of 'terminal' or 'ssh'. Just type telnet <your service provider> and it will prompt you for a password. For ssh, type 'ssh -l <your username> <your service provider>'. The command contains a lower-case L. Either command will connect you to the server in a shell.

Be sure your service provider allows mysql on their server. They will have to grant you access to with a login and password where you can setup tables and databases.

Hope this helps some.

<small>[ 06-27-2002, 01:49 PM: Message edited by: bluedog ]</small>

[skalie]

Telnet knowledge is not necessary to work with a Mysql database.

The Mysql command panel sort of looks like a DOS command panel and you can create databases and tables and manipulate your data etc., although syntax errors makes this a tiresome process.

There are tools like phpmyadmin and mysqlfront which make the manipulation of databases very user friendly.

Then of course you can set up databases from the php pages themselves, mysql query etc. etc.

And yes you can transfer the database you have made on your iBook, i.e. localhost to your server, with mysqlfront it is a matter of drag and drop I believe.

[philzilla]

<a href="http://www.phpmyadmin.org/" target="_blank">try this</a>

[rudynorff]

Thanks so much for your help! The guy I developed the websites for has a spanish art gallery and so i made him a few websites where he could just type in a new artist, information and artworks. as you can probably imagine, every artist has a lot of artwork, so typing in all the infos is a lot of work and very timeconsuming!
so i installed him apache and php with mysql so he could edit the website at home. now we have to upload the mysql db to the server of his provider. so this is why i asked if it's possible to upload a db.

one big problem though!!!: what is mysqlfront (an app, a command??)

thanks again for all your help guys!
rudy

[skalie]

</font><blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif">quote:</font><hr /><font size="1" face="Geneva, Verdana, Arial, sans-serif">Originally posted by rudynorff:
<strong> what is mysqlfront (an app, a command??)
</strong></font><hr /></blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif"><a href="http://www.anse.de/mysqlfront/" target="_blank">http://www.anse.de/mysqlfront/</a>

An application, I guess you would call it, preferable, in my view, to phpmyadmin, although I have no idea if it works on Mac, I learnt my php mysql stuff on a windows platform, oops.

Anyway, best of luck with your ventures.

[rudynorff]

</font><blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif">quote:</font><hr /><font size="1" face="Geneva, Verdana, Arial, sans-serif">Originally posted by skalie:
<strong> </font><blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif">quote:</font><hr /><font size="1" face="Geneva, Verdana, Arial, sans-serif">Originally posted by rudynorff:
<strong> what is mysqlfront (an app, a command??)
</strong></font><hr /></blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif"><a href="http://www.anse.de/mysqlfront/" target="_blank">http://www.anse.de/mysqlfront/</a>

An application, I guess you would call it, preferable, in my view, to phpmyadmin, although I have no idea if it works on Mac, I learnt my php mysql stuff on a windows platform, oops.

Anyway, best of luck with your ventures.</strong></font><hr /></blockquote><font size="1" face="Geneva, Verdana, Arial, sans-serif">Yeah, it's a windows app i guess. but thanks, the person that is editing the data is using a windows machine, so no problem.

thanks again, rudy