Hello all, I have several questions in general since I recently started using MySQL. >From the manual I cannot find where these questions are covered. I hope someone can assist me.
Firstly though, if this is not the correct mailing list for my questions, please advise correct one. Secondly, thank you in advance for any assistance offered. Lastly; Background; I'm developing a website to be hosted when ready. The HSP I'm planning to use, provides MySQL facilities. I chose MySQL because I can develop said website and become familiar with it, then make use of the exact same technology once ready and live. Questions; 1. Assuming the website grows very large with high volumes and a database exceeds disk space, please advise what is the remedy? 2. Seeing as for the said website I use transactions, thus also the innodb options, please advise whether I can place individual databases at different locations. Note; it seems the filename.sym, does not apply to the innodb files, therefore only the database table definitions are placed in the filename.sym redirecting location. 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? 4. Please advise, with different databases do they all share one set of innodb files - thus if this is the case, how is data for different databases backed up separately? Over to you. Kind regards Emmanuel --------------------------------------------------------------------- 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
