trouble selecting tables
How can I trouble shoot this, please (it happens selecting any table from all of my DBs): Error SQL-query : SHOW KEYS FROM `answers` MySQL said: #1017 - Can't find file: './survey/answers.frm' (errno: 13) Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
web based admin?
why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)? (this will help me to learn :) tia - 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
quick install question about phpMyAdmin
i must be really new! i had no idea and read nothing that said the entire phpMyAdmin directory needed to be in a website folder. (i figured the entire folder need to be in there, is there another way?) how do you folks usually set this up? i mean, do you setup a whole website just to do "admin via the web"? - 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: will this work? [phpMyAdmin]
how do i configure phpMyAdmin? i'd rather be reading a manual but i cannot find one that i can understand. i have iTools, Apache and MySQL... and PHP4. i know MySQL works because i have made a db with my Terminal. but i have never made a login or password for MySQL, i simply logon to my computer as root. if PHP needs to be started and configured i do not know how. please help. i just want to get it running so i can continue. i am not allowed to post the phpMyAdmin list that i have subscribed to. as far as i can see there is no simple setup manual. thank you in advance. Ted - 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
will this work? [phpMyAdmin]
does the current version of 'phpMyAdmin 2.1.0 work with PHP 4.0.4? i downloaded 'phpMyAdmin 2.1.0 with php3 extensions' (from the php site) and my browser won't even open the file 'index.php3' as a file. and when i try to go to http://myhost/path_to/phpMyAdmin/index.php3 i get 'the requested url cannot be found on this server'. thanks for any help. also, in the setup of phpMyAdmin -i have created a db in MySQL but i have no login or password for MySQL -i just use it as is to test for myself. [OS X pb] - 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: copying databases
ok, fyi, the below worked fine. now... as readers here may know, this db newbie had problems getting MySQL up and running -much like the other person with pwd problems. i erased the drive (OS X pb/Tenon iTools), reinstalled and all is well, it even starts itself. i have created one db with several (3) tables of my own; i have not deployed it or even made the scripts (php) for it yet -i will :) now i know the manual talks about a password to sign in to MySQL and to grant privileges for dbs. so far i have always been logged into my COMPUTER as root. i have set *no other passwords* anywhere. last time i messed with the -p flag in MySQL i apparently got everything totally whacked. 1) should i establish a password with iTools admin? if so, should i do that first? does that affect the MySQL that i downloaded from Tenon's site? 2) should i establish a password with MySQL? is this a 'root' password? 3) and finally..., just for me, as root(?), must i establish a password for each and every db? i will figure out how to assign grants(s) and passwords for other users (besides me later; however, knowledge of the above (1, 2, 3) will expedite that greatly. thank you in advance for any help. thanks also for your patience with newbies, as you must know "newbie" focus (mine anyway) is spread out rather thinly all over the place! RTM in not always easy to grasp and tediously slow. TR At 8:41 PM +0100 2/11/01, jcmaes wrote: >Hi, > >This works perfect, I made it many times. > >The only point is that you may have to define access rights for that db. Do >so by using "grant" or copying the relevant records from the MySql database. > >regards, > >JC > > > >- Original Message - >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Sunday, February 11, 2001 7:55 PM >Subject: copying databases > > >> hi, >> >> i'm a stu so don't all the time in the world... who does! >> >> last night i took a MySQL database (a folder i got out of the >> MySQL/data folder) home and copied into the data folder on my >> machine, is this ok? >> >> unfortunately i cannot simply 'see if it runs' because i am having >> those terrible socket and password problems and so MySQL won't run at >> home, yet. :( >> >> but once i get it i want to be prepared. >> >> thank you. >> > > Ted - 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: Linking MYSQL to web sites
try here: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html hth At 1:38 PM -0600 2/11/01, Anna wrote: >- Original Message - >From: "S MODI" <[EMAIL PROTECTED]> > >> Hi, >> >> I am, currently a student a final year student studying IT For Business >> at Aston University In Birmingham. >> As part of my final year project I need to produce an online >> questionnaire with database functionailty. >> >> I have produced an HTML form, but now I need to be able to write the >> answers to the database. >> >> How do I do this ?? >> Can you point me in the right direction for any on-line web sites that >> are available for this kind of tuition. >> >> Many Thanks >> >> Sunit >> > >Look around http://www.php.net and http://www.phpbuilder.com for info on >PHP (a good language for interfacing with databases) >Look around http://www.mysql.com and http://www.devshed.com , among others, >for tutorials and info on using databases. > >Anna > > >- >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
copying databases
hi, i'm a stu so don't all the time in the world... who does! last night i took a MySQL database (a folder i got out of the MySQL/data folder) home and copied into the data folder on my machine, is this ok? unfortunately i cannot simply 'see if it runs' because i am having those terrible socket and password problems and so MySQL won't run at home, yet. :( but once i get it i want to be prepared. thank you. Ted - 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