Some Basic Questions I can't Find Answers to
I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, 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? I've been going on that assumption and 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? 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. What am I missing here? Linda Carter - 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
RE: Some Basic Questions I can't Find Answers to
Linda: MySQL is a database and Apache is a webserver. They are two independent applications. To access the MySQL database, you will use CGI programming or JSP. Theodore Reph [EMAIL PROTECTED] -Original Message- From: Linda Carter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: Some Basic Questions I can't Find Answers to I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, 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? I've been going on that assumption and 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? 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. What am I missing here? Linda Carter - 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 - 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
Re: Some Basic Questions I can't Find Answers to
* Linda Carter I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, 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? That is a 'normal' way of doing it, yes. (But, of course, you don't _have_to_ install anything on your own machine, that is just for convenience, to make the development process easier.) I've been going on that assumption and 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? Yes, the two first digits of the version number should match, but mysql is mostly compatible with itself, developing on 4.0.x and having a production system on 3.23.x is normally not a problem. (Of course, some features are new in 4.0.x and not available in 3.23, you can not use those features.) He's on LInux Apache. Will that cause a problem? No. The only thing to be aware of is line endings in text files. On Windows, any text file you create/edit will have CRLF line endings. Text files created/edited on linux will normally have LF line endings. This is relevant if you use the LOAD DATA INFILE statement. 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. What am I missing here? hm... 'uploading'. One thing is uploading your routines, another thing is uploading the data. You will probably use LOAD DATA INFILE to load comma separated data into your local database first, and when the development process is finished, you dump move it to the production server. The data file below (the_data.sql) is produced by running mysqldump on an existing database. Uploading the data, from your local machine with mysql installed: mysql -h mysql_server_host -u user_name -p database_name the_data.sql If mysql is not installed on the local machine, you can a) install it, b) move the_data.sql to a machine with mysql, or c) move the_data.sql to the server. This will only work if your web host has opened for access to the mysql server from the outside. This is not always the case, sometimes only the web server of the ISP can access the db server. In that case, you will probably need some mysql admin utility, like phpMyAdmin. This utility will let you upload the_data.sql, and also provides basic browsing/editing functionality. URL: http://www.phpwizard.net/projects/phpMyAdmin/ Your 'routines' (PHP/Perl/Python/Java/C++/whatnot code), used to browse/edit the data, must be uploaded in the 'normal way', same way you would do for .html files (probably using a FTP client.) HTH, -- Roger - 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
Re: Some Basic Questions I can't Find Answers to
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
RE: Some Basic Questions I can't Find Answers to
I will assume that your hosting service supports MySQL, which most of them do. Also, most of hosting services allow you to administer your database using phpMyAdmin, in which you can create and drop databases and tables, run SQL scripts, etc. I will also recommend you to install Apache in your Windows machine and make the whole testing of your site in there before uploading the site to your host site. Adolfo -Original Message- From: Linda Carter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 11:18 AM To: [EMAIL PROTECTED] Subject: Some Basic Questions I can't Find Answers to I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, 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? I've been going on that assumption and 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? 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. What am I missing here? Linda Carter - 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 - 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