Re: Some Basic Questions I can't Find Answers to

[Will K.]

Hello Linda,

You said ---> The MySQL database I want to run will be on my web host. Since I don't have the server physically in my possession, is the working method to install MySQL to my machine, develop the routines there, then upload them to my server?

You may not need to do this. Check your host's services, and see if you can login to your account using a terminal emulator, like putty, for telnet or SSH. Putty is a freebie that works for both telnet and SSH logins. Your host may or may not offer telnet or SSH as a service.

Another possibility is that your host might also have a PHPMySQL login panel that will allow you to work everything on the server remotely from your desktop. In this case, you wouldnt even need to use putty (though I like using both the PHPAdminPanel and the terminal emulator).

There are even other possible solutions that are a bit more involved. If by any chance you had tables developed in Access, for instance, then you could download and install an ODBC MySQL driver API on your computer that will allow you to login directly to the database to do import/exports on tables right from access. I am sure there are API's like this that would allow you to import/export tables, but your host would have to allow you to form an ODBC conneciton in the first place, so I would check with them.


You said --> I have attempted to install to my Windows 2000 pro system. Still fumbling with that. Should I be trying to install the version most like the one on my host's server? He's on Linux Apache. Will that cause a problem? ---

That sounds reasonable. But still you'll still need to form an ODBC connection if you go this route.

Just a note on importing and exporting if you use a terminal emulator. You can do it manually from the command line, like this:

To "export" all the tables in the DB to a directory on your server, you can use:

mysqldump -u username -p databasename > filename.sql

Here username and database name are your username and database name, and the filename.sql is whatever you want to name the file.

Once you have run dump the tables will be in that file in the directory (as a document external to the actual DB itself), and then you can just download them to your desktop via FTP. I think the PHPAdminPanel may also be of assistance for this, though I havent used it.

To reload data stored in files, just do this:

mysql -u username -p dbname < filename.sql

Notice the direction of the arrow. It determines whether the tables are coming or going. I use a little mnemonic thing where if the arrow points TO the database commands, then it is going INTO the Db, but it is point AWAY from the Db commands, then it is coming OUT of the database.

You said ---> I don't see anything in either of these books on uploading, which makes me wonder if they're assuming I have access to the actual server. Of course I do, in a limited way, but I don't see any explanations on how to access the MySQL on my virtual "machine" over at the web host's. ---

Again, if you can use a terminal emulator, then you'll have to login twice. Once to get into your account, and then a second time to get into the database. If you need more assistance on how to do this, then let me know.

HTH,
Good luck,

Will

P.S. Sorry to be so long-winded, but I just got through figuring all this stuff out myself. I know how hard it can be.



_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php